ADD ROW IN ANOTHER TABLE BASED ON CONDITION

[ANDREWDAVENPORT]

CAN ANYONE HELP ME WITH THIS? I WOULD LIKE TO COPY A ROW FROM ONE TABLE TO ANOTHER BASED ON A YES/NO CONDITION. BASICALLY, I HAVE A PARTS TRACKER TABLE THAT TRACKS IF WE HAVE RECEIVED A PART, WHEN IT WAS ORDERED, ETC. IF THE PART IS "SHIPPED" OUT THEN I CONSIDER THE JOB "COMPLETE." I WOULD LIKE TO KEEP THIS ROW BUT NOT HAVE IT CLUTTER UP THE OPEN JOBS ONCE THE PART HAS BEEN SHIPPED AND THE JOB IS COMPLET. I CAN EDIT THE ROW IN THE ORIGINAL FORM VIEW WHEN THE JOB HAS BEEN COMPLETED TO "COMPLETE." IS THERE A WAY I CAN DELETE THIS ROW FROM THE "PART TRACKER" TABLE BUT ADD IT TO A NEW ROW IN THE "COMPLETED" JOBS TABLE AND KEEP ALL THE ORIGINAL DATA? 

[graham_howe]

You can create a Grouped behavior which will call two other behaviors.

The first behavior called would insert a new row in another table:

The second would delete the row from the current table

[ANDREWDAVENPORT]

I NOW HAVE 3 COLUMNS THAT HAVE THIS ERROR. "The data action 'New Action' does not define a value to set the column 'PART #' to." THE VALUE OF THIS COLUMN IS A MANUAL "TEXT."