InfoPath Dev

OK, so after all of the posts regarding using the database acceslerator I have been trying to work with it. I am onclear on how to use my own custom form to connect back to a SQL database.

OK So starting from the begining...

General Tab:
1. I am able to add my form template
2. Able to add my data source... took me a bit to figure that out...
3. Reference ID Section ??? Not sure what I need to do here if anything
4. Indexes ??? Also not sure what I need to do here?

Permissions Tab:
1. have not really delt with this yet

Promoted Tab:
I am not using any sharepoint lists, so I do think I need to do this... am I wrong

Database Mapping:
1. I can see the following:

when using a repeating section I am not sure sure which node path to use in the TableName

Lastly, Should I be using the same web service as in the getting started document? if so what am I missing when I try to add the web service to my form, submit button, the only options I have to map are the datasources from the getting started document. what I am I missing?

Hi snyderjd,

 From the screenshot, it looks like you are trying to work with DAT from within a web browser.  This has never been tested and the form relies on several InfoPath-specific functions to render correctly.  After opening DAT in the InfoPath rich client you can click the '?' button to view a contextual help pane that will help.  Also, hovering over all of the titles to the fields will bring a tooltip explaining each field.

Everything in the Getting Started document should be enough to get things rolling, but feel free to post back with any more questions! I hope this helps!

OK, So at this point, I am lost with the whole DBXL etc... Is there any documentation that would assist in allowing me to use the database accelerator with a custom form that I have. As you stated in a previous post of mine, the work I am doing should be easly handled by the database accelerator...

 Also, I am opening DAT from a browser, but it by default opens the form in infopath

 Thanks very much!
Jason

Hey Jason, sorry you are having trouble.

InfoPath would be required for manipulating the DAT form and opening the template xsn via a browser should initiate InfoPath by default.

Can you explain what you are trying to accomplish with your form so we know what you are trying to accomplish.

I appologize for the documentation, I am going to be posting more this week.

If there is something specific you need please let me know.

Clay,

Thanks for the post. I will include a screen shot of the form I have created and using. This form is being used as a shift turnover form for our production support group. Currently I have the form coded to be sent in email and we save form on a SharePoint. The object is to continue with the email but to submit to a SQL Database, currently running SQL Server 2005. As we have long data types in the form, we first went the route of a web service, but had issue with repeating sections getting submitted to the database. We currently fill this form out for turn over and then turn around and have to fill out a separate report with the same information. Our goal is to be able to use a SQL DB to store all of this information to better allow us to streamline our reporting and stop redundant processes....

Here is a snap shot of a single issue with a single application issue. As you can see there are several repeating sections within repeating sections. I do hope the database accelerator is a tool we can use... if so we will look at implementing it with our other forms.

http://server6.pictiger.com/img/27413/other/form.jpg

It appears you have not been succesfull getting this form to submit via DBXL.

I think we should focus on that first.

Definitely your scenario of sharing information between the forms is viable.  You can submit the main form and through the dat update a table or two and then use that data while filling out the related form.

I will send you some additional tutorials.

Thanks Clay,  I will PM you with my email address..

Thanks again