Can this be done in Access?

[ice52us]

Hello. I'm wondering if Access is appropriate for this type of functionality.

This is for an MLM for my downline.

I want to have a basic table like this:

ID - Name - Referrer ID
8 - Bill - 4
9 - Rose - 2

When I press on each record, or a nearby button, a detailed record (or form) of that person pops up. Example:

ID - Name - Phone - Email - Earnings
8 - Bill - 8187898391 - bill@gmail.com - 347

The detailed record should also display the upline (chain of people referring this customer. Example: Bill was referred by Tina, ID 4. Tina was referred by Dave, ID 2. Dave was refereed by Steve, ID 1.) built using the IDs of referrers.

It should also display the downline (people that this customer has referred. Example: Bill referred Andrew, ID 21 and Andrew referred Jenny, ID 30. All these will appear in the downline).

Would look something like this:

Upline
ID - Name - Earnings
1 - Steve - 1443
2 - Dave - 587
4 - Tina - 204

Downline
ID - Name
21 - Andrew
30 - Jenny

When pressing on each record in the upline or downline, you can view a detailed record of them too.



Another crucial functionality of the detailed record should be a PAYMENT MADE button. When pressed, the earnings fields of the upline people will be updated (as the upline members make commissions from the downline member's payment) using a formula.

Is this something Access was designed for? If so, how can I accomplish this? If not, what is a more suitable program?

[khalid]

Hi, Welcome to the Forum.

You like to add the records for upline and downline (The Master form and Child subform), I believe.

In Ms-Access you can do that by creating subform inside the Master form and can use the FK (one to many relationship) for your subform data.

[ice52us]

Can I get an answer from somebody who is not a degenerate?

[ajetrumpet]

Can I get an answer from somebody who is not a degenerate?

YES. but you can also get answers from Degenerates. There's all kinds here. People that know something and people that pretend to know something.

as far as your attitude is concerned, I would suggest that you not respond like that to someone like Khalid. I don't know the man, but I do know that most foreigners that work in technology, even though they might not speak perfect English, are becoming extremely intelligent at this point in time, if they're not already there.

This post I think proves a high level of ignorance for yourself. Congrats.

[khalid]

Can I get an answer from somebody who is not a degenerate?

I think Adam gave you the best answer to your post
Keep searching for better reply...