Restaurant application - adding items form

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I am designing a restaurant menu application and have been requested by the
user to design a menu ordering system where the names of items appear on
buttons. E.g. Clicking on the Drinks button in the header will display
buttons for all the items with category drinks e.g. button with Coca Cola on
etc. My question is what is the best way of doing this? My two relevant
tables are tblItem and tblItemType. I don't believe it's possible to do the
above with command buttons, so have been experimenting with textboxes made
up to look like command buttons and crosstab queries but I'm struggling.
Any help appreciated.

thanks
 
Mark,
There are many ways to do this. I prefer an unbound Combobox (ex. cboFilterByType)
that lists all Types to choose from, then filter the records accordingly.
Use the AfterUpdate event of cboFilterByType to apply the filter. This combo can go
right on your "master" MenuItems form.
This allows you to save space on the form by using one control, instead of a bunch of
buttons/text boxes. Also, if you add another Type later on, you won't have to update your
form... add another button... etc.

You wrote...
E.g. Clicking on the Drinks button in the header will display buttons for all the items
with category drinks e.g. button with Coca Cola on
Click to expand...

Sounds like you want to select a particular product like all your Coke, or all your
Pepsi items. In that case have 2 combos, one to select a Type, and another to select an
Item.
The 2nd Item combo will be filtered by the 1st Type combo, so... select a Type
(Beverage), combo2 now shows only Pepsi, Coke, Sprite etc..., then select one of those.
Take the values from both combos and use them to filter the MenuItem listing.

Actually, I'd set it up so you could filter by either Type OR by Type and Item...

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
Back
Top