creating a form that pulls specific information

[Carolyn]

I am having a very difficult time trying to create a simple form in Infopath.
I am just creating a form letter, but I would like to pull the customer info
in to a few lines. I would like to type the customer number and the fields
fill out accordingly. I have done this, however, the info only fills out for
the first customer in the database. I do not want the info repeated as I do
not want this on the form.

Can you help?

 

[Fernando]

Try this link.

http://groups.google.com/group/micr...ead/thread/3eac3d1470eb5127/b8c6d0e40e5ab032?

 

[Carolyn]

Try this link.

http://groups.google.com/group/micr...ead/thread/3eac3d1470eb5127/b8c6d0e40e5ab032?

"Carolyn" wrote: Right now, my script reads: select "Vendor_Code","Vendor_Name","Address_1","Address_2","Address_3","State","Zip_Code" from "dbo"."VN_VENDOR_MASTER" as "VN_VENDOR_MASTER"

I want the information pulled from the vendor code that I enter. It is not
doing this. When I enter a Where clause, I get error messages.