Hi I m using Access 2013 and I m stuck in Expert 3 Lesson 4. At 6:34 seconds in I m trying to drag the Fields into the product form and I get the circle with a line through it. I can right click on the fields and add to view but when I do this for ProductCategoryID It wants me to specify a relationship. I do this by selecting ProductCategoryID and setting it for One record in ProductCategoryT relates to many records in ProductT. This sets up a field called ProductCategoryID_ProductCategoryT. At this point I tried to setup a relationship between the two tables but could not figure out how to do it. I continue on with the lesson but I m unable to drag the sub form into the ProductCategoryF. Help!
Reply from Alex Hedley:
In design view I normally drag the subform I want from the navigation pane into the form. Access is usually smart enough to link on the same field names, if not go to the Property Sheet and in Link Master/Child Fields add them in there.
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.