1 Reply Latest reply on Jan 6, 2015 7:50 AM by philmodjunk

    Check box: many-to-many relationship or just value list

    BartekChromik

      Title

      Check box: many-to-many relationship or just value list

      Post

      Hi, 

      i am quite a new in Filemaker. I would like to add some check boxes to my database. I am thinking which option is used more often by developers, what is a good practice.

      creation of many-to-many relationship for every checkbox (+value list "from field")?

      or you just using value lists?

        • 1. Re: Check box: many-to-many relationship or just value list
          philmodjunk

          There's no way to answer that question in simple terms as it depends on what you need to do with that data. In fact, if you use a check box formatted field with multiple values listed for the checkboxes, as a match field in a relationship, you have both check boxes and a (limited) many to many relationship. You have created a mini join table right in the field formatted with check boxes.

          So it's a matter of taking a look at the larger picture and deciding what you need to accomplish what you are setting out to do...