Help needed with invoice report
I have just made an invoicing system,
with following tables.
customers, products, orders, orderlineitems
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.
Select * From Orders Where orderID_PK
loop through results and print order line items
Hope someone can shed some light on this