add further records to a related table

Question

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