Add new Rcords

[Gsurfdude]

Hello,

I have a continuous form that is a subform who's record source is a query
based on 3 Oracle linked tables.
I have the record set type as Dynaset inconsistant updates. It will not
allow me to insert or
add new records. I have allow additions = yes, allow edits = yes.

How do I allow a user to add new records to this?

Thanks!

 

[Douglas J. Steele]

Do you have a primary key (or at least a unique index) defined for each of
the Oracle tables? ODBC won't let you update unless you do.

 

[Gsurfdude]

Yes, there are two PK's for all 3 tables.

Do you have a primary key (or at least a unique index) defined for each of
the Oracle tables? ODBC won't let you update unless you do.

 

[Douglas J. Steele]

What error message do you get?