-
So - is the AccountID field from the people picker promoted? Or is this a list form?
-
I replied to your new thread, but wanted to add this here as well: https://www.infopathdev.com/forums/t/26246.aspx has some step by step guidance.
-
This post has some info that may help you: https://www.infopathdev.com/forums/t/26246.aspx
-
So - is it possible that previously there weren't any GLs that belonged to both companies? Because here is what is happening - you have GL 123 and for CompanyA the description is "One Thing" and for CompanyB the description is "Another". When you pick GL 123, the formula that only filters on the GL is going to return the ...
-
I knew you could get this. :)
-
My screenshot was from your own rule - I only added the company filter. Can you try the form I attached and see if the rule to set the description for the first row in your table of GLs works correctly when you select a GL that is the same between the two companies but has a different description?
-
Here's a copy of your form w/ this change made on the rule on GL1.
-
Sorry, I must not be being clear. Do your dropdowns in the GL column display the correct options? Ohhhhhh, I see what you are saying. You know what? I think you just need a second filter on your SetGLDescription rules - you need to compare on title AND on company.
-
Ok, maybe I'm confused too. So, your GL dropdown does populate correctly? It is just that the description is not getting set?
-
Here's another copy of your form with a test area added at the bottom - it has a repeating table bound to the Invoice GL data source. It has conditional formatting on the rows to highlight them if they match the selected Company in the form - save the file locally, right click and select Design. Preview the form, and try both the company radio ...