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