Add new Rcords

G

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!
 
D

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.
 
G

Gsurfdude

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

Douglas J. Steele said:
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.
Click to expand...
 
Top