Skip Sleeper
asked on
Option Group on Form Best Practice
Hi Experts,
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.
Thank you!
Sample-DB.accdb
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.
Thank you!
Sample-DB.accdb
this could be handled in a number of ways... if you can tell on a consistent basis when only one item is being served in one dining room you can set the visible to true/false that day on certain items..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, I appreciate the input!