Hi,
I was wondering if I could get some advice on how best to do this.

The current situation is, I need to undue a deposit charge that was made to about 50 accounts, and after crediting or debiting the payment allocation table (depending what the balance is), I need to complete all new transactions of the credit for each account in the tranactions table. (Assume the payment is the same for every account $30.00) How can I create transactions all at once through a query? Here are the rules---

Credit all payment allocations that are allocated to Deposits Received and Returned using today’s timestamp.
(PaymentAllocation Table)

Credit all non-deleted Deposits Received and Returned transactions using today’s timestamp.
(Transactions Table)


Mark all non-deleted Deposit Received and Returned transactions as Deleted and not Visible.
(Transactions Table)


Run an automated payment allocation script to automatically allocate the credited payment allocations.

I am sorry if this seems complex, but I have been struggling with this for several days. Thank you.