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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add new Records 2
blank form, can't insert new record 11
Additions Denied 4
Can't edit subform - main form should not be edited. 2
updateable query 8
My data entry form.... isn't adding new data? 3
Why are the subform records locked? 1
Can't enter data in form? 9

Top