Tables

[Big Phil]

Is it possible to get a table to automatically copy a field fro 1 table into another eg I have a table with members names and I want to use the membership id number in that table to link to a table that I can put the members childrens names in. I could stick them all in one table but it gets a bit big to handle and I thought two tables would be better. I am basically trying to avoid entering the membershir number twice. Hope you can help. Big Phil

 

[Dirk Goldgar]

Is it possible to get a table to automatically copy a field fro 1
table into another eg I have a table with members names and I want to
use the membership id number in that table to link to a table that I
can put the members childrens names in. I could stick them all in one
table but it gets a bit big to handle and I thought two tables would
be better. I am basically trying to avoid entering the membershir
number twice. Hope you can help. Big Phil

Use main form/subform arrangement, with the main form based on the
Members table and the subform based on the MembersChildren table. Use
the MembershipID field of the Members table as the Link Master Field for
the subform control, and the MembershipID field of the MembersChildren
table as the Link Child Field. On the subform, you don't even need to
show the MembershipID field, so long as it's in the form's recordsource.