Junction table with combo box problem


I cannot figure out how to create a sub-form with a combo box that works.  My database has a Menu Items table and a Menu Category table.  I've created a junction table and related these other tables to it appropriately.  I have a form called Menu Item Entry that allows the user to edit a particular menu item and then in a sub-form with a combo box, assign all the categories that the menu item can belong to. I can't get this to work correctly.  Any help would be greatly appreciated!

Skip SleeperIT ManagerAsked:
Who is Participating?
als315Connect With a Mentor Commented:
Try this sample. I've removed PKs from your junction table to allow multiple types for one item and default value for ItemID was added to subform equal ItemId in parent form.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.