I have a PDF document that has many form fields to be filled out. Currently users fill them out by hand, but I would like to make it possible for them to pre-fill the values based on a database search. In a nutshell, I want them to be able to search the database for a desired account record. Once they find the account record they are looking for and select it, I want the PDF to retrieve all of the data from the database and pre-populate the fields on the form with this data.
I am running Windows environment with SQL Server.
What is the easiest way to get this done? I already have a copy of Acrobat Standard 2009. Commercial or open source software is ok.