Conditional Fields With A Catch
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