Through multi select listbox store in database
this is my project tablecreate table tbl_project_master
(
Project_id int primary key,
Project_code varchar(20) not null unique,
Project_name varchar(50),
Project_Description varchar(max),
Start_of_Date datetime,
End_of_Date datetime
)
this is my task table
create table tbl_subtask_master
(
Task_Id int primary key,
Task_Name varchar(50),
Task_Description varchar(max)
)
this is child table
create table tbl_project_subtask
(
Project_id int FOREIGN KEY REFERENCES tbl_project_master(Project_id),
Subtask_Id int FOREIGN KEY REFERENCES tbl_subtask_master(Task_Id)
)
project id is in one drop down list
task name in list box
when am selecting project id and multiple task name values that will insert into child table that is tbl_project_subtask in database