Mohammed,

I overlooked the fact that ShipNo is a character field. Basically, you may have ShipNo as a character field and have a regular index on it and have an Integer PK in the table. If you do need to have ShipNo as unique identifier, you need to maintain its uniqueness by yourself.

>hi,
>
>after change to AutoInc, i got error message Function argument value, type, or count is invalid
>at this line,
>
>but i need to insert it by hand (it must be character type),
>

>cAlias = THISFORM.DATAENVIRONMENT.INITIALSELECTEDALIAS
>SELECT (cAlias)
>if act_flag="1"
>LOCATE FOR UPPER(shipno) =ALLTRIM(thisform.text1.Value)&& error message
>IF FOUND()
>=MESSAGEBOX("DUPLICATED")
>

>
>>>hi,
>>>thank you for reply,
>>>
>>>what that mean AutoInc field ,
>>>
>>It's a new type for integer fields.