Hello,

I've seen one or two similar questions regarding moving data from one form to another, however it did not involve the same scenario and testing out the code (customising to my own variables) on their solutions, did not work.

So I just created a new database, I'm new to Creator since it's to replace an old database.

I currently have one form/report named "Live" (since they're live jobs being dealt with), and another named "Archive" - used for what jobs have been completed... but keeping a log of all those completed. I want the users to be able to enter data into the Live database (which I can do no problem!), but when a manager comes and checks the job, and marks it as complete (this needs to be done manually) - I've created a checkbox for this - it needs to be moved from the "Live" form to the "Archive" form/report. Not copied, because it needs to be removed from the "Live" form once it's completed.

I tried to create something in the 'Deluge script' so that upon the condition that the "Completed?" field equals "Yes" (from the checkbox choice), that it moves it to the "Archive" form, but I couldn't figure it out.

It doesn't necessarily need to be directly moved... it could be copied to the "Archive" form/report, and then immediately deleted from the "Live" form/report. So long as it has the ability of essentially being moved over, that's all I need!

Any help would be much appreciated!

Many thanks in advance!