Hi,
I have managed to create a combobox that is linked to a BAQ. The infomation that is displayed in the dropdown is a cacluated field that contains the Lot#, lot expiry date and the lot qty.
The field is bound to TFShipDtl.LotNum. How do I only store the lot# to that field when the dropdown value is selected, and not store the caculated value? This is what I’ve tried, but it does not seem to work.
I do have PartBin_LotNum in the BAQ.
Thanks.
Set your Value field to what you want stored in the DB
Hi Randy,
I do have the value field as the PartBin_LotNum, but for some reason the value that gets stored is the calculated value from “View Column Name”.
Back your settings WAY up… I think you have too much going on.
Your controlling this ComboBox by a dataview. Yes, the dataview is being fed by a BAQ, but the way you have this set up is that the DataView is what your combobox is going to look at for populating.
You really only need (3) settings, for this to work:
Call out your DataView under View Name:
Then under Advanced… populate your Text Field and Value Field:
That should be all you need. Remove all other settings and give that a try.
Example:
I bound my combobox to TransView.MySelection:
Preview:
You can see my Text Field (UD02_Key1) is a part number I’m selecting in the combo.
My VALUE (UD02_Key5) is being passed to TransView.MySelection.
… and again, this combobox only had those (3) settings/properties set-up.
Hi David,
Thanks for your help. 
Removing the additional fields fixed the issue.
