Good afternoon,
I started a little in ACCCESS, and I am making a table that should include the product code and its production batch, as well as other data such as description, quantity, etc. I would like to do this so that the product code and the batch are unique, so there may be one Product with code 789 and lot 1 and another product with code 789 and lot 2 but not the same product with the same lot . Initially I thought about putting together a composite key, but in later stages I have trouble making a table purchases and relating that composite key to it. Is my thinking wrong? Thank you for your attention and excuse any confusion of terms that I may have committed!