Hi all,

    Been struggling with this issue for a bit and I feel like it is pretty simple, but I am just missing something obvious in the workflow script so any help for a beginner would be greatly appreciated. 

    My goal is to have different forms auto populate look up fields from other forms based on the selection of a lookup field - see below:

Form 1

Form 2 - each input into field B will have a corresponding Field A category (both fields are selected by the user on this form). Every input into Field B will correspond to a single record in Field A from form 1. 

Form 3 - each new record of Field C the user will select Field B and I want field A to be auto populated based on that selection of Field B. Every input into Field C will correspond to single record in Field B and as a result a single record in Field A. 

      - Field C (single line) - user input

      - Field B (look up) - user input

      - Field A (look up) - auto populated

Form 4 - each new record on this form begins with the user input of Field C (look up) and I wanted Fields B/A to be auto populated based on that selection.

     - Field C (look up) - user input

     - Field B (look up) - auto populated

     - Field A (look up) - auto populated 

Thanks in advance for any help on this.