tuckcorp
asked on
Infopath
Hi, I have been given the task of designing a info path solution to track referrals.
I get entered into the system I get a I'd.
If I refer somebody else my ref feral I'd gets place in the refferedby field. But I need to track one level down to give credit. So if I refer somebody and they refer somebody then I get credit and they get credit for that referral.
Client A refers client B
Client B refers client C.
Client B gets credit for Client C
Client A gets credit for client C because it is one level down. How can I track one level down. It is easy to track who I reffered,but harder to track who I reffered,reffered
I get entered into the system I get a I'd.
If I refer somebody else my ref feral I'd gets place in the refferedby field. But I need to track one level down to give credit. So if I refer somebody and they refer somebody then I get credit and they get credit for that referral.
Client A refers client B
Client B refers client C.
Client B gets credit for Client C
Client A gets credit for client C because it is one level down. How can I track one level down. It is easy to track who I reffered,but harder to track who I reffered,reffered
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
A->B
A->D
B->C
B->E
B->F
C->G
D->H
The above table demonstrates a tree structure. To read the structure you have to write a code similar to computer's folder structure. The algorithm is called recursive algorithm.
Cheers..