Hi..Arne
I try solve my problem..But I have now problem..I have more ID data in my Table
Example1
Table1
-----------------------------------------------------------------------------
ID NAME DIAG OPERATE
---------------------------------------------------------------------------
1 Jim 001 A01
1 Jim 002 A02
2 Jack 001 A01
---------------------------------------------------------

Table2
---------------------------------------------------------
ID NURSE
------------------------------------------------------
1 Jenny
1 Anna
1 Mam
2 Anna
2 Jenny
----------------------------------------------
I want reset RecordNumber field when I change ID

Can you help me?

Narong