>Hi,
> I have defined relationship among table in my database. How could I take advantage of relation without use of data control??
> I am looking for the more suitable way to edit the value of foreign key value....
>
>Thnak you

It depends on your environment. Being that you mention the data control I assume you mean how to edit the foreign key of a related table from the client side. Is this correct? If you want to do it from the client side then this has to be included in your program. If you have some sort of backend that works with stored procedures or triggers then that is another way to go. If such backend supports cascading updates then that's the easiest way, you don't code anything.