I have a table with employeecode as Primarykey. I need to change that. This Primarykey column is been referenced by employeecode in another table.i.e the employeeecode in another table is Foreign key <BR> so if i update the employeecode in Master table , the detail table will loose the reference, if i update the employeecode in detail table it will not have a reference to the new employeecode. <BR>What i did was Insert new record into Master table by changing the employeecode alone and all othre fields same as before , then inserting into detail table with new employeecode and then deleting the old entry. <BR>Entire operation under a transaction <BR><BR>Can we do this using Disconnected recordset? <BR>If so how <BR>or any other way <BR><BR><BR>Thanks in advance