I think this is a real noobie question but can someoen explain?

[AWilderbeast]

Hi, i know i have done this before but its been so long and i know its real simple so here goes:

Say i have a record in a table and i want to add records to that record in another table does simply creating a relationship between the two tables make sure the information is relevant to that record and how do i add more than 1 tables information to a form so i could show the record from the first table and say all of that persons orders from another table?

Thanks for your assistance
Alex

 

[neileg]

If I understand you correctly, you do need a relationship but you would normally handle the parent child relationship in a form/subform.