Been reading the forums, learning a lot! But have not been able to figure out how to show a filtered view of records in a layout. I have a product table with a sale type field that can have either 'Software' or 'Hardware' for each product. I want to create two layouts, one showing only software and one showing hardware. A script to run a find to filter for only software when the user opens the layout works but when the user performs a find on the layout it undos the filter. Anyway to only show Software records in a layout? Sounds simple, can't wait to learn how to do this.

Welcome!

You have a few options:

1. Create a layout with a tab panel that has 2 tabs. In tab1, put a portal filtered by "Software" to your product table. In tab2, put a portal filtered by "Hardware" to your product table.

2. Create a list view, and put two buttons "hard-coded" with a Constrain. So, a user does a find and then clicks "HW Only", which constrains the found set to products of type Hardware. Likewise for Software.

1. Create a layout with a tab panel that has 2 tabs. In tab1, put a portal filtered by "Software" to your product table. In tab2, put a portal filtered by "Hardware" to your product table.

Well the entire problem arises when a found set is established, filtered portals knows nothing about the the found set. Eventthough one of the portal criterias might be a calc' field using a CF to aggregate the found set, will only fields where and if such an aggregation is scripted, actually change the found set shown in the portal.

So when it has to be scripted anyway could it just as well be the constrained set as you second suggestion. The big problem is that an urgent requirement is that navigation only are under script control ... the end user should be deprived the native navigation found in the status area.

--sd

Thanks, bcooney for providing 2 potential solutions. Apologize for the delay in responding as I am traveling currently. I think I will go with the 2nd solution and create two buttons to run scripts to constrain the found set.

Thanks again.

peeel

Remember, if you Constrain by Hardware, then try to Constrain by Software--you'll get no records.

Constrains are usually preceded by a Find.