Updating the Table Based on FK(ForeignKey)

Question

Hi i am having 2 tables 

table1(RID int PK,RTypeID int FK,Name VarChar,Active bit)

table2(RtypeID int PK,Name,Note,Active)

while changing the name in table 2 i want the changes to be made in table 1 how can i do ?

---

harika

Answer 1

hi,

You may use computed columns or a trigger.

I hope it helps.

Janos

---

There are 10 type of people. Those who understand binary and those who do not.

My Blog | Hire Me