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?