-
So, in the attached file, I made a couple little changes - for the two fields in the upper right, I changed the dropdown to store the ID and display the Title. My guess is that in your assorted connected lists, the lookups are going to actually have the ID for the list item, not the text value (even if the text value is what SharePoint ...
-
Do you want to store the ID and display the value? If so, you could use a calculated value to get the display column from the appropriate list based on the ID. You can attach your form in a reply under the options tab if you'd like me to give you a hand. :)
-
Can you attach a screenshot under the Options tab in a reply?
-
Drag your secondary data sources onto the form so you can see the actual values in the different columns. That may help you with your filter. If you want, attach a copy of your form under the Options tab in a reply & I'll try to take a look at it tomorrow.
-
Hmmm. I'm really not sure what to suggest. conn.Open() is what gives you the thread is being aborted error?
-
To start with your initial question - cascading dropdowns work the same way in any form. You add a filter to the second dropdown to only show items based on selections in the first dropdown. Querying to get back just the items you need is an alternate approach - if your dropdowns aren't in a repeating table or section. My assumption is that ...
-
So - do you have a rule setting WHL Team in the query fields in the PlayerProfiles data connection in your form? What are you setting it to?
-
I'm confused by your initial code sample where it appears you are running the code on form load. Your button click appears to only show a message box - which if this is browser form will fail - but it looks like it is filler form from the using statements. Or did you change this code from your initial post? At any rate, I'd add some ...
-
Are you using a rule to set Col2? What are you setting Col2 to? Do you have a filter on the XPath? I don't need to be able to preview your form, so it having data connections doesn't really matter - I just need to look at it in design mode.
-
So, when you run the form in debug / preview, the form works as anticipated? The error is when the form is opened the browser?