XML and relational database mapping - Programmers Heaven

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

antonsantons Posts: 117Member
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.