By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,853 Members | 2,144 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,853 IT Pros & Developers. It's quick & easy.

DB Design for Memberships

P: 1
I need help designing a separate lookup database that allows me to find information about members quickly. On our main system each account can have 3 sub-members linked to it including the main which makes 4. They can only purchase an event once per member + sub member. Each member has its own 15 Digit ID.

I need help figuring out how to join Members and Events so i can easily lookup e.g 'Event Name' and It will return all the accounts & sub account(s) which have not purchased anything And possibly by 'Membership Number / Surname' etc.. We also must be able to see which main account id it is linked too on the results

Expand|Select|Wrap|Line Numbers
  1. MemberID  (15 Digit Char) 
  2.   Mem1 (Main Acc) (ID, Fname/Lname) 
  3.   SubMem2 (ID, Fname/Lname)
  4.   SubMem3 (ID, Fname/Lname)
  5.   SubMem4 (ID, Fname/Lname)
Expand|Select|Wrap|Line Numbers
  1. EventID
  2.   EventName (Which Event?)
  3.   Purchased (Has Acc had a purchase for said event?)
  4.   Members Available (Which members are still able to purchase for said event? [Needs Main MemID + First/Last Name of  SubACC)
Dec 21 '15 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.