Access 97 -> Oracle 7i Newbie-Questions

Hi there!

I try to convert my Access-Backend on Oracle.

Now I wanted to export my queries as views. But if I want do insert data in the way I did in Access (the same SELECT-Query that search the data), Oracle display the message "data manipulation operation not legal on this view" How do I insert data with my forms?

Another problem is, that I can't change a field that's referenced by another field.
A table MK has a field KN. The table AV has a field KN as primary key. The MK:KN has a reference on AV.KN.
If I want to change the value of MK.KN, it should make the same change in AV.KN. But it doesn't. Instead of that it gives an error. Can this be done with a trigger? If yes, how?

Thanks for tips,

Bye,
Stefan D. Received on Tue Feb 26 2002 - 06:11:30 CST