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 don't want to used auto number as PK since we already have unique ID for every employee. Basically my objective was, we can query by ProductDetails, Product and by employee ID.
Attach is my sample database .
Hopefully someone can help me on this and appreciate it.