Membership Database Structure

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
 
G

Guest

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
several families. (Dad was married twice, Dad is member
to GrandDad's family, etc) This is M:M so you need a
junction table.
 

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

Top