Hi,
I have a task to came out training database for our company employee but encountered an issue whereas i cant create 1 relationship that consist multiple Primary key. I cant used auto number as PK since we already have unique ID for every employee.
Attach is my sample database .
Hopefully someone can help me on this and appreciate it.