relationship question

[kpryan]

HI
I need some professional advice on a relationship.
I have three tables, broker table staff table and a client table.
The staff relationship will be a one to many, as a staff member can have many clients.
However a client can have many brokers and a broker can have many clients.
For example, a single client can be serviced by at least three brokers.
And of course a broker can have many clients.What would be the best way to arrange the client / broker relationship. I would have a one to many relationship for staff/ client.
Would you use a many to many relationship with the broker and client here and if so how would it be set up

Many thanks,

KP

 

[PHV]

Use a bridge table with a composite primary key (broker key, client key).

http://r937.com/relational.html

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886