>Still NULL value
>
>It worked well on VFP 6 problem begins with VFP 9
>
>anything wrong with tally in VFP 9 ?

would you not be better of making code an integer(autoinc) field?

if this is a multi user app is there not a (very small) risk of two people updating the table at the same time and getting the same code value ?

nigel