A
Allison
Access 2003 SP3
Win XP SP2
I need help with the best way to associate lots of similar children to one
parent.
Current set up is as follows:
Parent is "Contact" - associated to table of same name
Children are all "Address" - associated to table of same name, with
ContactID a foreign key to the table
One Contact can have several Addresses
Right now I have "Contact" as a main form and "Address" as a subform. Works
great with only one address, but I don't know how to add a second, third,
etc. address for the same contact.
Ideally, I'd like to display each separate address on its own tab in the form.
______
1. Is this the most-efficient way to accomplish this?
2. If not, how should I restructure the tables/forms?
3. If yes, how do I get multiple addresses within the main form?
Thanks for your help.
Win XP SP2
I need help with the best way to associate lots of similar children to one
parent.
Current set up is as follows:
Parent is "Contact" - associated to table of same name
Children are all "Address" - associated to table of same name, with
ContactID a foreign key to the table
One Contact can have several Addresses
Right now I have "Contact" as a main form and "Address" as a subform. Works
great with only one address, but I don't know how to add a second, third,
etc. address for the same contact.
Ideally, I'd like to display each separate address on its own tab in the form.
______
1. Is this the most-efficient way to accomplish this?
2. If not, how should I restructure the tables/forms?
3. If yes, how do I get multiple addresses within the main form?
Thanks for your help.