-
Unfortunately, with the default database connectivity, there is no way around this. A child is created automatically with each parent.
If you use webservices you can free yourself from this behavior.
You can sometimes hide the children in the view, so that even though it is there, it is not seen by the user if that can work.
-
Is this on the same website as SharePoint?
You may need to enable cross domain in Central Admin if it has to go to another server.
Also if there is authentication you cannot pass NTLM from one server to the other since SP is being your proxy with the UDC.
-
We offer a prebuilt web service for databasing your form and extracting the data into whatever tables you need. The suite includes the ability to dynamically query data from SQL and an Active Directory web service that can give you some advantages over the user profile service you mention.
Here is the link to download a trial but I would ...
-
Unfortunately I do not believe there is anyway to dynamically set these connections or make them realative.
You would probably need multiple form templates, modified for each customer.
-
I am not sure you can have two master detail setups in one form.
But you can replicate this functionality with views and controls. That is what I would do for your C D. Have a hidden section for the details in D and have a button that selects the current() row C data and then exposes the D data.
-
Welcome to the forum and the wonderful world of InfoPath.
You should be able to create a very good solution with InfoPath but the architecture is important.
If you would like to see some examples or discuss send me an email.
-
Hey Tal.
It sounds like you are familiar with the manager data stored in AD. You can get the manager's name real easy. In some cases I have stored the manager's alias as well in a custom field.
I do this query frequently with the Active Directory web service without any code or anything.
There are other methods of gaining access, using ...
-
If the user is getting the form saved but also and error then I would guess there is some work flow or maybe the secondary calculation that is causing the error since it appears the save is not the issue. You could create a custom security permission that might be a work around for this.
For the second, you have the issue of the template ...
-
Thanks for this bug report.
-
In IP 2007 you can take your data sources off-line. Which means it will do this caching for you.
Check it out and see if that is what you need.