Click here to Skip to main content
15,891,777 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I have 4 tables : produtmastertable , productdetailtable , plugintable and plugindetailtable

Now i add new product using asp.net and the entry is going in the productmastertable . Now i want to restrict that whenever there is a product add then only new plugin is added in the pluginmastertable .

So what i have to be do?
Posted
Comments
Herman<T>.Instance 4-Aug-11 7:18am    
what have you tried?
any code to share?
arindamrudra 4-Aug-11 7:23am    
Both the operation as happening at the same time? I mean "pluginmastertable" updates at the same time?

1 solution

Add a foreign to your pluginmastertable that references the primary key of the productmastertable. Also Plugins and Products make better names for tables than the names you have given them.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900