Filtered portal with "Show All" option

[Mandu]

I'm using a portal on an invoice layout to show the inventory items and their stock codes. The portal is set up to be filtered by matching strings: if you type a search string into a custom dialog and click search, it does a find, and puts the record id's of the found set into a global field as a new-line-separated list. The portal relationship is simply between the global field and the inventory table. Works great.

I want to add another button besides "Search" : "Show All". I know how to make it execute a find that finds everything in the inventory and then shows it in the portal, but it's about a 5-second process to create the record id list. Is there any neat trick to make this portal behave like an unfiltered, Cartesian relationship with Inventory?

(I'll create and cache the entire record id list if need be, with all the attendant problems of keeping it coherent, but I'm wondering if there's a much easier way.)

Thanks,

Chap

[Raybaudi]

Hi

see if this file gives you some idea

Inventory.zip

[Mandu]

Yes, that makes perfect sense, and I would never have thought of that. Thanks, Daniele!

Chap