Upadtaing a table field

[webcrab]

Hi!
I have two tables that each one of them have the same field and I would like one field in table 1 to get updates according to the field in table 2
You can say that I can use a relationship between them, but I have aleardt a one to mant realtion in these two tables so i can't make another relation like that - so what else can I do?

Thanx!

 

[Rabbie]

Is your data prpperly normalised? You say the tables are linked in a One to Many relationship then you should always be able to get the value in the other field whenever you need it.

Some more details of yopur structure and what you are trying to do would be helpful

 

[webcrab]

Both tables are linked because there are two more fields (in the two diffrent tables) that are related and one of them is used as primary key and the other(in the second table) is linked to it- so here are one relation. But can I make another relation in the two diffrent tables in two diffrent fields?

 

[Rabbie]

Both tables are linked because there are two more fields (in the two diffrent tables) that are related and one of them is used as primary key and the other(in the second table) is linked to it- so here are one relation. But can I make another relation in the two diffrent tables in two diffrent fields?

This is confirming my suspicion that your data is not normalised. Data should only be stored once in a DB. Since you have established a relationship between the two tables you shouldn't need to store the other data in two places. if you give more information about your structure we will be able to help you.