rajeev kumar

rajeev kumar

  • 1.8k
  • 141
  • 8.2k

add further records to a related table

Jul 20 2016 9:27 AM
I want to add a new record to a table (from fields in a FormView) and add further records to a related table using the [identity] column from the first table as a foreign key in the second table.
 
example
 
tbl_parant 
 
 id :1
Name : alex 
mob: 1234
 
and insert parents id into tbl_child. (alex has to visit ..n days (max 20) to city for metting).
alex will go on which day, where will go and for what purpose 
 
Like
 
 tbl_child
 
id    day 1   day2          day3 ...............day n
1     delhi  (purpose : details)   mumabi (purpose : details)      patna (purpose :details)......nnnnnn
     
 
 
 

Brought to you by: JavaScript SDK for Bold BI dashboard and analytics embedding. Free trial.

Answers (1)