>I am working on a database that a former employee designed. In this database, he has a local view called facility, which apparently copies from the table fac_mas. I added a field into fac_mas, and then the database pretty much went haywire.
>
>I get the error message now that "No key columns are specified for the update table "solid!fac_mas." Use the KeyFieldList property of the cursor.
>
>Now I am not familiar with local views at all and honestly I can't understand why there is one here. All I did was add one field to the fac_mas table and now this happens. Anyone who is more familiar in this area able to help?
Ron,
Open the view in the designer and post its query here.
If it's not broken, fix it until it is.
My Blog