Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 911
  • Last Modified:

table setup question

I am setting up an affiliate program and need a little help setting up the tables.

Each new Affiliate can be Sponsored by one person and once an Affiliate is set up he can Sponsonr as many people he likes.

the first table is tblAffiliates with AffiliateID, Name, email and possibly SponsorID (just another AffiliateID)

the next table to set up would be tblAffiliateSponsors with AffiliateSponsorID, AffiliateID, SponsorID (this would actually be another AffiliateID. just 2 different people)

something just seems strange.

any advice on how to set this up?
0
Shawn
Asked:
Shawn
  • 2
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Can a single person be sponsored by ONLY one person?

If so, then including the SponsorID field in your Affiliates table (and linking that back to the AffiliateID) should work. This is a "self-join".
0
 
ShawnAuthor Commented:
yes, only one person.

ah right. So when I if I want to know all the people Bob has sponsors I do a query on the same table with Bob's ID as the filter
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Yes.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now