Help regarding tables/forms

  • Thread starter Thread starter CCB
  • Start date Start date
C

CCB

This is my first ever database design with little or no access training.
Please excuse me if this is a stupid question.

I have multiple tables set up for different types of information on my
database.

The key to all my tables is a number - unique to each 'customer'. Each
customer can have multiple types of addresses. I have 3 so far - for
example, home address, work address, other address.

When filling out the form, you will get a drop down box to select which type
of address you're entering.

Since I have 3 types, will each entry create a unique record on the table to
correspond with the 'customer number' it relates to, or on my form do I have
to have multiple occurrences of address to accommodate each type of address?

Is that clear as mud?
 
If you are saying you have a table of customers and a related table with
addresses, then you need a sub form that will show all the addresses for the
customer.
 
Back
Top