importing table, pending table and storing table

[OC2]

hi,

right now my database is improting the data onto table "olsimport" using an amended query the data from that table is saving into the pending table OLS Pending. Now I need help using my pending form upon confirmation "confirm (yes/no)"
I need that record to move from the pending table to the storing table "OLS" upon pressing a confirm button, ie

Import data table"OLSimport" -----> query amend to OLS Pending table-----> Pending form to confirm record"-------->record is moved from OLS pending to the OLS table.

If the confirmation text boxt is not click when i update the record it remains in the pending table, only when the confirmation text box = yes will it move to the OLS storing table upon pressing the confirmation command button.

Any ideas?

Thx