Hi @ptodd1 ,
Could you please share a bit more about the Data card that you mentioned? Is it a Text Input box or a ComboBox?
Do you want to populate Data card value in a Edit form based on Dropdown selected value?
If you want to populate a Text Input box within a Edit form based on the Dropdown selected value, please consider set the Default property of the Text Input Box (TextInput1) to following:
LookUp('[dbo].[Master Lumber Inventory]','Pack ID'= Dropdown1.SelectedText.Value, ColumnName) // ColumnName represents the column value you want to reference from your '[dbo].[Master Lumber Inventory]' table
or
LookUp('[dbo].[Master Lumber Inventory]','Pack ID' = Dropdown1.SelectedText.Value).ColumnName
Note: Please type Dropdown1.SelectedText.Value rather than Dropdown1.SelectedText. The result the Dropdown1.SelectedText formula returned is a record value rather than a Text value.
Then set the Update property of the Data card which contains the Text Input box to following:
TextInput1.Text
If you just want to LookUp a record value based on the Dropdown selected value, please consider modify your formula as below:
LookUp('[dbo].[Master Lumber Inventory]','Pack ID' = Dropdown1.SelectedText.Value)
Please take a try with above solution, check if the issue is solved.
Best regards,
