Query between info path forms and sharepoint

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ViPeRaY - 06 Jun 2007 19:19 GMT

Hi. Our company uses Sharepoint Server 2007. They want me to design a form
in infopath. Here is what they wants. A form with some fields. Adress, job
number, name, etc. and all this informations are already in a sharepoint web
site. There is a list contains information about customers. They want me to
design a form (i already designed it) and employee simple enter the job
number on form and press enter all the other informations like address,
name, phone number etc automaticly fill in the form. after that they will
print this form i could not make a connection between forms and shareponint.
how can i make a query with a form from sharepoint?
Thx

Reply to this Message

S.Y.M. Wong-A-Ton - 13 Jun 2007 08:22 GMT

If the job number is also present in the customer list and if it is unique,
you can create a (Retrieve) data connection to the SharePoint list, and then
create a rule on the job number field to fill the other fields using a filter
on the secondary data source. You can do something similar as what I did in
this article
http://enterprise-solutions.swits.net/infopath2003/article.php?t=autofill-fields
-dropdown-selection-secondary-data-source&c=infopath2003
but then substitute the drop-down list box with your job number field and
create a connection to your SharePoint list instead of to a database.
---
S.Y.M. Wong-A-Ton

> Hi. Our company uses Sharepoint Server 2007. They want me to design a form
> in infopath. Here is what they wants. A form with some fields. Adress, job
[quoted text clipped - 6 lines]
> how can i make a query with a form from sharepoint?
> Thx

Reply to this Message