I checked the northwind database template and under the relationships I see the linking between the tables. I did not find that in your sample database or in this video. So it's possible to link tables if the field names are the same (name/type), like the CustomerID, without having to map them under Relationships? When is it a must to use the map?
Scott Axton
@Reply 4 years ago
Relationships are introduced in Beginner 2. Then, in Expert 1 and 2 the Relationships Window is covered pretty extensively.
That being said - It is not necessary to have it and in some cases, like splitting your data base, it wont work as you think it might.
Don't get to far ahead of yourself, Continue on with the courses and you will find that Richard introduces those topics as they become relevant to what you are learning.
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 Beginner 2.