3 Replies Latest reply on Jan 27, 2016 7:59 AM by VietSeonca

    Multiple fields use 1 value list


      Hi everyone,



      How does Filemaker treat the values on 1 value list, used by several fields?



      For example:



      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.


      Screen Shot 2016-01-27 at 10.52.59 AM.png


      As humans, it’s obvious for us to know the result “Breakfast = Yes” is different from the result “Lunch = Yes”.



      I wonder:



      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.