Hi Nelly what you have hear is a case of many to many relations you should do is create a table to map the agent childs ex. with 2 fields the first will have the parent agent code and the second will have the child agent code.
>Hi
>
>I've been asked to design a database. Im having trouble with it though, it sounded easy at first but i just can't get my head around it.
>
>I need to store all AGENTS details which is the easy bit, but each agent is known as AGENT(A), these agents then recruit 4 people, known as AGENT(B), agent(b) recruit 4 people each known as AGENT(C) ect.... (but each agent is also an agent(a) as I need to monitor all agents progress to layer (D) before agents(a) work is completed. The database must be able to list all connected agents on request.
>
>Hope you understand, any help would be great!
>
>Cheers
>Nelly
Alexandre Palma
Senior Application Architect