Katherine:

I should not allow filling the Form B if user has not completed Form A.

In that case I 'd create a Global Panel containing all controls/fields to be filled and show/enable that global panel based on the Form A Condition.

Hi Fernando,

The tricky part is the form is not filled out by the user, it's completed by their manager, and they aren't completed at the same time. Nor can I guarantee that the same user will complete both forms. 

At the moment, the solution I have is working and will work for what we want. If I can filter the list of users. I think I've found a way around it - a bridge list that has all the users which have not completed the Form B, and utilising the workflow to add and remove users from the list. This will also help us workout who has not completed Form B once Form A has been lodged.

So, now I just need to figure out how to copy across from one list to another.

Thanks for your help though

Hi,

So the bridge list didn't work the way I wanted, so I created a field in Form A called Form B Completed. This is defaulted to 'no', but is changed by Form B's workflow to 'yes' after Form B is submitted.

I pulled the user's names from Form A, filtering where 'Form Completed' = Yes.

I hope that made sense. It also provides more clarity when we want to see who has and who has not completed Form B after completing Form A.

Great!, please set it as answered