Set Field [EmergencyContacts::Country ; ""]
Set Field to blank?
Or if EmergencyContacts::Country is a calculated field, you will have to change the calculation
It could be defined as a calculation, or a Text Field with a calculated Auto-Enter option.• You can't replace contents of or fields or fields defined with the global storage option.
Hello DavidAnders, thank you for your suggestions - greatly appreciated.
However, when I tried:
Set Field [EmergencyContacts::Country ; ""] ---- it did nor work.
EmergencyContacts::Country is not a calculated field. It is simply a text field.
At the moment my script shows the following criteria:
Set Field [EmergencyContacts::Country ; "AUS"] ---- which lists the country AUS. AUS is an abbreviation for Australia. I also have other country codes listed in my database such as: USA. I need to show all other countries other than AUS.
Any other thoughts or suggestions please?
To find all records that do not have a specified criterion, create a separate request at the end of your find requests and use Omit Records to turn it into an "Omit" request. This is functionally the same as clicking the Omit record when manually setting up a find request while in find mode.