Team - I am creating project management application in classic asp. since the milestones will be different from project to project, I created a Template table to save milestones with milestone id and template id as primary and foreign key. I also have a project master table with project id being primary key. I am facing problem to call the milestones dynamically and saving them to ms sql.
Ex: project id is 5000
template Id is 2000 which has milestone id from 1 to 10.
In the dynamic form I would like to display milestone name, start date, end date, resource name and allocated hours and save them to sql. Kindly help