Howdy, Stranger!

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

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

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.