When I insert a new record, I want it's auto-incremented key value to be copied to another column in the same table. Can this be done or should I insert and then update it?
Yes , i think if u r using mySQL as ur database , u will have to first insert it , retrieve it using mysql_insert_id function and then update !!
Shilpa.
