>Sorry Dan, must have hit the enter kit by accident on my last response.
>
>Any way, here is my suggestion:
>
>In your form init method:
>
>SELECT ;
>MAX(id_field) ;
>FROM table ;
>INTO ARRAY aHighestID
>
>IF _TALLY > 0
> THISFORM.object.value = aHighestID[1] + 1
>ELSE && No records on the table
> THISFORM.object.value = 1
>ENDIF
>
>This should do it for you.
>
>Good luck
Many thanks Juan to you and others who helped me with this...
although there were many very good syggestions, your example sure helped me to finally resolve this issue!
This is why I think the UT is the greatest thing since sliced bread!!
Thanks to all,
Dan
Dan Gilliland
ICQ# 15695715
"Man is still the most extraordinary computer of all."
John F. Kennedy (1917-1963)