We have a very interesting and a challenging requirement from one of our clients, following is the scenario:

Consider there is a customer Cust-A.
Cust-A can refer one or more customers. Say, Cust-A refers Cust-B and Cust-C.
Further Cust-B and Cust-C can refer one or more customers.
This chain of referal can go upto any level.

Now, on each customer record we want to calculate total number of refered customers in the entire chain below that customer.

Has anyone come accross such a scenario or have any suggestion on how this can be implemented.

All suggestions are welcome and appriciated.

Thanks,
Vijay

We have a very interesting and a challenging requirement from one of our clients, following is the scenario:

Consider there is a customer Cust-A.
Cust-A can refer one or more customers. Say, Cust-A refers Cust-B and Cust-C.
Further Cust-B and Cust-C can refer one or more customers.
This chain of referal can go upto any level.

Now, on each customer record we want to calculate total number of refered customers in the entire chain below that customer.

Has anyone come accross such a scenario or have any suggestion on how this can be implemented.

All suggestions are welcome and appriciated.

Thanks,
Vijay