Andy,

Thanks i agree it is a bit kludgy but how is this done when developing CLient/Server apps. This means you have to give user PK field which they can edit. For example
Customer table with

ID integer PK field
Name varchar
Address varchar
Title varchar

And SQL for view RV_customer is :

select ID, Name, Address, Title from myTable ;
where Name like ?c_Name and ;
Address like ?c_Address and ;
Title like ?c_Title

Now i have a form with only Name,address and Title displayed and remote view RV_customer bound to those fields.
I can insert the new record no problem but how do i see the latest changes to that record ( if after adding another user updates say value in the field NAME ).

How do i use the same view RV_customer to see these changes?

Thanks
Dejan