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