Yes, you can easily use InfoPath with databases. To make the database the
main data source for your form, click "design a form" and then choose "New
from data connection". Choose "database" in the next screen of the wizard,
and then walk through the wizard. You can both query and submit data from
the database using a database as your main data connection.
If you simply want to draw your drop-down field values from a database
table, open the data connections dialog ("Tools-->Data Connections"), and
then click "add". Add a connection to receive data, choose "database", and
step through the wizard to select your data.
Once you have defined the data connection, double-click on the drop-down
listbox you want to populate with the data, and choose "look up values in a
data connection...". You can then select the data connection you just
added, and select the columns to use for the display name and value of the
dropdown.
Note that InfoPath only supports Access and SQL Server databases using this
method. In order to use another database, you should create a web service
to access the data, and connect to the Web Service instead.
Best luck!
--
Nick Dallett
Program Manager, Microsoft Office InfoPath
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm. Please do not send email
directly to this address. This address is for newsgroup purposes only.
"Bill of Materials Creation?" <Bill of Materials
[email protected]> wrote in message
news:
[email protected]...
