Rick, on Expert 1, Lesson 2 at ~9:50, added two ID fields to the Customer Table calling them "Foreign Keys". He did not move them up under the Primary Key as he is wont to do. Then at ~13:50, he called these two "Supplemental ID Fields" and distinguished them from Foreign Keys - but did not detail the difference. So, are they Foreign Keys or not? And if not, is there some heretofore unexplained special category called "Supplemental ID Fields"?
Sami Shamma
@Reply 2 years ago
Hi Tom,
It is helpful to think that there are only two types of keys in a database: a primary key and a foreign key. Ignore all other names.
The primary key is the field that identifies each record of data in that table and is unique.
The foreign key is a field in a table that points to a primary key in another table.
Moving the foreign keys to the top below the primary key is good programming, but it is not a requirement.
I hope this helps.
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.
