-
Hey, Gwen, sorry I missed these posts. You could use qRules SetValue for this - your command would be a formula like (obviously I've got some placeholders in here!):
concat("SetValue /dsname=SECONDARYDATASOURCENAME /xpath=XPathToYourField[FilterField = '", SelectMainDSField,"'] /value=", ...
-
Just emailed you - send it to me in a reply & then you don't have to worry about cleaning anything up, or about having it posted to the forum. :)
-
Any chance you can post a copy of your form? Under the options tab in a reply. The short answer is "yes" - this is possible & shouldn't require code. The exact implementation details will vary based on how your form is set up. It is easiest for me to help you if I can just modify your form. :)
-
Hooray! glad to have been of assistance. :)
-
Hooray! glad you got it. This is one of those things that can be really tough when you first start but once you have it figured out one time, gets easier the next. :)
-
No. Your dropdown should be bound to the name, as it is. Is the ID column your primary key? Because your form looks right and your error message indicates an issue with the PK field. If the ID field is an auto-incrementing integer and you are submitting new rows via the form, the submit should succeed.
-
Your DB admin should make distListID an identity type in the database. Then when the form is submitted, you'll automatically get a unique ID in the DB.
-
Any chance you could attach a copy of your form to a reply under Options?
-
Are you submitting blank values in them? Is the drop down bound to the primary key field? Or does the table have an identity column?
-
In InfoPath, a multiple selection list box is bound to a repeating field. But with a database bound form, if you had an associated table to store the values from the multi select, you'd have a repeating group for the associated table, and you won't be able to bind a multiple selection list box to that. I can't think of a way to mimic ...