Support Forum

Hi All,

I have a top page called 'Customers' and a sub page called 'Orders'. On the page Customers I have a table which contains all customers in the 'Customers.xml' XML file. The orders page contains a table with all the orders in the 'orders.xml' XML file. When you click on a customer in the table you go to the orders page. As you can imagine I only want the orders of that specific customer to be shown. I just can't seem to get it right using the subpage data mapping dialog screen.

Both files contain the field 'Customer_obj' which is the unique ID for a customer.

Below you see the structure of both files.

Any help is welcome!

Customer XML:
<?xml version="1.0"?>
<ttCustomer xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<ttCustomerRow>
<_iLine>2</_iLine>
<_Company_obj>19538094.029</_Company_obj>
<_RecordValue/>
<Customer-sbm_Customer>0x00000000000b6e44</Customer-sbm_Customer>
<CustAddressCity>Oslo</CustAddressCity>
<CustAddrHouseNr>10</CustAddrHouseNr>
<CustAddrHouseNrExt/>
<CustAddrName>Norsk Fashion</CustAddrName>
<CustAddrNameExtra/>
<CustAddrStreet>Gamler Gade</CustAddrStreet>
<CustAddrZipCode>1000</CustAddrZipCode>
<CustCountryDescr>Norway</CustCountryDescr>
<CustEmail/>
<CustPhone/>
<CustomerCode>10000</CustomerCode>
<Customer_obj>20679145.029</Customer_obj>
</ttCustomerRow>

Order XML
<?xml version="1.0"?>
<ttOrderLine xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<ttOrderLineRow>
<_iLine>1</_iLine>
<_Company_obj>19538094.029</_Company_obj>
<_RecordValue/>
<OrderLine-sbt_OrderLine>0x000000000003e3b2</OrderLine-sbt_OrderLine>
<Customer_obj>21600619.029</Customer_obj>
<OrderDate>2015-04-03</OrderDate>
<OrderNr>561</OrderNr>
<OrderedAmt>49.38</OrderedAmt>
<OrderLine_obj>24622590.029</OrderLine_obj>
<CurrencyIsoCode>EUR</CurrencyIsoCode>
</ttOrderLineRow>

Thanks! It works perfect!