lost in a relationship... and a checkbox

[jimkent]

I'm creating an Online menu form that writes to various tables. I have a table with all the menu items available for each day. In this table the item descriptions also have two other fields 1) the day in which it will be displayed and 2) the type of food it is considered to be (i.e. a meal, snack or drink). I am trying to create the order entry form and having no luck.

For example on Monday the user can choose from one meal, one snack or one drink (not more than one of each). So, I can create a fields called [meal], [snack], and [drink]. I'm trying to make a checkbox field for each of the fields and the valuelist will pull from each catagory on each day. The items will be different each day.

I can't create the relationship which will do this! The best I can get on the checbox field is all the types of food on one day. I can't filter it down to show only meals or only snacks and so on. Any thoughts?

Thanks, Jim

[Ender]

Let's see if I have this correct: A User file with one User per record. A User can have many UserDailyMenus. Each UserDailyMenu has three menu offering fields, "Meal", "Snack", and "Drink". The value lists for those choices should be made up of selections from a DailyMenuChoice file, where each record is one day's choices given by items checked in three checkbox fields.

If that's about right, then the value lists' relationship will be:

DailyMenuChoice:

UserDailyMenu::Date = DailyMenuChoice::Date

And the value lists will be defined as:

Choice Meal:

Use values from relationship; DailyMenuChoice::Meal Choices

Choice Snack:

Use values from relationship; DailyMenuChoice::Snack Choices

Choice Drink:

Use values from relationship; DailyMenuChoice::Drink Choices

While this should work, you might think about adding Food and DailyMealChoiceLine files, and create the menus through portals. It's a little more work to set up, but it has the advantage of allowing you to summarize or count the number of each type of choice.