Howdy, Stranger!

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


XML and relational database mapping

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

<?xml version="1.0"?>

Enterprise Development



Foundation Services


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.??
Sign In or Register to comment.