Update one field's data when another is accessed?

[Boot]

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.

[aaa]

Hi, Boot!

It seems will help autoenter options.

Look attachment. Such?

aaa.zip

[LaRetta]

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

[Genx]

Lol, nice on LaRetta