Use of Subform?

  • Thread starter Thread starter Cathy b.
  • Start date Start date
C

Cathy b.

I have a one to many relationship between 2 tables, call them table A and
table B respectively. I would like to create a form that shows data from
each row in Table A and data from all of the corresponding rows in table B,
all on one form.

Table A.Order 1 Table A.Date of Order 1 Table A.Company

Table B.Item
Table B.Item
Table B.Item


I can't figure out how to do that. When I open the form it shows a separate
page for each record in Table B. I am using Access 2003 and I am totally
unfamiliar with sub-forms.

Thanks for any help you can give.
 
You'll need to have a main form based on Table A (or a query thereof)
with a subform (probably continuous or datasheet view) based on Table B.
The Master/Child link would typically be OrderID, or whichever field
is used for the relationship between the two tables (the Primary Key
field in Table A and the Foreign Key field in Table B).
 
Back
Top