locked
sharepoint 2007: copying a record RRS feed

  • Question

  • How do you update a row based on another row that is contained within the same group? Where the data is the same in ColA, copy the data in ColC for each row.It is grouped on ColA.  I know how to update it in SQL, but I do not know how do this when a user updates the record through an Edit form in SharePoint 2007.

    Example:

    ColA ColB ColC
    22301 22301.00 AAAAA
    22301 22301.01
    22301 22301.02
    22301 22301.03
    22301 22301.04

    22302

    22302.00 BBBBB
    22302 22302.01
    22302 22302.02
    22302 22302.03


    peonysmiles

    Saturday, October 20, 2012 11:43 PM

All replies

  • Hi peonysmiles,

    You need an event receiver created with Visual Studio to update the other items when an item has been updated. Please refer to following blog to create an event receiver in MOSS 2007.

    http://farhanfaiz.wordpress.com/2007/12/31/creating-adding-an-event-handler/

    Thanks & Regards,
    Emir Liu
    TechNet Subscriber Support in forum
    If you have any feedback on our support, please contact tnmff@microsoft.com


    Emir Liu

    TechNet Community Support

    • Marked as answer by Emir Liu Friday, November 2, 2012 6:56 AM
    • Unmarked as answer by fjaconda199 Tuesday, November 20, 2012 1:48 PM
    Monday, October 22, 2012 7:07 AM
  • I tried to create a workflow which would have made sense.  But instead of updating, it copied the entire record item.

    Rose

    Monday, February 11, 2013 1:58 PM