Auto Fill 2 field in a form

[Trantran]

Hi, 

I have a form with 2 field Name and code, and a table data with name, code. Is it posible to make the app to automatically show the name when i input the code and also if I input the name, the app automatically show the code?

Thanks in advance

[lynchk21]

You can use the initial value for each column and write the appropriate formula to do this. For example for [name], the initial value could be something like:

• IF(ISBLANK([_this],"",LOOKUP([_this],dataset, [name],[code]))

Obviously, this will depend on how your data is set up.