AnsweredAssumed Answered

Conditional Fields With A Catch

Question asked by GarthBeast on Oct 14, 2013
Latest reply on Oct 22, 2013 by philmodjunk


Conditional Fields With A Catch


     Hi all,

        I'm trying to create a conditional field with a catch.  Basically my company works with many different creative professionals with different titles (directors, producers, editors,etc).  I have my filemaker database setup so I can sort by title, but I want to be able to add a "Preferred" field, so we know which person in each title group we prefer to work with.  I'm wondering if I can setup a conditional "Preferred" field based on title, that will also only allow one person in each field to be preferred?  In other words, if we decided to change X director to preferred then the old preferred director, Y will automatically change to not preferred?

     I hope this makes sense and thanks for your help