I am using a fillable PDF form created using Adobe Live Cycle. Clicking a button on the PDF form, an XML file is created and emailed to the server. The server puts the file into a temporary directory and then when a user clicks the import button on a form in the DB, all XML files are imported and moved.
This works great for forms that are linked to a single table. But now I need to use subforms (an Invoice + InvoiceDetails kinda thing...). Problem is: I can't add records to the InvoiceDetails table (which is related to the Invoice table thru ID) because there is no InvoiceID to link the two. That is, new entries in Invoice table are autonumbered but not entries for the InvoiceDetails table.
Beyond making the ID field not autonumbered, any solutions? Any expertise in this area? I hope I explained this well enough- If clarification is needed please let me know...
CG
This works great for forms that are linked to a single table. But now I need to use subforms (an Invoice + InvoiceDetails kinda thing...). Problem is: I can't add records to the InvoiceDetails table (which is related to the Invoice table thru ID) because there is no InvoiceID to link the two. That is, new entries in Invoice table are autonumbered but not entries for the InvoiceDetails table.
Beyond making the ID field not autonumbered, any solutions? Any expertise in this area? I hope I explained this well enough- If clarification is needed please let me know...
CG
