Hello,

I need to be able to create the following in access (using forms/VBA code etc).

Input a record for a person, apart from their name they need to select up to 6 options/ingredients.

The ingredients will come from an ingredient table, and have a specified weight (either 10 or 20 grams for simplicity).

The ingredients must add up to 100 grams, and some cannot be chosen alongside others.

Essentially, How do I create a multiple option box that will allow the user to select up to 6 records. And how can I refere to these options in the code?

(so I can write for example that carrots cannot be chosen alongside walnuts)