Not without using a portal or importing the records into a separate table.....
I think you are using a script trigger to constrain the found set. That would seem a reasonable option. What do you mean by "reset"? There are simple ways to disable the constrain so that you can leave the layout and return without the record set being modfied by the trigger's script. Here's how I set up my layout based script trigger controlled scripts so that I can turn them off when necessary:
If [ Not $$TriggersOff ]
#Put script steps here
That way, If I need another script to execute without tripping such script triggers, is use this code:
Set Variable [$$TriggersOff ; value: True ]
#Put stepts here that would trip the script trigger
Set variable [$$TriggersOff ; value: False ]
Hmm, just thought of something a bit less drastic than importing the data into its own table. I'm not convinced that you need to, but...
Define a table with just two fields: ProductID, Current
Make Current a calculation field that always returns the same value entered in your check box field in Products to mark a product as currently sold.
Define this relationship:
CurrentProducts::ProductID = Products::ProductID AND
CurrentProducts::Current = Products::CheckBoxField
If you base your layout on CurrentProducts, you can add fields from Products and you'll only see records for products currently offered for sale. You can set up a script trigger on the check box field to create or delete the matching CurrentProducts record any time a user clicks that check box field to change the status for a Products record.
I took the 2nd route but it's not working.
I created a new table in orders that shows product id : Text and current status : Calculation to show "open"
Then i created a new table relationship between the new table and my products table relating product id and hte current status on both tables.
All of my products are still pulling over.
I can't seem to get it to limit the records shown to only open items.
In layout setup, does your layout refer to the new table or your original products table? "Show Records From" should specify the new table.
How did you populate the new table? (to get things started, I'd perform a find for all "open" products on the products table then import from it into the new table.)