i want to insert new row in second table and this table connected to first table.
How can i do that?
dharam_05
0
Newbie Poster
Recommended Answers
Jump to PostBy giving us some additional data like what is structure of these two tables?
Jump to PostThere is nothing to update in first table Emp_id what links both tables. So if you trying to get salary of an employee you either have already person's ID or you will find out through matching of employee name and department against Emp table. Once you get that ID then …
Jump to PostHello dharam if u know the concept of Primary and Foriegn key than it wil be very easy for u to maintain the things as you cant add any salary for an id that does not exist in parent table so rather than putting an trigger on it, it would …
All 10 Replies
peter_budo
2,532
Code tags enforcer
Team Colleague
Featured Poster
dharam_05
0
Newbie Poster
peter_budo
2,532
Code tags enforcer
Team Colleague
Featured Poster
dharam_05
0
Newbie Poster
peter_budo
2,532
Code tags enforcer
Team Colleague
Featured Poster
dharam_05
0
Newbie Poster
dharam_05
0
Newbie Poster
peter_budo
2,532
Code tags enforcer
Team Colleague
Featured Poster
dharam_05
0
Newbie Poster
AllieK
1
Newbie Poster
Shanti C
commented:
yes....
+1
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.