-
Hello.
DBXL can "shred" to multiple nested tables and even seperate tables but some times this can be tricky. The key is that you will need to match your table structure in SQL and your data source in your form.
So if you have in your form
Main
Group1
Field1
...
-
Well if you drag the repeating group from your secondary data connection on to your form and it only shows one row then that is your issue not the setup in the list control.
You may want to set up your data connection again. By default you should get all rows of the table. Is this an Access table? Where is the data coming from?
-
Bonjour
Ma société est en cours d'installation de MOSS2007 + CAL ENTREPRISE et de office 2007.
Nous avons déjà un certain nbre de formulaires existants sur 2003, et bien sur l'objectif va être de les migrer pour bénéficier du full web . Cependant il semblerait que tous les fonctionnalités du client lourd 2003 ne soient ...
-
Hi,
I need to populate a dropdown from a sharepoint list and by default the dropdown should show all the values in the list. And on selection of a value(s) in a Multiple Select List box, the values in the dropdown should show only values corresponding to the values selected in the multiple select list box.
How can I achieve ...
-
Hi,
When I publish a InfoPath 2007 form from Visual Studio and then activate that form to a site collection in Central Admin everything works good. Promoted fields appear on the form library when I use the template as a content type on that form lib.
However, if I then make a change (add a promoted field) in Visual Studio and re-publish ...
-
Hi!
The problem is urgent.
I followed the instructions of tutorial "Configure Database Mappings in DBXL" and succeeded.
I made a slight change to the sample form in the tutorial, just change the child table's Primary key to an identity key, and add another colum to relate to the Primary key of the parent table.I assumed ...
-
Hi,
I'm submitting a form from a top level portal form library to a lower level (different site collection) form library. The submit works fine with no errors and I'm doing it this way so no users can see where the forms are being submitted to.
When I try to open the forms that have been submitted from higher to lower I get an ...
-
Hello Clay
Thanks for replying. I have the namespaces from the form, I'm just not sure how to set them in the code. I tried:
Document.DOM.setProperty("SelectionNamespaces", "xmlns:dfs=\'http://schemas.microsoft.com/office/infopath/2003/dataFormSolution\' ...
-
Hi Clay,
FYI, i've done steps 2 and 3 and came out with the same result.
I've try as u suggested in step 1, and it appear to show only 1 data (data from the first row)..
In the secondary data connection, do I have to set anything (e.g. sql statement) in order to retrieve all the data in the table?
-
OK so you tried installing the Database Accelerator on your PC?
It will work on Vista but it is a bit more difficult. If you have a server environment that is what I would recommend. However you can install it on Vista. You need to make sure you install IIS. Then .Net. Then SQLExpress, Then DBXL.
From a testing standpoint it does not matter too ...