Jim,
Since it doesn't look like it matters which column may be updated just
update your second table like this.
UPDATE table2 SET +
colname1 = colname1, +
colname2 = colname2, +
colname3 = colname3, +
colname4 = colname4 +
FROM table1, table2 +
WHERE table2.linkcolumnid = table1.linkcolumnid
Jan
-----Original Message-----
From: "Jim Belisle" <[email protected]>
To: [email protected] (RBASE-L Mailing List)
Date: Sat, 26 Mar 2011 15:59:33 -0500
Subject: [RBASE-L] - [No Subject]
I have two tables that have the same type information.
When updating one table with a form, I want to be able to update the other
table at the same time.
Since there are 40 fields and I would not know which field might be edited,
what would be the best way to go about this?
Would I have to have a compID on all FIELDS then have the update command
always update all fields?
Any suggestions would be appreciated. All fields are text fields
James Belisle
