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

    Multiple fields use 1 value list

    VietSeonca

      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.