Forcing an insert into a View using Access

J

Jeff

Hi,

I have a View with an 'instead of' insertion trigger on it. Consequently i
would like my users to be able to insert records into this View (the trigger
will take care of the insertion into the actual underlying tables).

Unfortunately, on the Access front end, i see that 'new' button is disabled
(despite the fact that the 'allow Insertions' property of the form is set to
'yes').

Any ideas how i can force Access to allow inserts on this View?

Thanks in advance.
 
J

Jeff

Oops! silly me - turns out i had forgotten to select a primary key when i
linked to the View. Sorry !
 
Top