Need help with MLM tracking in MS Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brent Taylor - 26 Apr 2005 23:24 GMT

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

Reply to this Message

jl5000 - 02 May 2005 01:34 GMT

This problem requires knowledge of recursive procedures, it is a topic not
easy to explain in this format, I suggest you read about recursive procedures
in an algoritms book, like in a visual basic bible type of book, what this
procedure will due is to scan all your table to extract all the levels and
store the results in a temporary table holding the number of levels that you
need, then it will use the stored values in the temp table for the report,

> I am working on a MS Access database to track the sales of a 3 Tier Multi-
> level Marketing system.
[quoted text clipped - 18 lines]
>
> Brent

Reply to this Message