I'm trying to build a grid to work like a one-list mover. The grid should be populated with a full list, with a checkbox marking (and changing) whether that entry applies. The only thing stored would be key numbers for the selected entries.
I'm having trouble setting up the cursor so it always displays the full list and marks previously selected entries.
SELECT applies.ownerid, list.listid, list.entry, ;
FROM applies RIGHT OUTER JOIN list on applies.listid = list.listid ;
WHERE applies.ownerid = ?vp_ownerid