Can you have more than two FK's for a table?

[KristenD]

I am looking to link two tables as I would like to have reports generated with info from those two tables.

tblEmpInfo
EmpInfoID <PK>
EmpIDFK <FK>
Jobsite<FK>

tblEmpRating
EmpRatingID <PK>
EmpIDFK <FK>
EffectiveDate
SuperID
CraftCode
StatusChange

What I would like to do is have those two tables joined somehow so I can pull info from the latest status change with a date. Can I do a join query so they are joined by the EmpID? Or should I add the EmpInfoID to the tblEmpRating and join them that way?

Thanks for your help!

 

[jdraw]

Why would EmpIDFK <FK> be a FK in tblEmpInfo?

Perhaps you should tell us about,or post a jpg of, all the tables involved.
You have a JobSite FK, but did not show a Job(site) table.

You are confusing us by not describing what you are really trying to do.

You have a FK for attributes that relate to other Tables.

 

[KristenD]

Here is the relationshipship report that shows all the tables and their relationships.

The main table's PK is the EmpID which links to most of the other tables so I can link all the records back to one specific employee.

Thank you!

 

[jdraw]

A couple of questions.

In tblSkills and tblRating, why is tblSkills.Skillcode linked to tblRating.Code when there is a tblRating.Skillcode??

Seems to jump out to me???

As for your report, since you have relationships established, can you not use
tblEmpInfo, tblEmp and tblEmpRating which seem to be in a relationship that should cover the data you need.

Good luck.