The example I gave is oversimplified for class, but yes, the year, make, and model would be the same, but the foreign key (CustomerID) would be different allowing you to know which customer purchased which car. In a real-world database you would also have something to uniquely identify the specific car, like a VIN or other serial number. Plus make would have it's own table (Ford, Chevy, Audi, etc.) and so would model (Taurus, Focus, F150, etc.) and those would just be IDs too. But again, I was keeping it simple for class to teach you relationships. Does this answer your question?
Wendy SummersOP
@Reply 6 years ago
Yes, thank you.
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 Expert 1.
