I've run across another situation in Access I just don't know how to
handle. I have a database of employees in our group. I have a series on
linked tables with location, cubicle, computer, etc. All that is fine
(well, since I got help here with it, it's fine!). I want to show who
each person's supervisor is. I could put in a separate list of
supervisors, most of whom would also be in the employees list. But
doesn't it make more sense to put in a boolean field in the employee
table for supervisor? Then extract a separate table for just
supervisors and relevant information? And link that table back to the
employee table? But then what happens when a new supervisor is named?
The supervisor table would have to be deleted, along with the link, for
the query to re-create the supervisor table. Somehow, what doesn't
sound right to me.
The other problem it creates is the the head of the department's
supervisor is not an employee of the department. So I'd either have to
leave the dpt. supervisor with no supervisor, or add the dpt's
supervisor's supervisor as an employee, which isn't really true. Is
this confusing you as much as it is me?
I'm sure many of you have resolved these difficulties eons ago. So what
are the best solution(s) for this situation?