employee - client relationship

[p27br]

hello,

i have an employee table with employee id as primary key and a function field, and a client table with 3 foreign keys (helpdesk employee, account manager, production employee), so each client has these 3 employee types assigned.
In the relationships window , I have 3 times the employees table with each a one to many relationship to the client table.
To represent hte fact that for example an account manager cannott be assigned in the helpdesk employee field, I defined a query as row source in the foreign key field. Is this the correct way to represent this kind of relationships or should I create three distinct employees tables ?

 

[danvlas]

An employee is just an employee, whether managing director or cleaning maid.

One 'entity'= one table

And remember that positions/qualifications change over time. If you have three tables, you'll have to move data from one to another...

So: keep all of them in ONE table.




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[JeremyNYC]

heh.

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[p27br]

OK,

thanks

 

[danvlas]

Jeremy:

heh?

This is a totally different situation from the other thread...

...




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[JeremyNYC]

Dan,

Sorry. I knew that was gonna be unclear as soon as I posted it. It wasn't meant as a victory dance. My brother uses that to indicate a chuckle. Yes, it's a very different set of circumstances, but my immediate reaction was a little chuckle. It was meant to be an inside joke between you and me--only problem is that I'm the only one who got it.

As I implied in the other thread, I have tons of respect for you, and I agree with most everything I've seen you post here, including this.

Sorry for the confusion, it was meant to be a friendly gesture.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[johnnymac43]

Good to see so much good advice re relationships readily offered to newbies. I wonder if this one will also get to 17 replies.

Just a thought: If we assume that a helpdesk employee may one day get to be an account manager, the two posts are'nt really all that different in concept.

Cheers

John