Thanks Buddy, that worked just like I wanted. Tom Hart
----- Original Message ---- From: "Walker, Buddy" <[EMAIL PROTECTED]> To: RBASE-L Mailing List <[email protected]> Sent: Tuesday, February 19, 2008 6:22:04 AM Subject: [RBASE-L] - RE: Importing new data Tom Project a temporary table from the permtable PROJECT tempTable FROM permtable USI ALL WHERE COUNT = 0 Load the data into tempTable Del rows from temporary table where uniqueid in (sel pkcolumn from permtable) Either append the temporary table to the permtable or use INSERT INTO permtable. Buddy From: [email protected] [mailto: [email protected] ] On Behalf Of TOM HART Sent: Monday, February 18, 2008 11:52 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Importing new data How is the easiest way to import new data into a table that has a PK? I have 2 businesses with each store having different inventory but I would like to merge the data(Sync) so each database has all the inventory. I know I could use the Fetch command, but is there an easier way. Tom Hart
