-
Good deal - so you know, I generally avoid default values except for tricky calculated things (like total price, etc.) that use main data source fields. I actually did this same thing once, not realizing that my secondary data source was going to re-calc each time the XML was re-opened. :-) Ouch.
-
A million thanks! All working perfectly.
Once again you guys save my bacon and allow me to add some more IP knowledge to my toolbelt.
-
The rule goes on the field bound to the drop down. The formula would be just like the one you used in the default value - you want to set the target field to the value from the 2DS where the Title = Supplier. The thing to remember about rules is that they only fire when the field they are on changes.
-
Cancel that, I should have tried before asking :)
It looks fairly simply. New rule on the dropdown. Condition = when changes. Action = update other control and just use the same filtered formula I originally had.
This dropdown "feeds" a total of 3 text boxes so hopefully there is no problem with me added 4 rules to this one dropdown?
-
Can you provide me with a pointer as to how to achieve this for this functionality please.
Any time I've ever needed a control to be populated from a secondary connection (based on a change in another control) I've simply just entered a default value that uses a filtered formula
How do I harness a change in the drop down so that I can go ...
-
Use a rule instead of a calc'd value. If the calc is returning nothing it is overwriting your value.
-
excellent thanks Hillary. I wasn't sure of the correct syntax I haven't been able to find any good resources on advanced InfoPath dev, except of course this site.
-
Hopefully this screenshot can show all the necessaries - let me know if you need to see other rules/windows
https://skydrive.live.com/redir?resid=C18B04D5BB544DB4!205&authkey=!AJTS8WpxGR12sPs
-
Does the text box have a calculated default value? Or are you using a rule to set it based on the drop down selection? I think your data is being overwritten by the calculated default.
-
https://skydrive.live.com/redir?resid=C18B04D5BB544DB4!204&authkey=!ACT7icNg2QaS1jQ
This is a screenshot showing the calculated value for the ServiceRequired textbox (the affected one) and the 2 rules associated with form submission.
I tired to put the above path in by inserting an image but it kept showing as a broken image.