3 Replies Latest reply on Dec 19, 2011 10:39 PM by ChrisDavidsen

    Help needed with invoice report

    ChrisDavidsen

      Title

      Help needed with invoice report

      Post

      Hi

      I have just made an invoicing system,

      with following tables.

      customers, products, orders, orderlineitems

       

      Relationships:

      customers:custID_PK -> orders:custID_FK

      orderlineitems:orderID_FK -> orders:orderID_PK

      orderlineitems:prodID_FK -> products:prodID_PK


      The Orders form has a few fields for customer info, and a portal 

      showing order line items.

       

      I need to create a "Print friendly" report with a complete listing of

      the related order line items, printing the Order form with portal

      does only print visible order line items.

       

      I'm fairly new to Filemaker and i have no clue how to do it.

       

      I come from MySQL/PHP, and i would do something like...

      Header: OrderID_PK, customer info, invoice date ect.

      body:

      Select * From Orders Where orderID_PK

      loop through results and print order line items

      footer:

       

      Hope someone can shed some light on this

       

      Thx

       

      Chris D.