- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
I'm using Acrobat 9.1.2 and LiveCycle Designer ES ver. 8.2.1x.
I have an MS Access database populated with names/info regarding various people (Customers). I'm trying to create/generate separate (Order) forms, one for each Customer, each pre-populated with the Customer's contact information from the database. I want to e-mail each customized form to each Customer.
Each Customer should be able to change/correct inaccurate Customer information on the form (set control "Type" to "Calculated - User can override"?).
Each form will also have a table containing various "Products" (not connected to the database) and drop-down list controls from which each Customer can select the number/quantity of each Product he/she wants to order. Price extensions, subtotals, and totals are all calculated using FormCalc.
The Customer will then be able to both "Submit by e-mail," and "Print" and return the form by mail with his/her payment. I will then collect/assemble the returned .xml files and import them into the MS Access database myself.
Where I'm hung up is when I connect the Order form to the database, only one form is created, and only data from the first record appears in it. How do I create one form for each Customer from the database?
You can e-mail me at bryancapps@cfl.rr.com.
Views
Replies
Total Likes