Thank you so much, IS there a possibility to save the other_details from the main form. and I nee one more assistance. I need to sort Employee according to the field "Code" eg. CSK1, Sam, this record should appear only once, irrespective of their EMP_ID. I wrote a query group by code and...