I have a database of receipts by vendors. I copied and adapted this database from a template. I place an X in a field that designates specific receipts to be selected to pay. I want to export the receipts that are being paid by a particular vendor to a spreadsheet where I can then use those records in a mail merge document in WORD. (I already have the script for this to work) After exporting those specific receipts, I want to create a button that will move the items to a paid table and then delete them from the list of receipts showing for each vendor. How do I write the script that will take the receipts with an X, copy them to a different "Paid" table and the delete them from the "receipts" table?
I will answer your question, but first will recommend that you not move and delete records. It's better to simply filter the "paid" records out of your found sets, related sets and portals. For one thing, if you mark an item "paid" by mistake, finding and changing the status back is much simpler than finding the moved record, reversing this process to get it back into the original table and then change the status. Plus, if you should need reports listing both paid and unpaid items, it's far simpler to keep them all in the same table. Finally what you describe requires two nearly identical tables, one for paid and one for unpaid. Any future design work on such tables will often be doubled now with a chance of error if you don't make exactly the same change on both tables.
But if you still want to do this....
Import Records can copy a found set of records from one table to another even if both tables are in the same file so you can do a find to find the marked records, then use Import Records to copy them over. Then you can use Delete All Records to delete the found set of records just copied over.