Hi -

I have several forms created as user interfaces for our database. One sits in a staging table where we import .csv files to track event attendance. The process is basically 1) use the standard import wizard to import the file, 2) review the import in the staging table, and 3) either complete the import by pressing the "merge" button (works fine, exactly as we need it to), or decide to abort the import by pressing the "cancel" button.

The cancel button clears the staging table (desired behavior) and makes the form screen go blank (less desired). I can get the form back either by hitting the + sign to create an empty record, or by moving to the "all" tab and back again. Otherwise the scripts work fine, but it's confusing to my users. Could this have something to do with forms in an empty table?

Screen shots of the before/after hitting the cancel button attached, and here's the cancel button script.

delete (select Attendance_Staging);
let dummy := (create Attendance_Staging);
void

Thanks in advance for any advice -

Best,

Dave