Populate field based on another fields attribute

Discussion created by bjclose on Dec 13, 2011
Latest reply on Dec 16, 2011 by rfairhur24
I have a table that has two records for every linear feature I need to map, one record for the FROM and one record for the TO. I need to populate the TO field of the first set of records with the TO attributes from the second set of records. I attached a screenshot. I can create two table from the two sets of records and then join based on the "unique" value for the set of records but I would rather just populate the field if possible.

Additionally, I need this to work in a model because I will run this process weekly.

Any ideas?

Thanks in advance!!