Exactly what options did you specify when setting up this value list? (There are several possible causes depending on what options are specfied here.)
Here are the options i have selected for each of the parts.
-"display data from" -->FormulaLineItems::Ingredients
-Use Values from Field:" --> FormulaLineItems::Ingredients
- auto-enter --> "looked up value" --> Ingredient::IngredientName
- Validation --> "Member of value list" --> "Ingredients"
- Validation --> not empty
Hopefully this breakdown makes sense on the options that have been chosen for each part of my problem.
If "display data from" is FormulaLineItems::ingredients, then picking a value from the value lists modifies a value in the ingredients table, not in the Formula Line Items table you mentioned in your first post. That would not appear to be what you need here.
I'm not sure what other options i have to use in the "display data from"...What would i use to make the value list display from the formula line items instead of the ingredient table?
Never mind, I misread your post. "Display from" looks to be specifying the correct table and field. (My brain somehow transposed the two table names when I read this.)
If you want a change in ingredients table to change the values listed in the value list, Use values from should list values from the ingredients table instead of from the Formula Line Items table.