title: Livecycle dynamic form with access data lookup?
body: <p>I've read a few tutorials and tips on how to setup a data connection (ODBC) between a livecycle (PDF) form and an Access database, but these are all limited to searching through the records (in the access database) one by one or returning all of them. What i'm trying to achieve is a lookup by searching on a staff id number and then returning all the other information in that row. If this at all possible or anyone has any advice then that would be great, otherwise it's back to the drawing board. </p>
  
  <p>Many thanks</p>
  
  <p>Mark W</p>