InfoPath and SQL Database (beginner)

Last post 03-10-2008 08:41 AM by Stefan. 2 replies.

Page 1 of 1 (3 items)
	Sort Posts: Previous Next

03-10-2008 02:26 AM

Stefan
Joined on 03-10-2008
Posts 3

InfoPath and SQL Database (beginner)

Reply Contact

Hello

I’am from Germany, so pelease excuse my english. I stand on the beginging of my InfoPath study. The job I have is to build a database for our books. So everybody can inform where some book is right now. So I created a database on sql Server with a table for the books. Now I have to make 2 InfoPath forms, one is to fill the database and one is to inform (search for a book). In the first form can the user put in the information about the book (author, title,… ) and the form send the information to store it on the database. The second form is to get the information about the book. The user gives the title in the form and the form gets the specific information of the book from the database and fills it automatically. The form run on a SharePoint Server 2007. Can you help me to make the connection from an InfoPath form to the database? Maybe someone of you have a small How-to. Thanks for your help. Greetings

Stefan

03-10-2008 08:11 AM In reply to

Clay Fox
Joined on 06-27-2006
USA
Posts 1,935

Re: InfoPath and SQL Database (beginner)

Mark as Not Answer Mark as Answer ...

Reply Contact

Welcome Stefan.

I think you would want just one form but with two views within it. One for the search and one for the lookup detail result.

I would suggest you look at using web services to interact with your SQL data, if this will be an enterprise solution.

If you want to send me an email I can show you a couple examples of similar forms.

Clay Fox / Microsoft InfoPath MVP

03-10-2008 08:41 AM In reply to

Stefan
Joined on 03-10-2008
Posts 3

Re: InfoPath and SQL Database (beginner)

Mark as Not Answer Mark as Answer ...

Reply Contact

Hello Clay

Thank you for your help and your greetings. I wrote an email to you

greetings

Stefan

Page 1 of 1 (3 items)

InfoPath Dev