I am trying to retrieve several records (rows) from two sql tables and display that data in one Notes form using a Stored Procedure in the Open Event. I am creating one temp record from all the data that is retrieved in a temp table.
But when I do the Select to get that new combine record I get the message “an Active Result is needed”.
Any thoughts?