Hi,
I have a form that does a swop out of equipment.
The table has fields that relate to the current equipment and previous equipment.
When the user selects the option to swop out equipment, the info that resides in the current equipment must be moved to the previous equipment ino and the current equipment must to be to blanks (awaiting details for the new equipment).
This must happen when the form is displayed to the user.
How can I achieve this ?
Thanks