Link to home
Start Free TrialLog in
Avatar of Shawn
ShawnFlag for Canada

asked on

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?
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Shawn

ASKER

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