so in the example below, with product name being plain dough, i want to it exclude it from the drop down.
and the screenshot below shows how the value lists are created.
On what table occurrence is your layout based?
Thanks - sorry I should have said - "Products".
Can you confirm that Product Name and Ingredient are both text fields?
Can you confirm that the names, such as for Plain Dough, in the two fields are exactly the same with no extra characters such as a space in one field and not the other?
Your layout has a portal. On what table occurrence is it based? How is it related to Products?