I am trying to figure out the best way to perform a mass update when there are child tables involved. My situation is documenting work performed on weekly inspections.
I have three tables involved, the main table is WorkOrders, the first child table is WorkOrderDetails and it's child table is DetailsLabor. For every WorkOrders record there must be at least one WorkOrdersDetails record and for every WorkOrdersDetails record there must be at least one DetailsLabor record.
90% of the time there is only one record in each table and I am trying to create an interface that minimizes the time taken to document the inspections. I have a regular asp formview that I use for documenting the inspections and it works pretty well by allowing the user to add records in both the WorkOrdersDetails table and the DetailsLabor table by first entering a WorkOrdersDetail record and grabbing the ID created with @@Scope_Identity then updating the DetailsLabor table. The problem is they always have to navigate to the update form through a gridview which summarizes all the inspections.
I have three tables involved, the main table is WorkOrders, the first child table is WorkOrderDetails and it's child table is DetailsLabor. For every WorkOrders record there must be at least one WorkOrdersDetails record and for every WorkOrdersDetails record there must be at least one DetailsLabor record.
90% of the time there is only one record in each table and I am trying to create an interface that minimizes the time taken to document the inspections. I have a regular asp formview that I use for documenting the inspections and it works pretty well by allowing the user to add records in both the WorkOrdersDetails table and the DetailsLabor table by first entering a WorkOrdersDetail record and grabbing the ID created with @@Scope_Identity then updating the DetailsLabor table. The problem is they always have to navigate to the update form through a gridview which summarizes all the inspections.