These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Lookup data from Access and Autopopulate

Forum Index > Forms: LiveCycle Designer > Lookup data from Access and Autopopulate
2010-05-18 08:36:46
KaarthikRam
Registered: May 18 2010
Posts: 2

Hi, Im working with Forms in Livecycle Designer v8 and Im quite a novice.

I have established a small DB with information about WCode and and WCode Description.
In the forms, I have a dropdown to select Wcode and there is a textfield next to it indicating description, which I need to auto-populate to the corresponding WorkCode selected from the table in the database.

I have establised the usual OLEDB 'DataConnection' pointing to the table in the Access database.
I have tried using SQL statements, but Im unable to populate the textfield (NOT user-entered) automatically.

Can anybody please help me on how this is done in Livecycle? Maybe I need a script in the 'change' Script Editor window?

Regards,

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*

Top
2010-05-20 18:17:42
#1
krm240
Registered: Apr 17 2009
Posts: 95
Did you check out the following:
Tech Talk: Database Connected Forms
Date: March 23, 2010
Join Paul Guerette as he discusses how to connect your LiveCycle Designer Form to a database

this should help you get going.

I found out is that you need to use 32 bit ODBC connections, so if you are running 64 bit vista or Win 7, the std ODBC drivers are no good. Search for this and U will find some threads.
Top