>Hello Everyone:
>
>I have a strange issue with a view created below
>
>

>CREATE SQL view vMacSet as;
>SELECT Mac_set.project,;
>		Mac_set.pk_macflds,;
>		Mac_set.SetValue,;
>  		Mac_flds.SetName;
>  	FROM mac_set ;
>		JOIN mac_flds ON Mac_flds.pk_macflds = Mac_set.pk_macflds;
> 	WHERE ( project ) = ( ?nStartProj );
> ORDER BY Mac_flds.setname
>

>
>The view is made up of two tables. All fields are updatable execpt the field "SetName" from the second table. My problem is that GETFLDSTATE(-1) does not return the proper setting if changes are made to the view. Same holds true for deleting records. Any help would be appreciated.
>
>Thanks, Mike

Hi Mike,

I haven't used views in many years, but the general advice is to only have one table updateable from a view. In your case I would have two views (one for each table) and then update them both in a transaction.