Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> simple trigger problem ?
as a project i developed a simple database with oracle designer, including
application forms.
Here is what the problem is:
a table customer is linked to a table adress with a many to one
relationship.
when i update a customer's home adress via the form, the adress of other
customers who live at the same adress is also changed.
off course because if 3 customers live at the same adress, only one adress
record will be in the adress table. and if one of those three customers
change adresses, and i update that record, the two other customers will also
have that changed adress.
I was looking for a solution with database triggers (after update on adressen), but the problem is that at that point i dont know WHICH customer changed adress.
Is there a solution with database triggers or any other? tnx for al help Received on Mon May 08 2000 - 00:00:00 CDT
![]() |
![]() |