Logic problem!!!

Hi all,
(hope you all will read my problem below)

I would like to do some checking before add into the database.
My problem is
Description:
User 1 -->User 1A | User 1B | User 1C | User 1D
User 1A --> User 1A1
User 1B --> User 1B1 | User 1B2
User 1C -->
User 1D -->

Above are divided into 3 layers.
Layer 1 = User 1
Layer 2 = User 1A | User 1B | User 1C | User 1D
Layer 3 = User 1A1 , User 1B1 | User 1B2

It means: User 1 has User 1A, User 1B, User 1C and User 1D. (Each User can only have maximum 4 subsequent Users)
          Each User 1A, User 1B, User 1C and User 1D can have its subsequent User also as stated above example:
              User 1A has User 1A1 and User 1B has User 1B1 as well as User 1B2. The list goes on and on but with
              the restriction of each User only allow to have 4 subsequent Users only.

So now my problem is , by refering to above description, let said if User 1 has a new subsequent User to register, then this User should be
show as "User 1E". But since each User only allow to have maximum 4 Users then this "User 1E" would be add
below its childs. Mean the application will check if User 1's subsequent Users already full, then
the application will check it's child Users of each User 1A, User 1B, User 1C and User 1D. If User 1A still
have room to store another User then "User 1E" will be put under User 1A.

I hope you guys understand what i'am trying to say here and my problems.

Its kind of hard to describe but no choice.

Hope for a solution from you all.

thanks
kenStart Free Trial