Group:  Microsoft Access ยป microsoft.public.access.externaldata
Thread: import xml not a problem, setting key for subtables is

import xml not a problem, setting key for subtables is
"Jennifer Robertson" <robertjv[ at ]mcmaster.ca> 12/27/2008 6:30:20 AM
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?


Home | Search | Terms | Imprint
Newsgroups Reader