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).
--
_________
Sean Bailey
"Cathy b." wrote:
[Quoted Text] > 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.
> --
> Cathy B.
|