Bill,
Try using Eview. A file posted her by Eric Moore. You can use this files to generate the code for building a local view from a view built with the Fox view designer or you can use Eview to build the view and\or code from scratch.
>Folks, this one has me stumped...
>
>I'm attempting to build an updateable view through code. For a particular view, there's the CREATE SQL VIEW statement, followed by a number of DBSETPROP statements. These DBSETPROP statements set the Updatable fields (and non-updatable fields) , the Parameters, KeyField, WhereType, Tables, UpdateType and SendUpdate settings for the view.
>
>Whenever I browse, change an updateable value, TableUpdate() and close the cursor, I get a message stating that no Key columns are specified for the update table, use the KeyFieldList property of the cursor. It's error # 1492.
>
>CursorGetProp([KeyFieldList]) returns the correct value.
>
>I have seen this clear up either by opening the view and resetting the key, followed by running my code settings. But not always<s>. I've tried clearing the KeyField/resetting the Keyfield in code, to no avail.
>
>Can anyone point me in the right direction on this?
Ken Wardwell