REPLACE PAID_ID WITH GETKEY('PAID_TOB')If you put GETKEY('PAID_TOB') as the default value for the PAID_ID field, it will automatically populate the PAID_ID field when you do an append on that table. There is no need to have the above line (PAID_ID will be assigned a new value again).