I want to know how to write a script that updates one record with data from another record in the same table.
For example, select two records in the same table by Unique ID, then copy the contents of each non-blank field of record with Unique ID "A" into the corresponding field pf record with Unique ID "B"
The only way I can see to accomplish this is to copy the contents of the relevant fields from Record A into a holding record in a second table, then move the data from the holding table's record in to Record B of the original table. Seems like a long way around the barn. Is there a better method?