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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting multiple memberships 1
How to make a database out of this 4
how to handle children of parents in contacts table 2
Table(s) Design and Relationships 3
linking fields from different tables in same database 4
sorting a report with two tables 1
How to concatenate child fields? 5
TOO MANY INDICES IN RELATIONSHIPS 2

Back
Top