Help populating text box based on value of drop down

[tbrantley]

How can I populate the value of a text box based on the value of a dropdown? The drop down has values from table1 and the text box will retreive its value from table2

[camel]

You can use UpdateContext({ItemYouSelected: DropdownMenu.Selected }) in the OnChange property from the Dropdown. And after that you can use the filter in Table2 items with the ItemYouSelected.Value (or any property your item has).

[TonyHart]

@tbrantley,

There's also another way to do that. Set your text box Default field equal to the DropdownList.Selected.Value, and it will automatically update with the list.

[tbrantley]

@TonyHart, @camel

I got it to populate home address with the value of the drop down. How would I retrieve home address and clock No from Driver Info based off the drop down box?

[camel]

Something like this would work. Just add this to OnChange property from the Dropdown:

UpdateContext({Info : LookUp(DriverInfo,DropdownValue exactin Name)})

After setting the Info, you will need to set up the Default property from both 'Home Terminal Address' e 'Clock No' Text Boxes.

[tbrantley]

@camel

Would I set the default property for 'Home Terminal Address' text box = Info?

[camel]

You need to access the Column 'Home Address' from your Record. Something like this will probably work:

Info.'Home Address'

[tbrantley]

@camel

Tried mutlple ways and still getting error

[camel]

@tbrantley can you please hover the yellow message sign and show the error message?

[tbrantley]

@camel

It says "Invalid Name"