How to move records from one table to another based on field input?
I have two tables within the same app. One table (Table A) contains records with Status A and the other table (Table B) contains records with Status B. I want to be able to move a record from Table A...
Generally speaking, if you have records that have the same structure, you would keep them on the same table. Can you provide a little more context for keeping these records in separate tables?