Background:

I have a PROJECT form that has a relationship with CUSTOMER & AGREEMENT. The AGREEMENT field has criteria where CUSTOMER_ID == input.CUSTOMER_ID. This works fine in the form. Eg When I select customer 123, I can see agreements 12 & 22.

Problem:

I have a PROJECT subform in my CUSTOMER form.

When the user adds a new project, I expect the Agreement dropdown to show the relevant filtered agreements. However, I do not see any agreements. Eg When I view customer 123 & add a new project, the agreement dropdown is empty. Older rows however, do show 12 & 22 but not the new one.

Why are the fields in the subform not displaying the correct view when you add a new row?