subdata sheets

[PL]

To insert a subdatasheet.

What's the
1) Child field
2) Master field?

Thanks

 

[Wayne-I-M]

Hi

Best bet would be not to use them. You should not really be using a table
to view/edit/delete/etc data.

Use a form / Subform or a query for this

But if you (for some strange reason) really want to use a subdata sheet then
the Master field is the ID of the table you are looking at and the child
field is the ID of the other table (the sub data sheet).
This said you don't have to use the ID's you can use anything that links the
tables
So you could show all people name John or everyone with the same Zip/Post
code etc, etc.

But again this is NOT a good idea and it will go wrong in the end ?, so best
to use a query or a form instead of using the table to type "stuff" into.

HTH

 

[Wayne-I-M]

sorry that was wrong ooops

the Master field is the ID of the table you are looking at and the child
field is the ID of the other table (the sub data sheet).

The child field is the "linking" field in the 1st table that is linked
(normally) to the ID in the "sub" table.

Sorry about that - should put my brian in order befor I answer