import xml not a problem, setting key for subtables is

  • Thread starter Thread starter Jennifer Robertson
  • Start date Start date
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?
 
Back
Top