J
Jennifer Robertson
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?
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?