Add new Rcords

  • Thread starter Thread starter Gsurfdude
  • Start date Start date
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!
 
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.
 
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...
 
Back
Top