I need to perform filtering on a lookup page that is used to populate a field on a request page for a report.
I would like to show a minimal version of the lookup page (the kind that is shown with a field, that only has “TableRelation” specified) as opposed to the full blown window with a title bar, frames and buttons.
Can this be done or does one always have to use the full list page when filtering is necessary?
Below is a screenshot of how i would like to present the data to the used for him/her to take their pick when they click the “arrow” button next to the input field.
I have entered filter code to the OnLookup trigger for the field in question, but I can only open the full framed version of the list page.
I think you are searching like this::(DimensioCode and Dimension values are two code type variables on Report, Dimension value lookup is limited by the dimension Code filter applied)
IF FORM.RUNMODAL(FORM::“Dimension Value List”,DimensionValueRec)=ACTION::LookupOK THEN
Text := DimensionValueRec.Code;