copying id to another field based on matching contents
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")