What result set do you want for this example?

Arne


>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