I am working on a database at work. It started as a small project for myself and has morphed into something larger.
I do have Access experience, although I have not done anything in Access in more than 5 years and I wasn't exactly a power user to begin with. I do believe I can create this small database though, but I also may have bitten off more than I can chew.
Basically the DB is one which lists all employees in our department and the job(s) they are qualified on.
As of now I have 2 tables:
Table one
EmployeeID
FirstName
LastName
Shift
Table two
EmployeeID
JobID
JobDescription
I've created a form to enter the information and for the most part it works with no problem.
The issue I am having is entering multiple jobs for the same person. Say for instance I am qualified on 4 jobs, I cannot enter a 2nd, 3rd, etc... due to "The changes you requested to the table were not successful because they would create duplicate values...." error.
I've searched high and low for an answer and I might have seen it and didn't understand, but most seem geared around VBA and I wanted to stay away from that for this DB if possible.
Any help you guys could offer would be much appreciated, thanks!
I do have Access experience, although I have not done anything in Access in more than 5 years and I wasn't exactly a power user to begin with. I do believe I can create this small database though, but I also may have bitten off more than I can chew.
Basically the DB is one which lists all employees in our department and the job(s) they are qualified on.
As of now I have 2 tables:
Table one
EmployeeID
FirstName
LastName
Shift
Table two
EmployeeID
JobID
JobDescription
I've created a form to enter the information and for the most part it works with no problem.
The issue I am having is entering multiple jobs for the same person. Say for instance I am qualified on 4 jobs, I cannot enter a 2nd, 3rd, etc... due to "The changes you requested to the table were not successful because they would create duplicate values...." error.
I've searched high and low for an answer and I might have seen it and didn't understand, but most seem geared around VBA and I wanted to stay away from that for this DB if possible.
Any help you guys could offer would be much appreciated, thanks!