I have a data drop down list connected through a local ODBC connection to an Access database.
How do I get other fields to populate when a user makes a selection from the data drop down?
The user makes a selection then other data from other columns from the same row in the Access table then need to populate in various pdf fields.
if i bind other cells then they default to the option in the first row of the database.
the only thing i can get to work so far is the first data drop down list. in the object under list items I then have it bound to the access column of interest.
the next problem is to have row data from the selection to populate elsewhere.
Retrieving data ...