Dynamic Secondary Data source?

[kb at donovanhill]

Hi,

I have an InfoPath 2007 form that collects contacts from a SharePoint
services site,
is it at all possible to programmatically change this secondary data source
to another contacts list on a different WSS site when the form opens?

Any help would be great.

Thanks

 

[Clay Fox]

Hey KB.

There is not a way to dynamically change this. It is embedded in the form
and the form can be cracked opened and changed and recompiled, this is not
something that you would do each time it was opened. You would need to create
the possible data connections and then use rules to identify the user and
then select the data connection and query that particular one.

Do you use Active Directory to get the form user's identity and query theirs
and others contact information kept in the AD?

 

[kb at donovanhill]

Hi Clay,

Thanks for your reply, that answers the question, although it's not what I
wanted to here. I use Qdabra AD web service for user details etc, but what I
am looking for in this case is project based contacts, such as clients,
consultants etc, which is stored in WSS contact list which varies for each
project, these would not go into AD.

Kevin.

 

[Clay Fox]

Hey Kevin.

I understand now.

Have you seen our Project Management system? We keep all of that
information in SQL tables and then can query it via web services as you
describe.

If you would like to see a demo let me know.