1 Reply Latest reply on Nov 12, 2009 7:44 AM by StellaLuna

    Related tables Export Problem



      Related tables Export Problem


      A problem I have I can't get solved.


      In the database I have a table Orders which is related with a table Orderitems. They are related with  "ID Order" .

      In Filemaker it's no problem to view the orderitems in a portal. But what I have to get is an export to Excel in the next structure:


      ID Order - Item 1 - Item 2 - Item 3

         001      -  A       -    B      -    C

         002      -  D       -    W     -    I

         003      -  y        -    q     -    R

      What I've tried is to make the same Fields as in "Orderitems" into the "Order" Table and import  the data in the fields "Order". But I can't believer there isn't a easier solution.
      Thank you for helping me! 

        • 1. Re: Related tables Export Problem

          Well, you can use Substitute(List(OrderItems::Item);¶;", " ) but the related items wouldn't appear in excel columns (only one large column).  I would think that you want to export from the OrderItems table so your excel would be:


          Item# - ItemPrice - Qty- ID Order

            A           3.25         3      001

            B            9.21        12     001

            R             .85          1     002


          You can then subtotal in excel and even turn it into a pivot table.  Oh, and you can include any related Order fields directly in the export as well.