Thread: linking tables
View Single Post
  #1  
Old December 9th, 2008, 06:34 PM posted to microsoft.public.access.tablesdbdesign
fedsec
external usenet poster
 
Posts: 1
Default linking tables

I have a table (tblMembers) with member info and an other table (tblFamily)
to link the member to a family. Each member has a MemberID and a multiple
members have the same FamilyID. I've created an additional table
(tblRelation) to store the the type of relation for/to each member to the
other (ie. a single member can be wife, sister, mother etc.) I'm having
trouble finding an easy way to enter that data from a single "new member"
form.