Dealing with records
How can I use a button to move a record from one table to another. I would like to modify the record in the second table and then move it to other tables Then be able clear the second table without changing the original record. I have built the relationships using primary unique keys. The relationship is set up to only create records in the decending (child) table. What is the best way?
Records Source (Table) to second (Table) Revelant Records Modified, after records created in downstream records, cleared from this table to (Table0 Records Retained