import xml not a problem, setting key for subtables is

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access Subtables information 0
Importing XML Data in Access 2003 1
changing the name of a table created by importing an XML document 1
Importing Project 2007 XML data into Access 2007 0
How do I import xml file into MS Access table 1
I want to load data from excel to access using xml 11
Import of XML schema (XSD) crashes MS Access 0
Importing a XML Infopath form into Access 1

Top