Erin Something like (assuming you've located the 2 records in question):
DIM loObj as Object, lnRowId as Integer ... loObj = SourceTable.Obj lnRowID = DestTable.RowID Update DestTable set Obj = loObj Where RowID = lnRowID Terry McDonnell -----Original Message----- From: Erin Scanlon [mailto:[EMAIL PROTECTED] Sent: 14 October 2005 19:16 To: Terry McDonnell Subject: MI-L Need to update obj in table1 with obj from table2? I have two tables and I need to update the obj in one with the obj from the second. There is an corresponding field of STORE_NUM which is a character field in both tables. Can anyone help please? Erin Scanlon GIS Specialist Market Research Phone: (401) 468-2637 CONFIDENTIALITY WARNING This message, including its attachments, is strictly intended for the use of the individual or the entity to which it is addressed and contains privileged and confidential information. Disclosure, distribution or copy of this communication is strictly prohibited. If you are not the intended recipient please notify us immediately by returning the e-mail to the originator and deleting all copies. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 18317