Auto-populating Record Producer Variables

[Christine30]

Hello:

I have a record producer with two variables:

var_number: Reference to alm_hardware table.

var_state: String

When the user selects an alm_hardware record in the var_number field, I'd like 'state' from the same record to be displayed on the form, in the var_state field. I've tried setting the default value of the var_state variable, for example: g_form.setValue('var_number'), with no success. Thanks in advance for any help.

Christine

[Tiffany Royer · Accepted solution]

Make sure to delete that client script you made on the Record Producer table. You want to create a Catalog Client Script on your record producer.

[Christine30]

THANK YOU!!