I am not an expert with XML, so please bare with me here. I have an XML document that has data exported from a program.
It is relational database that has been normalized and then exported. Once it gets exported to the XML file however, it gets stored in a hierarchical fashion so that child tables get stored as tags within the parent tags. At the same time, the foreign key field in the child table gets removed.
For example, we have a table called CUSTOMER and another called ORDER. The primary key field in CUSTOMER is ‘Customer_ID’ and this is the foreign key in ORDER that links the 2 tables. 1 customer can have many orders, but an order can only have 1 customer. When the XML document gets created, it removes the Customer_ID field from ORDER and just indents ORDER within CUSTOMER (like an outline).
This data becomes useless when imported into Access or any other program because we don’t get the Customer_ID field in ORDER.
In the XML document, how can we get that Customer_ID field to propagate down to each child ORDER record and unindent it? If there’s a software package we need, please let us know. Thank you.