Hello everyone,
How possible is it to update multiple tables with asp?
I am trying to update 4 related tables but only 3 of those have the fields that I am trying to update.
The fields I am trying to update are:
ProjectName,ProjectType, Description (From project table);
IssuesNote from (from Issues table);
DailyReport (from Notes table)
The 4 four tables:
Project
project_id int primary key, identity
projectName varchar(50),
projectType varchar(50),
Description varchar(2000)
projectTasks
projectTaskID primary key int, identity
project_id int foreign key from project
Issues
IssuesID primary key int idenity
projectTaskID int foreign key from projectTasks
IssuesNote varchar(4000)
Notes
NotesID int primary key identity
projectTaskID int foreign key from projectTasks
DailyReport varchar(4000)
Your assistance is highly appreciated.