At about 5:30 in this video, you made a comment about your son complaining that you repeat stuff in your videos and how important it is to understand relationships. Ironically, I didn't get how you related the two tables. Were you able to do that just by copy/paste of the field "ProductCategoryID"? or did a relationship get created when Access recognized the two names were the same when you later dropped the subform into the parent form?
Reply from Richard Rost:
You can create an EXPLICIT relationship between two tables in the Relationships Window.
If you don't, you will get what's called an AD HOC relationship which Access will create whenever you make a query or drop a subform into a form PROVIDED your fields are named the same, as you observed.
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 3.
