Hi Citen,

DRINFO is the parent table.
Table1 is the child table.
To be able to related this table I have a index field called DRNUMBER in DRINFO and
DR_NUMBER in my table1, so when I move the record to DRINFO all records of table1 with same drnumber in DRINO will populate in the grid1.

With regards to searching of serial number, this works only when table1 is not related to parent table.(Because I tried to test it) Since the table1 is my child table, searching serial number is not working properly. I have 2 index field in table 1, the DR_NUMBER and of course the serialno field.

I hope it's clear...

Please help..

Thank you for your patience.

Mike