|
|
I'm surprised I got this far LOL
Ok. I made an acrobat PDF form from a schema from Access. One big table and multiple sub-tables. I was able to get the PDF form to export the xml properly. I can import the single xml file back into access into multiple tables.
Here's the problem:
A new record into the main table generates a PermitID (primary key, autonumber).
I want to know how to assign this value to PermitID (foreign key) field in each of the subtables. Can this be done on the fly?
|
|
|