Set Value in a column based on changes in value in another column

[Peter_S1]

Hi,

I’m trying to set a behavior to update Company ID when Company Name is changed.
I have two tables:

1. Company: lists Company ID and Company Name
2. Drivers: lists driver names, Company Name they work for, and Company ID which references back to the Company table.

What I have done so far:

1. I have set up an action
   a) Data: set the values of some column in this row
   b) Set these columns: Company ID (having trouble with the expression here to look up Company Name and return the Company ID from the Company table.

2. I’ve set up a worklow
   a) Target Data: Driver table
   b) Update event: updates_only
   c) Condition: [_THISROW_BEFORE].[Company Name]<>[_THISROW_AFTER].[Company Name]
   d) Set task category to Chang Data and linked the Date Change Action name back to action in step one.