Table look to itself

[Zelandakh]

I can't see this in the FAQ.

I have got a little HR system I'm putting together and I've done most of it and am really pleased with the look. However...

tblEmployees = ID (Autonumber), Firstname, Lastname, Department...etc.

I need to put in a field for Manager that is a drop down box of Employees from the same table, ideally excluding that record as you cannot be your own manager.

Access won't let me do it and I understand why but surely this is possible?

 

[Remou]

Are you trying to use a lookup field in a table? It is not good practise:

http://www.mvps.org/access/lookupfields.htm

 

[dhookom]

Data entry should be done through forms. Add a combo box on your form that allows selection of the manager.

I agree with Remou that lookup fields are evil.

Duane MS Access MVP
Now help me support United Cerebral Palsy