I'm doing a database lookup on a dropdown and I would like what shows up in the form to be more user friendly than what is displayed in the database. So for example, in my database entries I might have a Location column with information like "Site1", "Site2", "Site3", etc., which isn't very helpful for the person filling out the form.
I have a dropdown where the Choices list the friendlier location names (e.g. "Providence", "Seattle", "Houston", etc.), but have the site numbers that match the database in the Values field. But when I perform a lookup for an asset in Seattle for example, the dropdown selection just changes to "Site2" on the form.
I came across this forum thread where it sounds like the opposite situation works; if I selected "Providence" in the dropdown and that triggered a database lookup then it would match the Site1 dropdown value with the Site1 database value, but it would be helpful to have an option to perform the opposite value based lookup.