XML Import of one record to several tables

January 4, 200521 yr

Newbies

Is there a way to take a import a record via xml and have FileMaker put it into multiple tables. For example, a customer order might look like this (I'm just typing this in and the code itslef isn't perfect, but I hope it get's my problem across):


<METADATA>

<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="orderID" TYPE="NUMBER"/>

<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="customer_ID" TYPE="NUMBER"/>

<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="FirstName" TYPE="TEXT"/>

<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="LastName" TYPE="TEXT"/>

<FIELD EMPTYOK="YES" MAXREPEAT="10" NAME="Items::ItemID" TYPE="NUMBER"/>  

</METADATA>

<RESULTSET FOUND="1">

<ROW>

<COL><DATA>1001</DATA></COL>

<COL><DATA>2222</DATA></COL>

<COL><DATA>John</DATA></COL>

<COL><DATA>Smith</DATA></COL>

<COL>

<DATA>OrderdItem1</DATA>

<DATA>OrderdItem2</DATA>

<DATA>OrderdItem3</DATA>

<DATA>OrderdItem4</DATA>

</COL>

</ROW>

</RESULTSET>

I'd like the customer information to go into the customer table and the Ordered items to go into the Items table (with orderID number of course).

Is this doable?

thanks,

baze