Hello,
I have a table called tblJobs that contains the IDs that are linked to other tables IDs.
Those ID numbers are meaningless to the users of the database, so i would like to make a query (or is there a better way to do this?) to 'clarify' the table of Jobs.
So for example if i add the fields
Here is my difficulty:
I would like to display the name of who created the job (CreatedByID) and who is the project Manager (ProjectManagerID), but if i select EmployeeName from tblEmployees, there are two links to tblJobs so it doesn't work....
Any advice on what i could do to resolve this problem?, is there a different approach i should take?
Thanks a lot for any assistance.
I have a table called tblJobs that contains the IDs that are linked to other tables IDs.
Those ID numbers are meaningless to the users of the database, so i would like to make a query (or is there a better way to do this?) to 'clarify' the table of Jobs.
So for example if i add the fields
- JobID from tblJobs
- YachtName from tblYachts
- Description from tblJobs
Here is my difficulty:
I would like to display the name of who created the job (CreatedByID) and who is the project Manager (ProjectManagerID), but if i select EmployeeName from tblEmployees, there are two links to tblJobs so it doesn't work....
Any advice on what i could do to resolve this problem?, is there a different approach i should take?
Thanks a lot for any assistance.