Hi,

Can anyone please help me?

I'm trying to create a report in filemaker 8.5, from an invoice, showing all
related products and performed services.

I have 3 tables:

"invoice" table with fields...
- invoice id
- invoice name

"products" table with fields...
- products id
- invoice id
....

"services table with fields...
- service id
- invoice id
....


Does anyone know how to set this report up?

Thanks

In article <ryYKn.199$Hs6.138 (AT) newsfe15 (DOT) ams2>, "John Devlon"
<johndevlon (AT) hotmail (DOT) com> wrote:

You'll need a new "Report" table (or do the same in the Invoice Table)
that pulls the related data from the other Tables into a format usable for
your report using a Script and some Global Text Fields.

For on-screen use you can use Portals, but they aren't designed for print
purposes.


Helpfull Harry )