LOCAL loRecord USE Table && has fields PK, field1 and field2 SCATTER NAME loRecord MEMO *** Now you can use it to replace or insert into another table USE Table2 GATHER NAME loRecord MEMO && Replace a record or loRecord.PK = NewPK() INSERT INTO Table2 FROM NAME loRecord && Inserts a new record * at any time you can address or set the value of this properties as you would with any other object loRecord.Field1 = 'NewValue' && etc.