Info Path Form feeding a DB

S

Salemgrad

I am trying to create a form that has approximately 40 check boxes, names and
other info into a designated DB. I want the names & other info to be
selected from drop down boxes. The problem is I cannot figure out how to
have this data populate my DB. I only see how to associate a primary table
but the check boxes are not working. How do I distinguish the check boxes to
populate a certain field and the names populate another field using drop down?
 
S

Salemgrad

Is there a way to import an Access Form into Info Path? I have it in Access
but cannot get it to work in Info Path.
 
Z

zeon

To add a secondary database connection, to use as a reference for a drop-down
list box, do the following
Tools, Data connections - note there should already be a "Main connection"
defined
Select Add, and choose the radio button for "Receive data"
Choose the radio button for "Database (SQL Server)
Click on the "Select Database" button
Choose an existing data source, or create a new one, then click the Open
Button
Choose the table top be used as the input for the drop-down list box
Choose only those columns that are needed, for performance reasons
Take the default name, or enter a new one, verify the Summary section does
not show any errors or warnings
Click the Finish key, the new data source will now appear, so Close the
dialog
Now, this new Data Connection can be referenced when you click on the text
box and choose properties
Choose the radio button "Look up values in a data connection to a database
...." and follow the prompts
 
Top