Avatar

Level 2

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.