Solved: How to fill value in textbox by selecting value fr... - Page 2

Jayesh_Dua · 07-11-2021 11:48 PM

I have one form in which I have one dropdown and some text fields, I have linked 2 different tables,
Table1
Table2

In form I have 1 Dropdown in which value is coming from Col1 of Table1, Now I want When user select value from dropdown, app should pick value from table2 column and fill in the specific textbox.

The column linked in the dropdown is common in both tables.

Steve

Try this as the Initial value expression for the column that will get the address:

LOOKUP([_THISROW].[Company_Name], "Company_Master", "Company_Name", "Address")

If the Company_Name column in that form view is a column of type Ref, you might instead be able to use just this as the expression:

[Company_Name].[Address]

How to fill value in textbox by selecting value from dropdown