This is a migrated thread and some comments may be shown as answers.

Mass Update with Child Tables

1 Answer 59 Views
Grid
This is a migrated thread and some comments may be shown as answers.
AkAlan
Top achievements
Rank 2
AkAlan asked on 06 Oct 2009, 09:07 PM
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.

1 Answer, 1 is accepted

Sort by
0
Pavlina
Telerik team
answered on 09 Oct 2009, 01:53 PM
Hi Alan,

Could you please review the following forum thread which elaborate on a similar subject and see if it is helpful for you.
http://www.telerik.com/community/forums/aspnet-ajax/grid/mass-update-on-grid.aspx

Let me know if you need additional assistance.

Kind regards,
Pavlina
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Tags
Grid
Asked by
AkAlan
Top achievements
Rank 2
Answers by
Pavlina
Telerik team
Share this question
or