I currently testing Adobe LiveCycle to create a PDF form with data link to a database (Access).
The goal of my form is for the manager of each of our site to write variable about the paycheck of each employe. So first I create my AccessDatabase with a simple structure :
N : Auto Number
Matricule : Employe ID
Nom : Name
Prenom : First Name
Service : Service (Accounting...)
HeureMensuelBase : Contract hour information for the mouth
HeureSemBase : Contract hour information for the week
Mois : Mouth
Annee : Year
NbrHeureMensuelW : Write the number of hour the employe work this mouth
NbrHeureSupp25pc : Extra hour paid 25% more
NbrHeureSupp50pc : Extra hour paid 50% more
NbrHeureSupp100pc : Extra hour paid 100% more
NomPrime : Name of a special gratification
MontantPrime : Amount of a special gratification
So after, I create my ODBC connexion and insite AdobeLiveCycle, Data View, Create a connexion > Next > ODBC String connexion > SQL Request > SELECT * FROM Table_Access; > Next > Finish. Great I retreive all my fields. If I preview the PDF I can correctly see the first record of my database.
My goal is to create two differents buttons to navigate inside :
Could help me ? Adobe Support don't want help me because I use a trial version for the moment (logical because my CTO wan't valide LiveCycle do the job before paid for it). Sorry for my english it's not my mother tongue.