By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,635 Members | 911 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,635 IT Pros & Developers. It's quick & easy.

Table relationship question

P: n/a
I have an interesting problem that I need some help with:

I have a residential home listing that is ONE address to MANY
residents (as people move in and out)

I want to have the current resident(and past) in the database, yet I
have a need to have the owner listed if the resident is a renter (in
case we need to contact them.)

Is the best way to set this up like this?
ONE Address, MANY Residents -AND- ONE Address, MANY Owners

The duplication of Owner/Residents in both tables is making me doubt
that it is the best way 70% are Owner/Residents and not seperate Owner
and Renter.

or is there a better way?

Any help would be appreciated.
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.