I have two tables: TableX & TableY
there is two similar fields (Size) with the same datatype, I want to make a relation in a way if I change the value in (TableX.Size) the same value will be applied to (TableY.Size).
How to?
Lewe:
The are a couple of things that you need to know first:
How does TableX relate to TableY? TableX SHOULD have a key to TableY so that corresponding X and Y members can be joined|||
I'm not sure that you are really talking about needing a 'relation'. It sounds as though you only want a method that will change TableY values when a similar value in TableX is changed.
That 'could' be done with a TRIGGER. But first, it will be necessary for you to identify which row in TableY is to be changed as a result of a particular row in TableX getting changed. In other words, "How do the two tables 'relate' to each other?"
No comments:
Post a Comment