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


P: n/a
I am working on a MS Access database to track the sales of a 3 Tier Multi-
level Marketing system.

I have created a table to track a new RepID and a SponsorID. I have created
a query that will show the Sponsor and all of their reps but I am not sure
how to show the reps that the second tier has sponsored.


RepID 0011 SponsorID 0010
RepID 0012 SponsorID 0010
RepID 0013 SponsorID 0010

The above is easy but I am not sure how to get:

RepID 0014 SponsorID 0013 and his SponsorID 0010

Does anyone have any idea of a good way to do this?

Thank you,


Message posted via
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
You need to build a query that links this tabe to itself, but mapping the
SponsorID to the RepID:

SELECT Rep.RepID, Rep.SponsorID, Sponsor.Sponsor ID
FROM SponsorTbl as Rep
INNER JOIN SponsorTbl as Sponsor ON Rep.SponsorID = Sponsor.RepID

Message posted via
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.