Register now or log in to join your professional community.
suppose if i have 10 tables and i have changed the data in the master table it has to be effect in the child table also ...pls can anyone knows tell me the answer..it will be helpful for me
you can make relations between tables by the explorer window on the left of the screen by choosing the tables you want but you must take care of the logic relation between relative data in all tables to the master table by code and making a primary row on the master table and a secondry row on the child table that is related by code to each other
i hope i hit the right answer
Create After Update, After Delete trigger in Master table and writer necessary SQL scripts in triggers to do changes in child tables.
You can use replication (Snapshot or Transaction Replication)
or you can use triggers (After insert / After update / After delete)