I'm using a dynamic drop-down to pull data from multiple forms, and everything works well until I try to populate two fields from the same form. Here's the setup:

Form A:
Area text field.

Form B:
Area - dynamic drop-down linked to Form A
Department text field.

Form C:
Employee Area - dynamic drop-down linked to Form A
Employee Department - dynamic drop-down linked to Form B
Employee ID
Employee Name
Employee Mobile

Form D: Uses dynamic drop-downs to pull data from other forms:

"Area" from Form A
"Department" from Form B
"Employee Name" from Form C
"Employee Mobile" from Form C

The issue arises when trying to retrieve "Employee Mobile" in Form D - it simply doesn’t pull any data. All other fields work fine, but this specific field does not populate as expected.