I know this is probably way past the time from when you created this seminar, but on the topic of Constraints when two fields are involved, my current project will have this situation and will be a required by the Nevada Gaming Commission. We cannot have to gaming machines that have the same Model Number and the same Serial Number. This Constraint is perfect for my InventoryT table & entry form to stay in compliance and double check the manufacturer.
Brad
Reply from Richard Rost:
You can set up indexes that are based on two keys, so you can't have duplicates that are a combination of BOTH fields. This is called a COMPOSITE KEY.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access SQL Seminar Part 3.
