how can i avoid a value existing on another field?

Alot depends on the specifics of what you want to accomplish.

Do you want to completely prevent users from entering data that already exists?

Do you want to just warn users when entering data that already exists?

Where does the data exist that you want to query for "already exists" and how is it related to the data entry field?

 

 

 

 

Hi, Kris M

I have a place to enter the data and I don´t want the submit button appears until the field content be the same as the any value in the other field.

I´ve created a list with all of the contents in this field and tried to use ValueListItems to omit that button, but it didn´t work. 

What submit button? FileMaker does not natively require a submit button to save data. Sounds like you have a scripted data entry process.

10,000 foot level options are:

Install a validation calculation in the table::field definition in mange database.

Build a scripted process that fires via script trigger or button click that does all the validation, controls the user experience, and conducts the database transactions..

Edited August 31, 201510 yr by Kris M