Solved

Front end is Infopath and Backend is SQL Server 2005

Posted on 2009-04-14
1
460 Views
Last Modified: 2012-05-06
Dear EE,
I want to create an infopath which uses SQL Server 2005 as a backend Database.
I have a Table which has Customer Name and CustomerID columns.
Customer ID is a dropdown and Customer name is a text field.
On selecting a perticular CustomerID from the dropdown the respective Customer name should get populated dynamically in the customername textbox from the database.
This infopath form is published on a sharepoint site and is browser enabled.
I'm using infopath 207

Thanks in advance
0
Comment
Question by:agcps
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 43

Accepted Solution

by:
zephyr_hex (Megan) earned 500 total points
ID: 24152579
this article contains a link that will walk you through the process:
http://seiumoss.wordpress.com/2008/04/29/a-great-walkthrough-for-connecting-infopath-to-sql-server/
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question