Autopopulating lookup fields from multiple forms

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

- Field A (single line)

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.

- Field B (single line) - user input

- Field A (look up) - user input

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.