Saving info pulled from a database

[Artunc]

Hi,
I created a form that pulls employee names from a database table I have.
I can fill in the form, choose a name from the list and save it to my local
drive.
When I open the form again, the name goes back to first user in that table.

How can I preserve the name I choose in a drop-down box after I save a form?

Thank you in advance.

 

[Artunc]

I found the answer, below is how in case anyone other beginners will wonder.


Insert a Drop-Down List Box control bound to the main data source:

From the Data Source task pane, select Main from the Data Source drop-down
list.
Select the data node you want the value to be stored in, right-drag it into
the view, and then release in the location where you want the control placed.
From the context menu that appears when you release the right-drag, select
Drop-Down List Box.


Populate the Drop-Down List Box from a secondary data source:

Double-click the Drop-Down List Box control.
In the Drop-Down List Box Properties dialog box select Look Up Values In A
Data Connection.
Choose the secondary data source from the Data Connection drop-down list.
Click the Select XPath button to the right of the Entries field.
Select the node that will be used to populate the values, and then click OK.
If necessary, use the Select XPath buttons to the right of the Value and
Display Name fields to make appropriate node changes.
Click OK to close the dialog box.