I am working on a form that will allow users to create menus for breakfast, lunch and supper from a list of menu items. Each menu item is assigned a particular menu category to reduce the length of the available items and hopefully reduce user errors.
We have four dining rooms and most of the items will be served in all four but occasionally a single item will be served in only one dining room. I have tried to use query based combo boxes and option groups but it seems cumbersome because each menu item will require--I think--a unique box or group. The form I'm using is called frmMenuCreator.
I'm not sure what the best way to handle this design requirement and any advice would be greatly appreciated. As an aside, I plan on upsizing this db to SQL at some point.