Peter,

Are you saying that it works even though the index is regular, not primary? That isn't really the issue. The issue is whether there are duplicate values in the field you're using as your key. If there are, you could run into trouble. One issue may be if you use Key and modified fields or Key and updatable fields in the Where clause. If so, you may get away with it even with duplicate keys. This is not a good idea, though. You should never create an updatable view on a table that doesn't have a primary key!

>John,
>I thank you again for your help but get this, I 've since created a test database and added a new table "Claimelements" on which I've created a view the SQL is as follows it has a regular index on clm_ref ( the same as before )
>
>SELECT *;
> FROM pkviewtest!claimelements;
> WHERE UPPER(Claimelements.clm_ref) = UPPER(?THISFORM.CLM_REF.VALUE)
>
>It works!!??
>Regards
>Pete Kane
>n.b. Maybe SQL Update uses the recno()?
>