related fields in many to many relationship

[Sima2004]

As follows,

I have three tables. Peper , join , journalist. I want to have related fields between Peper and journalist sothat if i have changed somethimg in paper that changes also in journalist table. The relation between peper and journalist goes via join. Can i do somethimg to bring the changes in these two tables at the same time?

Thanx,

[RalphL]

I find it hard to envision what kind of field you would have in both Peper and journalist other than a key field.

If you are asking how to change a field in journalist from Peper, you will need a relationship directly between Peper and journalist.

[Sima2004]

I have a address field in paper table and in the journalists table. I want to do something that when i change something in the address of the paper table, that address goes automatically also in the journalists table. is that possible?

Thanks,