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?