AnsweredAssumed Answered

copying id to another field based on matching contents

Question asked by AdamReed on Dec 2, 2011
Latest reply on Dec 3, 2011 by 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?

Outcomes