AnsweredAssumed Answered

Help needed with invoice report

Question asked by ChrisDavidsen on Dec 19, 2011
Latest reply on Dec 19, 2011 by 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.

Outcomes