Add an alert to a field to avoid dupliates?
To avoid typing duplicates, I'd like to have an alert letting me know before hand if a field has the same value/amount. Any help is appreaciated. (I'm using Filemaker Pro 10 for OSX)
Open Manage | Database | Fields and find your field there.
Double Click it.
Click the validation tab in the field options dialog that now appears and select the unique values field option.
Have you tried using the Unique values setting on the validation tab in Field Options for your field?
Currently the field is set up as an "Edit Box" (I believe) and is not giving me a "Field Option", only Field/Control containing Setup, Behavior, and Borders.
Thank you! Works perfectly.
Retrieving data ...