The first part is simple. Members have two types of bank account. So I need to search the member records for certain parameters, move some of the balance from one account to the other. This is a simple update query. Is it possible to create a transaction record using some of that records data on the one pass. There might be thousands of transactions. My only other choice seems to be, find a record, update, then append the transaction table.
Thank you for any help.