Hello!

I have 3 forms, form 1, form 2 and and inspection form.

Form 1 is as below:

Code is a manual input text field that its value need to be use in inspection form after saved.

Form 2 is like below:

Code is a manual input text field that its value need to be use in inspection form after saved.

Inspection form:

In the inspection form above, in the Process select box, I want to have the list of value from Form 2, but only where its status is "Active". 

For example I have process 1 (status is Active) and process 2 (status is drop). In the selection box, I only want to show Process 1 as the option and not show process 2 which is status is Drop.

For the Spreadsheet below, Parameter is a drop down column where its value come from Code from Form 1. Same as above, I only want the list of options in Parameter dropdown to show only the Status is Active.

Please help me on how can I achieve the above conditions?

Let me know if any additional information required.

Thanks!

Regards,

Wesley