By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,474 Members | 3,214 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,474 IT Pros & Developers. It's quick & easy.

How to use extracted table with base table?

P: n/a
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?

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Joe Celko wrote a great answer to this question some time ago... search
for his posts in this NG

Nov 13 '05 #2

P: n/a

pi********@hotmail.com wrote:
Joe Celko wrote a great answer to this question some time ago... search
for his posts in this NG


I did as you suggested, but only got 2 hits, neither one relevant, as
best I can tell, to my inquiry. Am I missing something?

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.