Display Multiple Products from an Invoice

[MTG]

Hi All,

I'm working on a purchase order database with FM8. I have 3 tables (Product, Join & PO). When I create a summary report, only the first line of product from the PO is displayed. There could be multiple products in that PO. Do I need some kind of loop? Or a different layout?

Any help on that is greatly appreciated.

[Razumovsky]

Hi MTG, welcome.

It looks like you are trying to run the report from the PO context. You should do it from a Join table list layout and pull the data from the related PO into the header.

-Raz

[MTG]

Dear Raz,

Thank you so much for your quick response. It worked!