Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

XML and relational database mapping

Hi
I'm very new to XML, and have the following question.
I have XML file like this:

<?xml version="1.0"?>


Enterprise Development

Jeff


Mike
>


Foundation Services

Sam




There is a one to many relationship between 'Department' and 'Employee'. When I import this file into Access DB, it creates the two tables with the data in it, but it does not seem to know there is such a relationship between the two tables. The schema is inferred.
How do I fix this.?? Do I include the primary key of the Department in both the Department and the Employee, and then manually set up the relationship in Access, or is there a more 'correct' solution.??
Thanks
Anton
Sign In or Register to comment.