>Dear Experts
>
>Table Zone has two fields as
>
>Zone c(1)
>Name c(30)
>
>And data in table as follows
>
>zone-----name
>A---------Eric
>B---------Bill
>C---------Nomi
>E---------Rich
>
>Form’s Activate event has following codes
>

>select zone
>index on zone to zone1
>go top
>thisform.GRID1.RecordSource="zone"
>thisform.grID1.COLUMN1.ControlSource="zone.zone"
>thisform.GRID1.COLUMN2.ControlSource="zone.name"
>

>
>Grid1 has Allowaddnew=.t.
>
>I add data into zone table through grid but it accept duplicates
>
>I want column1 must not accept duplicate values
>
>Suppose Column1 has “B” then it must not allow “B” to enter.
>What validation rule should I apply on column1?
>Or there is some other methed exists?
>
>Please help

index on zone to zone1 CANDIDATE

and after that you should intercept the error when double zone is inserted.