Automate Pop-Up Menus
I'm new to filemaker and was wondering if anyone know if pops-menus can be automatically turned off and on? I have a table that defines a type for a given shot. There can only be one active shot type at a time, so I made a field that has a pop-menu with "Active" and "Notactive". My problem is if I make a new record and set it to active I have to manually set the other the "Notactive". Does anyone know of a way that once a record is set to "Active", all other records will automatically be sets to "Notactive" ?