Multiple Combo boxes from single table

[Jon M.]

Greetings all, I am stuck. I am building a database for a weekly cafeteria
menu. I have a maintable with these fields: Item#, MenuName, Description,
and Price. This table contains all of the available menu options.
Then I have a table for each weekday named as such, with these fields:
Entree1, Description1, Price1, Entree2, Description2, Price2, DeliSpecial,
DeliDescription, DeliPrice.
What am I trying to get is a form where the user chooses a tab Mon-Fri and
selects the menu for that day. Entree1, Entree2, and DeliSpecial are combo
boxes that pull records from the field MenuName from the maintable. What I
want to happen and can't get to work is when the user selects one of those
options for the corresponding fields to autopopulate from the maintable, i.e.
when I select Turkey Sandwich from DeliSpecial I want DeliDescription and
DeliPrice to fill in the appropriate info from maintable, then I click on the
Tuesday tab and choose the next options, etc...
As always any help is greatly appreciated. Thanks.

 

[Arvin Meyer MVP]

Think about redesigning. You should not be creating a table for each
weekday. Instead, add a field for the weekday. Now, you simple have to
create a combo box with a value list of weekdays (or better yet a table of
weekdays) and use the number of the weekday (1, 2, 3, etc.) and the name of
that day in a combo. In a main form, choose the day, then in a subform,
display the menu for that day. Or, you can use a continuous form and put the
day combo in the header. You can use combo boxes to hold the menu choices
and have the additional fields filled in by using the column property of the
combo. Here's a demo of that:

http://www.accessmvp.com/Arvin/ComboColumn.zip