HELP !!!!!!!!!!!!!!!!!!

[locutus]

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

[Serge]

You can run an SQL statement. Lets say I have 2 tables (Table1 and Table2). These two tables have common field (FieldId), now I want to update Table2.FieldNumber with the one in Table1 :

'Table1
FieldId
FildNumber


'Table2
FieldId
FildNumber
FieldText


'Here is the Update statement
Update Table2
Set Table2.FieldNumber = Table1.FieldNumber
From Table2, Table1
Where Table2.FieldId = Table1.FieldId