I have an Access database which only consists of reports & forms.
All other objects resides in SQL. One form is based on a view which is based on 2 tables, but insert fails due to one table that has an autonumber field and cannot update thru the view. How can I work around this, besides hard caoding everything???