Hi - I am working with SRM 7.6 and having an issue with the selection field (drop down list)

The user selects a value from a couple of drop down lists (fields say ‘Field 1’ and ‘Field 2’). I have workflow setup on the form such that an active link is triggered and it populates a third field (Field 3) with what was selected in Field 1 and Field 2.

I want to be able to populate Field 3 with the database values of what the user selected, not the alias, but the selection value of those menus. The ‘Set Fields’ in my active link says - $Field 1$ + $Field 2$ but that does not record the database value, just the name (alias) in the list. I tried using the format ‘DB.Field 1’ and some other variations, but I can't seem to get the database value populated (example below).


Field 1

Selection Value Alias ID

------------------------------------------------------

DBValue DBName 0



Field 2

Selection Value Alias ID

------------------------------------------------------

DBValue2 DBName2 0

DBValue3 DBName3 1



I want DBValue + DBValue2 to be populated, but I keep getting DBName + DBName2




Any ideas?

Thanks !

Hi,

To record the database value of a selection field, you have to user filters instead of active links.