Dropdown DB Value

[tobinit]

Hi Folks,
Probably a stupid question but I couldn't find an explanation in the help guides.
I have a Connect profile which syncs a customer table (Code,Name) to a Customer Dropdown.
In the field mapping I have Code mapped to DBValue and Name mapped to DisplayValue.
When I save a scanned barcode and sync it back, I only get the Customer Name that I selected in the Dropdown.
How do I store the associated Code (DBValue) for the customer selected from the DropDown?


Thanks

Rob

 

[tobinit]

I've made some progress,I have setup another sync to put the Customer Code in another dropdown.
I have enabled a filter on the Code dropdown to filter based on the customer name selected in the first dropdown.

As these will always be a 1:1 relationship, is there a way to force the 2nd dropdown to autoselect the first item after it has filtered the list?

 

[lesdelimer1976]

You can add a hidden field to the form and map the Code column there. Then set the dropdown’s “Store as” option to that field so the DBValue is saved when you submit. That way the name shows in the UI but the code goes into your data store.