Can someone guide me on the DBCombobox please.
I have an underlying SQL table and I'm making a "front end" for easy editing.
Values in fields are mostly numeric but are meaningless to a user.
The DBCombobox will be linked to an integer field where values denote a widget style.
I want the user to use the DBCombobox and select a user friendly word from a list which then assigns the correct value into the field.
I've read sections that mention looping through many if statements and assigning values via code but I was wondering if there's a way that a value can be assigned from a string list.
ie
"Male Armour" , 10
"Female Armour" , 11
"Weapon" , 5
Selecting Female Armour in the dropdown list would apply 11 as a value into the field.
Thanks for any info.