Jan,
I want to make sure I understand you. The second table is Distributors and the first is DistInfo UPDATE Distributors SET + Distname = KPRDistname + Etc + Etc + FROM DistInfo, Distributors WHERE T2.DistID = T1.DistID# (these are the linking columns) In other words I do not need T1 or T2 in front of each column I am updating? James Belisle ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Saturday, March 26, 2011 7:14 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: [No Subject] 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
