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