
Is there a way to create a Workflow Action which would update the value in the lookup field to equal the value in the picklist. Would this action be timely enough to allow other formula fields, which are based on this Parent-Child relationship to be updated?
Thank you,
Rick
8 answers
No. In Workflow Updates, the Lookup() field can only be set to a specific record of the appropriate type. You'd need to use a trigger to take the picklist value, lookup the appropriate record, and set the Lookup field to that record Id.