Hi
How do I update a whole record in one statement.
I want to update a table with the record from an identicle table but has slightly different values. The tables each have 81 fields so I dont want to have to set all the values as this would take ages to write. I just want to say something like this:

update reeldata where reelstore!number = reeldata!number

and have the whole record written at once.

How do I do this , every thing I have read in the help screen involves setting the fields.

Thanxs
Locutus