I have a Text List Object set up for two columns as follows: @RMANwidth:75@«New Org Name». The Option settings are: Value is a variable: “thenumis”, Database is set to: ~, Database Navigator is unchecked, and sorting is set to “No duplicates”. The reason I set to no duplicates is because I want the list to show only one entry for each 4 digit RMAN number along with the departments name. Each RMAN/department has multiple records ranging from 15 to 40 records per RMAN/department. There are 260 RMAN/departments in the database. When scrolling the list I would like to click on one RMAN number and have the database select all records associated with that department. Is this possible? Here’s my procedure code so far:
alertsheet “Would you like to select the records for RMAN “+tabarray(thenumis,1)+”?”,“button”,“Yes”,“button”,“No”
If info(“dialogtrigger”)= “No” Stop endif
If info(“dialogtrigger”)= “Yes”
CloseWindow
Select «RMAN» contains thenumis
setwindow 80,10,750,1060,""
OpenForm “DepartmentListing”,“Toolbar”,false()
ShowPage
Endif
The procedure above shows the alert with the correct “RMAN” number that was clicked - but when I click Yes it opens the “DepartmentListing” form with ALL 5,346 records for ALL departments, not just the records for the department RMAN that was clicked. I can do what I want in a Text Editor Object using an ArraySelectedBuild and highlighting the RMAN number - but I like the alternating row background colors and the horizontal, vertical solid grid of the Text list. I can also do what I want by just listing the RMAN number with no duplicates, but it’s good to also show the department name in a second column. Thanks, Dusty