469,331 Members | 4,122 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,331 developers. It's quick & easy.

Need Help on MLM database in MS Access

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
Nov 13 '05 #1
3 3432
Brent,
It concept, it is a hierarchical data problem. Others here have solutions
different from the three I know about. Each solution to this problem has
its benefits and drawbacks. Study each one to decide which works best for
you.

Solution 1:
Single table joined to itself and modeling a one-to-many relationship
between a row in the table and other related rows in the same table.

Solution 2:
Two tables, one is the detailed information about each thing in the
hierarchy (sales representative in your case) and the other is a two column
list of primary keys from the first table that lists which thing in the
first table is related to the other and modeling a many-to-many relationship
between a row in the first table and another row in the first table.

Solution 3:
Two tables like Solution 2 but with as many columns as are needed in Table 2
to list each level of the hierarchy. This can make navigating the hierarchy
easier in some cases.

--
Alan Webb
kn*******@SPAMhotmail.com
"It's not IT, it's IS"

"Brent Taylor via AccessMonster.com" <fo***@nospam.AccessMonster.com> wrote
in message news:7e******************************@AccessMonste r.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

Nov 13 '05 #2
Thank you for your response. I thought about the 3 items that you wrote but
I am not really sure how you mean to apply them.

Can you give me any further info?

Thank you.

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #3
Brent,
I replied elsewhere that this is not a simple problem. There are software
companies that sell packages which will do what you want. If you have more
time than money then I suppose choosing to try and make something would be
worth it. But be aware that custom software development can be a
hair-pulling and frustrating experience for client and developer alike.
You've got to have the stomach and balls for it.

--
Alan Webb
kn*******@SPAMhotmail.com
"It's not IT, it's IS"

"Brent Taylor via AccessMonster.com" <fo***@AccessMonster.com> wrote in
message news:57******************************@AccessMonste r.com...
Thank you for your response. I thought about the 3 items that you wrote
but
I am not really sure how you mean to apply them.

Can you give me any further info?

Thank you.

--
Message posted via http://www.accessmonster.com

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by Heather Stovold | last post: by
2 posts views Thread by Bobby | last post: by
4 posts views Thread by Jake Jessup | last post: by
7 posts views Thread by Tee | last post: by
16 posts views Thread by peshekeedweller | last post: by
21 posts views Thread by nihad.nasim | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by haryvincent176 | last post: by
reply views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.