Membership Database Structure

  • Thread starter Thread starter Sandy
  • Start date Start date
S

Sandy

I apologize for the double post - I posted this under
setup&config by accident. It should be here.

Hello Everyone!

I'm trying to set up an Access DB to keep track of all the
members in my local hiking club. I have a database
already set up, but I'd like to "link" records. For
instance, a family membership that has 1 husband, 1 wife,
and 3 children. I'd like to have a "master" record, then
when I bring up that master record, it will bring up the
other three members. There ARE four members and each has
their own member number. I just want a way that when I
bring up one record (say the husband), it will also have
the wife and three children listed.

Is there a way to do this?

Thanks for your help!

Sandy
 
You're absolutely right! Did not see it from that angle.
I'll give your suggestion a try!

THANKS! You have no idea how much you've helped me!!

Sandy

-----Original Message-----
One family may have several members. One Member may have
Click to expand...
several families. (Dad was married twice, Dad is member
to GrandDad's family, etc) This is M:M so you need a
junction table.
 
Back
Top