I’m trying to set a behavior to update Company ID when Company Name is changed.
I have two tables:
- Company: lists Company ID and Company Name
- 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:
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.
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.