Hi All,

I'm creating a recipe database (don't groan!). In the Ingredients table I have fields for Ingredients, Measure type, Quantity etc. In the Recipe table I have RecipeName, Method etc.

I bring these together on a Recipe layout, where for each recipe there is a portal for ingredients with their corresponding quantities and other fields. Some ingredients are used (and so entered) more than once in a recipe, but I don't think this is a problem.

I've used a value list based on the Ingredients field to enter the ingredients into the portal, and it all LOOKS good. If I do a find on the portal the find works OK, finding only recipes that include the ingredient requested.

My difficulty is when I try to do a find on a check box list of ingredients on an Ingredients layout, to see what recipes are suitable. The find shows every recipe that has been entered, instead of just the ones with the requested ingredient. Is this because I've used a value list to enter the ingredients, and if so, how can I work around it?

Thanks in anticipation!

We can't really tell, because we don't really know what the "checkbox" field is. You say you're on an Ingredients table layout. Hence one assumes the checkbox is the Ingredients field (that seems a little awkward, as it's going to be too many eventually). Are you entering Find mode, then checking a couple of ingredients, then finding? If so, you should find those 2 ingredients. But it sounds like you're doing something else.

Whether you use a Value List does not really matter. What matters is what the field using it is, and what the current layout's table is.

We can't really tell, because we don't really know what the "checkbox" field is. You say you're on an Ingredients table layout. Hence one assumes the checkbox is the Ingredients field (that seems a little awkward, as it's going to be too many eventually). Are you entering Find mode, then checking a couple of ingredients, then finding? If so, you should find those 2 ingredients. But it sounds like you're doing something else.

Whether you use a Value List does not really matter. What matters is what the field using it is, and what the current layout's table is.

Hi Fenton and thanks for replying. Yes, the field IS the Ingredients field, and there's probably about 200 ingredients, so the names are just in one big list on an Ingredients table layout, and yes, I'm entering Find. IF I just do a find directly into the Ingredients portal (which is on the Recipe-based Layout) then I get only the relevant recipes.