Importing XML to multiple tables

[cbsteven]

Hey all,

I'm building a new solution from scratch. My first step is importing an XML file that contains multiple tables in the same file.

I have translated it to FMPXMLRESULT format with an XSLT. The problem I run into is trying to make the data go into multiple fields.

To test if it is even possible, I made a dirt-simple test database with 2 tables of 2 fields each, with the tables related, and exported to XML. The resulting file includes fields from both related tables.

When I reimported that same file back to the test DB, it still would only try to put the fields in one table.

Is this even possible to do?

[comment]

You can only import into one table at a time.

Note also that exporting related fields is not exactly the same as exporting from two tables.