Form wants a value when update

[rjolda]

Hi,
I have a browse update form - it only does UPDATES.
When I try to Accept it it comes back with another field ( which is in the table but not being used by the browse or form and really has no place here) needs a value. It is a Field with Several Options.  How do I tell the form to Ignore this field on Change?
Thanks,
Ron Jolda

[kevin plummer]

Try to prime that field with a value in Pre-Update Embed

[rjolda]

Two answers:
1. Can Prime with a value before update - that works.
2. I found the Validation Tab on the Form - Setting "Auto Dict Validate" to NO stops the validation that is not necessary for me!
Ron Jolda

[Bruce]

Hi Ron,

When saving a record it applies the dictionary validation to the whole record.
This is necessary because the backend will also apply validation to the whole record - not just the fields that are changing.
So when you update, or insert, a record all fields must have legal values - not just the ones actually on the form.

Use the priming tab, or the embed point you mentioned, to prime any fields which may, or may not, be on the form.

cheers
Bruce