creating a form that pulls specific information

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carolyn - 22 Jun 2007 20:55 GMT

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?

Reply to this Message

Fernando - 23 Jun 2007 05:07 GMT

Try this link.

http://groups.google.com/group/microsoft.public.infopath/browse_thread/thread/3e
ac3d1470eb5127/b8c6d0e40e5ab032?

> 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
[quoted text clipped - 4 lines]
>
> Can you help?

Reply to this Message

Carolyn - 25 Jun 2007 15:59 GMT

> Try this link.
>
> http://groups.google.com/group/microsoft.public.infopath/browse_thread/thread/3e
ac3d1470eb5127/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.

> > 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
[quoted text clipped - 4 lines]
> >
> > Can you help?

Reply to this Message

Rate this thread: