Hi John,

Frop your original message, I think you were calculating the bonuses for an up-line on a multi-level marketing scheme.

I'd define the structure of the table something like:

MemberID INT  && unique ID for each member
ParentID INT  && ID of immediate up-line member - 0 for root of the tree
Sales CURRENCY  && Total sales for this member

In this way, you can use the SQL technique I describe in the FoxTalk article available on my site to get the sales for each member and their subordinate members.

You can also get information about how many levels of members there are under each member and so on.

Cheers,

Andrew

>Hi,
> Thank you for your sample code and info. Seem, I do it wrongly at the beginning, save data in defined relationship. Could you tell me, how should I define the level?
>
>Ex.
>Item
>A01, B01, C01
>
>Package
>AA01 - A01, B01
>BB01 - AA01, C01
>
>Refer to the case above, What is the level for AA01 and C01?
>
>Thank you