fields value changing based on other field

[SoxPats83]

i have a table where a user will input data into one field and i would like another field on that same record to populate based upon what was typed in that first field. for example, if the user typed "Cat", "Animal" would populate in the other field. if the user typed "Baseball" in the first field, "Sport" would populate in the other field. any thoughts?

 

[PNGBill]

What you are trying to do sounds like two separate issues.
To not only populate a field on a value from another field
but for the other field value to be a none calculated value ie not [field1] plus 10 or * 3 but some text value that has no connection.

I would imagine you would need to have a table with the many possible options of Cat - Animal that you could imagine and [field2] is linked to [field1] on the tableInfinity.

Now if you have not disclosed that the option is closed - ie [field1] is limited to "house pets" then maybe tableinfinity will not need to have so many records.

Trust my observation is incorrect.