I have a form with 3 select fields to select names of users of a table in the database.
The first field work fine, but when i select any option in the second one and the third the error “Invalid Data” came out.
I have the same set ups in the 3 fields. even with the error the form save the information on the database.
But i have another form in wich i also have a select field to take names of the users table, but in this one i have a sql sentence in the lookup to brings only the name that i need.
The sql sentence on the lookup is like this:
SELECT Name
FROM users join validation
WHERE validation.points = ‘5’
AND validation.category = users.category_validate
ORDER BY Name
The form brigs the right name but at the time i save the data the error came and this time dont let me save nothing.
thank you for your help
