A greater overview:

Here is an overview of what I am trying to do:

TABLEA: ACORDICT.DBF
FIELDS:
formfield  c(175)  && field name on pdf form
profiler   c(30)   && our app's variable that stores the data
expression c(75)   && expression used instead of variable
caption    c(25)   && caption on form
helptext   m       && helptext on form

TABLEB: ACORDEFN.DBF
FIELDS:
form       c(20)   && form filename i.e. 61nc.pdf
field      c(175)  && link to formfield in acordict
order      n(4,0)  && order tag is to be placed in xml file 1->100

acordict is dictionary table that lists formfields on pdf forms and provides a cross-reference to the appropriate variable in our app that contains the data to fill the form field.

Here is an example of two records in acordict:

formfield         Profiler   Expression                        Caption       HelpText
INSURED.NAME      fr_name                                      Name          Enter Insured's Name
AGENCY.CITYSTZIP             ALLTRIM(AG_CITY)+", "+AG_STATE    City, ST ZIP

Acordefn is a table that lists the form and all of the form fields on the form. We step through the acordefn table and create an xml file based on the fieldnames listed for the form. The values for each field are determined by cross-referencing the formfield in the acordict table which contains the name of the variable in our app that stores the data.

Three example records in acordefn:

Form  Field            Order
61NC  INSURED.NAME       1
61NC  INSURED.ADDR1      2
61NC  INSURED.CITYSTZIP  3

We are building both tables manually right now since there are over 400 pdf files to create. As we create the fields on a pdf form, we decide which formfield to use to populate the field with data based on the variable or expression in our application associated with it in the acordict table. We then add the records (formfield) to the acordefn table that belong on the pdf form. In the acordefn example above, the three form fields would be on the pdf form.

Instead of manually copying/pasting formfields, I would like to drag and drop the field contents from the acordict table to the acordefn table and add a record for each one. I would have to enter the other two fields of course (form and order). I was thinking of dragging and dropping or maybe doing something like the moverlist class example in VFP8 solutions. The only problem is that there are over 5000 records in the acordict table so it is too large to populate a listbox with for the source listbox if I do it that way. However, when a field is added to the destination listbox on the right, the order in the listbox could determine the order field value easily. I could also have textbox to fill in the form name to populate the form field in the destination table.

Open to any better ideas!

Tracy