-
So you are creating a survey or questionaire and you want to have it dynamic by getting the questions from a DB via a web service. This may be more work than just updating your questionaire form every so often.
A web service is a data connection so you it to query on load or have a button action initiate the query. Then you ...
-
I am not the expert with it but I use it on a regular basis.
Can you describe exactly what data fields in AD you are trying to get?
What connection string you are using. Is it in the same domain? Are you using LDAP or the Global Catalog?
Which of the methods for the web service are you using?
-
Welcome.
You are experiencing what many of us have, in creating intricate, enterprise solutions as database forms to Access data. The limitations in InfoPath database forms will catch up with you eventually.
I would recomend you download the Database Accelerator Web Service Suite.Qdabra Database Accelerator Suite Version 2.0 - DeveloperIt ...
-
hey Rajeev.
If you are just passing user/login ID it would probably be easier justt to use a Active Directory web service like you can download off the site. How I have done it in the past is using one form to launch the other form and passing the parameters between the forms. Other methods would be to put the data into a table or xml ...
-
Welcome.
So you have a database form? Set up to query and submit to your access table?
You should be able to populate multiple query fields before you initiate the query and they will be used in the query. You can have your dropdowns have rules to set the query fields with their values then have a button or on the second drop down initiate ...
-
Yah that is what i am thinking that it is the relationship. You need to have a primary key on each table and then you need a foreign key field which links each record in your secondary tables to a row in your primary tables. When you configure your form, you add the primary table and then use the add table button to add additional ...
-
Hey Stanton,
Welcome to the forum.
I have done similar solutions.
You cannot query a secondary data connection other than load all information. Then you have to use filtering to extract just the data you want. So maybe you would say date where holiday name = "New Years" for example. This would return the date from the ...
-
Is this your main data connection or a secondary? Are you just reading data or submiting as well?
Was your form created as a Database form?
Sometimes this can occur from how your tables are set up and related properly.
Have you checked out the Database Accelerator WebServices Suite? If you are going to be working with ...
-
I am confident it is not possible. You can create a new form library but not a completely new site. You have to configure that before hand. I think mostly the functionality is this way since it would not be very common and there is a lot of information SharePoint wants when a new site is created.
There may be some way of ...
-
What you need to do for your scenario is either identify the user or the status of the form.
If you use DBXL or another method to get the Username of the user and the group, etc you could have the form check the username and act accordingly. Otherwise you could have a field to keep track of the state of the form and either have each user ...