multiple addresses with a complaint list

  • Thread starter Thread starter lamac
  • Start date Start date
L

lamac

I have a list of water users in a city and some of these
users own several properties in this city. I need to
make an unique list showing the users and their multiple
addresses all on one form along with the problem
associated with the one address that might have a water
problem at their site.

Please let me know how to set up this form.
Thanks for your help.
 
You posted in the tablesdbdesign newsgroup -- and your issue may be with
table design, not "form", as you indicated.

From your description, there is a one-to-many relationship between water
users and properties. That is, one "user" may have several "properties".

How does your table structure reflect this relationship? If you don't have
a table of users, a table of properties, and a table of user X property, you
may not be handling all the situations. Notice that I've gone beyond what
you described. The three table approach I provided allows you to have more
than one user "owning" a given property. If this is NOT your situation, you
can get by with including an "owner" field on the Property table, and
filling it with the OwnerID (?userID) of the user who owns it.
 
Back
Top