NEED HELP ON MS Access

  • Thread starter Thread starter Brent Taylor via AccessMonster.com
  • Start date Start date
B

Brent Taylor via AccessMonster.com

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.

Example:

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,

Brent
 
Brent said:
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.

Example:

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,
Click to expand...

You will either need a "many to many" relationship (detailed in help) or may
need to have a table that references itself and use code to get an exploded
view.

sponser 10
sponser 11
sponser 12
sponser 121
sponser 122
sponser 13
Sponser xxxx
 
Back
Top