simple trigger problem ?

[Quoted] [Quoted] as a project i developed a simple database with oracle designer, including application forms.
[Quoted] Here is what the problem is:

[Quoted] [Quoted] 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 [Quoted] [Quoted] customers who live at the same adress is also changed. [Quoted] [Quoted] off course because if 3 customers live at the same adress, only one adress [Quoted] record will be in the adress table. and if one of those three customers [Quoted] [Quoted] change adresses, and i update that record, the two other customers will also [Quoted] [Quoted] [Quoted] have that changed adress.

[Quoted] [Quoted] I was looking for a solution with database triggers (after update on [Quoted] [Quoted] adressen), but the problem is that at that point i dont know WHICH customer changed adress.

[Quoted] [Quoted] Is there a solution with database triggers or any other? tnx for al help Received on Mon May 08 2000 - 00:00:00 CEST