Select Queries in IP

[Alex]

Hi All,

How do I connect to a db (this is ok) and pass a parameter
such as user login to bring up the details for that
particular employee from the db.???

Thanks....

 

[Jerry Thomas [MSFT]]

Design a form using "New from Data Connection...".
This will give you 2 copies of the db fields in your Data Source. One is for
creating a query and the other is for data to be displayed.

If you fill in "Name" and press Query, you should get that employee info
from the db.

--
Jerry Thomas
Microsoft Office InfoPath
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias. This alias is for
newsgroup purposes only.

 

[Guest]

Works great, Thanks!

-----Original Message-----
Design a form using "New from Data Connection...".
This will give you 2 copies of the db fields in your Data Source. One is for
creating a query and the other is for data to be displayed.

If you fill in "Name" and press Query, you should get that employee info
from the db.

--
Jerry Thomas
Microsoft Office InfoPath
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias. This alias is for
newsgroup purposes only.





.

 

[Alex]

Works great, Thanks!

-----Original Message-----
Design a form using "New from Data Connection...".
This will give you 2 copies of the db fields in your Data Source. One is for
creating a query and the other is for data to be displayed.

If you fill in "Name" and press Query, you should get that employee info
from the db.

--
Jerry Thomas
Microsoft Office InfoPath
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias. This alias is for
newsgroup purposes only.





.