Whats best implementation for...

Hey everyone, I'm another newbee here so I really would appreciate some help.

I've got to create a relational database in SQL and need have a relationship between 2 tables that I don't know the best way to implement. I've done the rest of it but this is holding me back.

I've got tables representing an office and a worker.

The Office has many workers and just one manager. The manager is also a worker.

I thought of storing the OfficeID with a worker and the managerID (a workerID)with the office.

The problem is, this allows a worker to be a manager of an office that they themself do not work in.

Could anybody tell me the best way to implement this so that a manager can only manage an office that they work in.

(I hope that made sense!)

Thanks, Thal.

The database sounds good in that case. What makes the error ?, maybe you put the wrong query when displaying the record ?