Hi,
I have a form which gives me my outstanding ledger to which I can make payments against and creates a payment basket (which has a unique reference) in a temp table prior to posting.
What I want to do is run an append query that appends an exact copy of all records relating to that basket apart from a few key fields which I want to give new values (based on a field in the form).
Any help would be appreciated.
I have a form which gives me my outstanding ledger to which I can make payments against and creates a payment basket (which has a unique reference) in a temp table prior to posting.
What I want to do is run an append query that appends an exact copy of all records relating to that basket apart from a few key fields which I want to give new values (based on a field in the form).
Any help would be appreciated.