Can it be done ....yes. Are your users using Acrobat or Reader as their PDF viewer? If it is Reader then you will have to Reader Extend the form to allow this to happen (this data connectivity is not part of standard Reader). Also you will have to create a DSN on the users machine to make the connection between the OS and the database. Then you will have to write code to extract the specific record that you want. There are samples that show how to do this ....but without dealing with the 1st two things you are not going to get anywhere.
Thank you for your help.
The users will use Acrobat because they will also be able to append signature to their forms. I did find a sample which was based on LiveCycle 7.00 but it did not work and I could not find anything wrong when I tried debugging.
Can you provide me with links to some other samples if you have any? I will highly appreciate.
D N Sakwa
Here are some good blog entries
I also did a tech talk for the Acrobat Users Group where we talked about Database connectivity. Here is a link to that webinar for the replay