Mass Update with Child Tables

2 posts, 0 answers
  1. AkAlan
    AkAlan avatar
    121 posts
    Member since:
    Jun 2009

    Posted 06 Oct 2009 Link to this post

    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.
  2. Pavlina
    Pavlina avatar
    6161 posts

    Posted 09 Oct 2009 Link to this post

    Hi Alan,

    Could you please review the following forum thread which elaborate on a similar subject and see if it is helpful for you.

    Let me know if you need additional assistance.

    Kind regards,
    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.
Back to Top