Adding new table information into a form with existing data

[Guest]

Hi

Can anyone help me with a question with regards to adding another set of
table information to a form without simpley adding fields to the table the
form is linked to?

For example say I had a form (form1) based on a table (table1) containing
information on 2 fields name and house No. Creating the form in form wizard
for this is simple.

3 months later I now want to then add information on phone numbers for these
people. How would I now take information for phone numbers from a seperate
table (table2) to be displayed in form1?

I know you can just simpley have another field in table1 for phone numbers
and it writes into the form but I want two seperate tables all rolled into
one form. I have it in my mind that its a case of creating the form again in
form wizard where you can select your tables and the fields you want to drop
into a form but dont want to do this . Would it be a case of creating a text
box or something appropriate in the form and then simpley linking it to the
phone number field in table2, if so how is this done?

I know how to use primary keys and the importance of them in marrying up the
right information with each other when they are in different tables.

I apologise for my long winded question but all those in the know I expect
you know what I'm on about and any help would be much appreciated.

Olly

 

[tina]

if you're putting the phone number data into a separate table, i'm assuming
it's because one record in table1 (people, or companies, perhaps?) may have
many associated phone numbers (home, business, fax, cell, message, etc).
that's a one-to-many relationship between table1 and table2, and is good
basic design. usually you present these parent/child tables in a
mainform/subform setup. bind table1 to the main form, and bind table2 to the
subform. set the subform control's LinkMasterFields property to the primary
key in table1, and set the LinkChildFields property to the related foreign
key in table2.

hth