Hello, I have been searching the internet the whole time but I cannot find the right solution for me. I am trying to create a new database for a networking company. My boss wants me to program it in a way that when a certain member recruits another person into the company, that recruiter will automatically accumulate a certain number of points into his/her account. This is also the same general concept when a registered member places a purchase transaction with the company. For example, for every 1,000 worth of items purchased, he/she will accumulate 5 points into her account. 

 

 

 

I hope you can help me with this. Thanks!

I am not quite sure what your question is. It seems like there are two of them. Or is the other one an example (in which case it doesn't quite fit)?

 

 

If you have a table a of Members, with a field for RecruitingMemberID, you can construct a self-join relationship using:

Members::MemberID = Members 2::RecruitingMemberID

where Members 2 is another occurrence of the Members table.

 

 

With this in place, a calculation field (result is Number, Evaluate from the context of: [Members]) =

Count ( Members 2::MemberID )

will return the number of people each member has recruited.