6 Replies Latest reply on Dec 3, 2011 10:43 AM by AdamReed

    copying id to another field based on matching contents

    AdamReed

      Title

      copying id to another field based on matching contents

      Post

      I imagine this is a simple question...

      I'd like to copy the id from one field to another in a separate record when the contents of two separate fields match.  In this example I'm trying to assign "parent company ids" to "companies," for example:

      If I have two companies, "Random House" and "Knopf", and Random House is Knopf's parent company, I would like:

      Random House (company id "1", parent company id "")

      Knopf (company id "2", parent company id "1")

      Any thoughts?