I have a form that has 2 fields LOB & Approver. I have a view called “Approver List” with the first column LOB sorted & categorized and the 2nd column Approver. I then have a main form that the client chooses an LOB (from a separate view). Based on the results of the LOB on this main form I have the client click a “select approver” button and only want the Approvers display for that specific LOB. It’s kind of working. I’ve tried at least 50 different variations of this formula. I either get Error: Server error entry not found in index OR with some success get ALL the Appovers under that specific LOB. I only one the 1 the client selects. No allow multiple values in columm or field. I know I can hard code views & based on LOB have these different views display. Unfortunately, we need this db to be low maintain allowing the client to input LOB/Approvers on the fly. I searched Help, 4,5 & 6 forums but have not found this problem. I appreciate your help!
@PickList( [Custom] : [Single]; “”; “Approver List”; “Approver Listing”; “Select Approver”; 1; LOB);
FIELD Approver :=@DbLookup(“”:“nocache”;“”:“”;“Approver LIst”; LOB; 2)