>>>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, I'm sorry to interrupt here, but this way is highly suspicious in multi-user environment.
I agree 100% with you Edward, however, this is one is those rare instances where this short and simole functions will work since it is NOT going to be used in a multi-user environment, should work fine.
Any other app I would normally have used something like UniqueId()....
Dan
Dan Gilliland
ICQ# 15695715
"Man is still the most extraordinary computer of all."
John F. Kennedy (1917-1963)