Trouble with script to get a found set

[gaby78]

Hello:

I have a standard Invoicing DB with Customers-Invoice-InvoiceDetails-Products tables

I am on Invoice layout with InvoiceDetail portal. What script do I need to get the following result: when I click on a line item (say, product P1255) in the portal I want FM to show all the instances where this customer purchased product P1255. I can manually go to InvoiceDetail enter find mode, type in customer Id and product Id and get the desired found set. But I am having trouble in a script getting the customer id and product id over to the InvDetail layout starting from the Invoice layout.

Any suggestion will be much appreciated.

[Ender]

Try this:

Go to Related Record [ Product ; Some Product Layout ]

Go to Related Record [ Show only related records ; Invoice ; Some Invoice Layout ]

[gaby78]

It works.

Thanks Ender, much appreciated.