Subdata Sheet

[PL]

For Access 2003.

For a subdata sheet,
what's the Master field & the Child field?
Which field belong to the Main table vs the Secondary Table?
For eg, if I have a column "Items" in th main table, and I wish to see the
Order Details for each item, what should I select in the Master & Child field?

Thank you

 

[Tom van Stiphout]

On Tue, 31 Mar 2009 20:06:01 -0700, PL <[email protected]>
wrote:

Check out some sample applications.

I suspect your OrderDetails table has an ItemID foreign key, and your
Items table has an ItemID primary key. If so, set the LinkMasterFields
and LinkChildFields both to ItemID.

-Tom.
Microsoft Access MVP