Issues with MLM type Formulas/Relationships
Hey guys, I have a question. I am trying to build an app for paying an mlm type payment system. I have it worked out where the payments for each person and their shared commissions pull into a table. I cannot for the life of me figure out how to calculate the total amount of the overrides.
I have four tables set up that I will need for sure with an optional fifth. I have a table for sales team members (IBOs), which is the parent to both the commissions and shared commissions table. I then have both of these tables set up as parents to a payments table which pulls in the payment information to combine under one IBO. I will obviously have multiple payments for each IBO so I have the key field set to being a concatenated version of date+ID number, converted to text which is working great, I just cannot figure how to get the sales numbers to total.
I need it to look at if IBO # (from one record)= Mentor IBO (from another record in the same table) then pull in the total from a number formula field from the record they show as the mentor IBO.
It seems like it won't look at separate records. It's driving me crazy!
I have four tables set up that I will need for sure with an optional fifth. I have a table for sales team members (IBOs), which is the parent to both the commissions and shared commissions table. I then have both of these tables set up as parents to a payments table which pulls in the payment information to combine under one IBO. I will obviously have multiple payments for each IBO so I have the key field set to being a concatenated version of date+ID number, converted to text which is working great, I just cannot figure how to get the sales numbers to total.
I need it to look at if IBO # (from one record)= Mentor IBO (from another record in the same table) then pull in the total from a number formula field from the record they show as the mentor IBO.
It seems like it won't look at separate records. It's driving me crazy!
