I’m trying to have the user select an entry for one combobox and then in a 2nd combobox - using that value, do a DBLookup using thw 1st comboboxes selection as the key to do the lookup… I have it working where I can put the return of the 1st combobox to a session var and then display that to an edit field or computed field - what I need is to do a selection in one combobox - then based on that selection I need to do another lookup for values in a 2nd comboBox. I tried setting a scope var, then in the 2nd ComboBox in the values property I tried using the setting a new var from the scoped variable then using that in a @DBLookup. This seems to only work when the page is opened and not refreshed via the submit from the 1st comboboxes submit… Any ideas? Here is the code for the 2nd combobox values property…
var tempOEM = requestScope.tempOEMName;
@DbLookup(“”, “LookupAgent”, tempOEM, 2)