Is there a simple way to have one field automatically updated whenever another field has data added to it?

I have two fields, a text field and a number field side by side. The second one is often blank, but whenever it has data added it means that the first field needs to be changed too:

Field one has a text value list such as "Cancelled", "Waiting", "Possible", and "Submission Number". Field two is a number field whose sole purpose is to describe which "Submission Number" is being referred to, so that whenever it has a "1" or "2" or "1b" in it, the first field should always be changed to "Submission Number".

I've tried to make this happen automatically through validation options, but they don't seem to work for me.

Hi, Boot!

It seems will help autoenter options.

Look attachment. Such?

aaa.zip

Emm, there is a problem with that calc. The null result will stop any other value in that text field. A default result isn't required on If() in vs. 7/8 (because it short-circuits) but it still must be specified in this instance because you are using Auto-Enter (Replace) and you want any other data to stay. Try:

If (

Number = 1 or

Number = 2 or

Number = "1b" ; "Submission Number" ; textField

)

Boot, if text is allowed in that Number field, it should be specified as a text field. If you wonder about the mis-match in Number (some with quote and some not) it's because quotes aren't required on straight numbers but ARE required on text (in both a number or text field) and it doesn't matter if the field is CALLED Number. This is exactly why field naming and data types are important - I've learned this one the hard way. And including the real field names helps as well.

Let us know if I've confused you further.

LaRetta

Lol, nice on LaRetta