Grateful for assistance.
I'm trying to carry out the following routine.
I have a database with many records in the Main Table. One of the fields is named offer. The default value for it is "yes".
However during a particular process this field for a particular record is amended to read "no" through the use of a form.
The routine I would like to offer is to
1. print out that record after the change.
2. export that amended record in csv format to a predetermined folder.
I was wondering whether this can be done in situ or whether it is preferable to make a copy of that record in a New Table, then make the adjustment to it, do the export and then update the Main Table with the amended record from this New Table.
Grateful for ideas.
I am using A03