InfoPath as front end to database

[shepherdess]

I am new to InfoPath and thought it might solve a problem our company has. We
need a quick way to complete an invoice form (established by the corporate
office and cannot be varied) which I have been able to replicate in InfoPath
2003--no problem with that. I have set it up with my database of invoice
information and the InfoPath form can be used to enter information into the
database, and when I fill it with sample data, it looks great. However, I am
missing something basic here---How do I get the InfoPath form to fill
AUTOMATICALLY from a record in my database??? Am I trying to make it do
something that is impossible for it to do?

Thanks in advance for any help.

Shepherdess

 

[K.Ramana Reddy(GGK Tech)]

Hi,

You want to fill data when the form is opening, take the data connection to
the db and query and fill the data in Onload event.

I hope this will help for you.

 

[Kalyan G Reddy MVP (GGK Tech)]

Hello

Use a button and write code to Querry the Db on OnClick Event to get the
data into the Infopath form automatically

 

[shepherdess]

Yes. This helps. Thank you so much for your reply.

Shepherdess

 

[Kalyan G Reddy MVP (GGK Tech)]

Glad that it helped you.