data relations synchronization
i have a problem:
i have 2 tables on the db
one is id_names which has 2 rows: id(key) , and name
and the other one is employees_info which also have id(key) , and some more rows
i did a data relation between id_names and employees_info which are related with the id
now my problem is this:
when i update the id on the id_names table it doesn't update the id on the employees_info table
so, how can i do it?
thanks
[470 byte] By [
igalk474] at [2007-11-20 9:29:02]

# 1 Re: data relations synchronization
You need to change your foreign key action to cascade on updates.
Read more here: http://msdn2.microsoft.com/en-us/library/aa933119(SQL.80).aspx
If you're looking to do this programmatically to a DataTable, look here: http://msdn2.microsoft.com/en-us/library/system.data.foreignkeyconstraint.aspx
# 2 Re: data relations synchronization
maybe , if it's not too hard for you , could you show me an exmple of how to do it , i really need this
thanks!