I have a problem updating the data because of relationship..

[Sasmi]

:confused:Dear Friends, I have a problem updating the record in sql database table because of relationship, i mean i want to update the data as per the relationship can i know the relation between two table at the run time by which i update the data in sequential manner. for eg. i have two table 1)Employees and 2)EmployeeTerritories in NorthWind Database in which Employees is Primary key table and EmployeeTerritories is foreign key table both are related to each other by EmployeeID if i want to update the data i have to update first in Primary key table (Employees)after that it update to foreign key table (EmployeeTerritories) but i want it at run time can any one know how can i do this.... Thanks in advanced Sasmi