Identical Fields in Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I have a membership database and have tables with the members in it and a separate table with thier childrens name in it how do I make sure the right children are with the correct members in a one to many relationship I am new at access and struggling a bit
 
If I have a membership database and have tables with the members in it and a separate table with thier childrens name in it how do I make sure the right children are with the correct members in a one to many relationship I am new at access and struggling a bit
Click to expand...

You will need a MemberID (or some such field) as a Primary Key of the
member table (you should NOT use the person's name for this purpose,
since names are not unique). The table of Children should have its own
Primary Key (ChildID let's say), and also a MemberID field of the same
datatype as the Members table MemberID.

For data entry it's convenient to use a Form based on Members with a
Subform based on the children table; if you use MemberID as the
master/child link field of the subform, Access will keep the link
intact for you.
 
Back
Top