TIA,

To make your scenario work, you need to:
- create a data connection to the Employee database (SQL/Access) to get
the information for all employees
- insert an EmployeeID text box into your form
- insert a button to run a query to populate employee details
- insert form fields that will be populated with details that come from
the database.

You can use default values on read-only fields to populate calculated
fields.

If you are concerned about performance, you can write script to launch a
dynamic query on button click (you would be generating a "WHERE" part of
the SQL statement dynamically, thus, less data will travel through the
wire).

Good luck!
Alex @ Microsoft

-----Original Message-----
From: Vai2000 [mailto:nospam@microsoft.com]
Posted At: Tuesday, May 03, 2005 7:18 AM
Posted To: microsoft.public.infopath
Conversation: How to?
Subject: How to?

Hi All, I was wondering how can I automate InfoPath? I need to give user
the
flexibility of creating invoices with single click...basically all the
employee info should get populated from a data source (SQL/Access....)
as
soon as the user enters the EmployeeID. The invoice should populate all
fields with calculations etc...and ready to be faxed.

TIA