How does Filemaker treat the values on 1 value list, used by several fields?
I have fields: Breakfast, Lunch and Dinner, which use the drop-down list with values: Yes and No; in order to keep track of what meals my customers had.
As humans, it’s obvious for us to know the result “Breakfast = Yes” is different from the result “Lunch = Yes”.
Under the hood, does Filemaker treat the results: “Breakfast = Yes” and “Lunch = Yes”, the same, since the values are from the same list?
If I want to specify the results later for sorting or organising, for example, I want to show only customers had breakfast (Breakfast = Yes), should I create a list (only contains Yes and No) for each field or I can use 1 value list for any field requires those two values?
I’m looking forward to your replies.
Thank you and have a good day.