i don't know how to call it.
it's business sale
special : customer have point. please download picture
one customer have only 2 customer

when customer4 sale product form me . point of product will share give point to customer2 and customer1



or when customer3 sale product from me. point of product will give only point to customer1

sorry if i say difficult.

i'm so sorry if you don't understand me

Please see if I understand you correctly. Is this essentially a multi-level marketing scheme? The members (you call them customers) are arranged in a binary tree, so that there are two descendants from each customer. When a customer makes a sale, you want to reward their ancestors in the tree.

Do you reward all ancestors, or is there some limit to how many customers participate in a given transaction? Is the reward the same for all the customer ancestors, or do different ancestors get different rewards?

Some database engines can handle this problem directly with a single statement, others need compound statements or even scripts to do this. What database do you plan to use?

-PatP

i want to use SQL server 2005

how do you design this database?

how do international programmer design this style database?

i use vb.net 2005 to write program.

i ever design it but i think it was difficult for write code

can you help me ?

You need to answer the two questions I asked so that I can help you.-PatP

"Do you reward all ancestors" -> reward only ancestor

"Is the reward the same for all the customer ancestors, or do different ancestors get different rewards?" -> the reward the same for the member