Hi..Arne

Table1
------------------------------------------
ID NAME DIAG OPERATE
------------------------------------------
1 Jim 001 A01
1 Jim 002 A02
2 Jack 001 A01
------------------------------------------
Used your query

Table1Cur
-----------------------------------------------------------------
ID NAME DIAG OPERATE RecordNumber
-----------------------------------------------------------------
1 Jim 001 A01 1
1 Jim 002 A02 2
2 Jack 001 A01 1
----------------------------------------------------------------

Table2
--------------------
ID NURSE
--------------------
1 Jenny
1 Anna
1 Mam
2 Anna
2 Jenny
--------------------
Used your query

Table2Cur
-------------------------------------------
ID NURSE RecordNumber
-------------------------------------------
1 Jenny 1
1 Anna 2
1 Mam 3
2 Anna 1
2 Jenny 2
------------------------------------------
I wanr to reset RecordNumber field after query when ID changed..

Can you help me?

Narong