-
I mean - the only thing I would do differently in general is copy the secondary data into the main data source BEFORE the user changes. So I wouldn't hide the main data source table... I just wouldn't display the 2ds. :)
-
I've never seen the issue of promoted columns disappearing. As to the issue of promoted fields not displaying data for existing forms, this a known issue. The easiest work around I know is to open the library in Windows Explorer, select and copy all the XML, and paste the XML locally. As the files paste to your local folder, they will be ...
-
I wasn't referring to the value / display of the control, but the formula you were using to set the value of the field - were you setting it to an ID or to a text value?
-
Maybe create a library in SharePoint, then, when publishing, select the option to update an existing library? Worth a shot....
-
Hi - if you can attach a copy of your form with the list data connection and the Country dropdown configured, I can help you with this. You can add an attachment under the Options tab in a reply. :)
-
Oh I HATE it when that happens. Sometimes I save the form as source files and manually clean up the view. You could try just recreating the table. You could also try individually formatting the cells (if you'd applied the format to the columns).
-
You don't have your users editing the text in a control bound to the secondary data source, do you? Or are you copying the data into your main data source....
-
When you set the value, do you set it to the ID? That's what it needs to be set to.
-
Is this a SharePoint List form? Is the field you are setting a lookup type? They need to be set to the item's ID usually. Otherwise, I'd just assume something is awry in the data types in your main schema.
-
So, it sounds like you have a different data connection for the dropdown items. If so, you could just query for the data you need after the user makes each dropdown selection and use rules to set the fields instead of using defaults. You'd have to run the query for each row once the user selects a dropdown value, but that would limit the data ...