Hide record ability

[RodM]

Hi

I have a inventory file... and as thing fill up.. or sold and not used... wondering if there is a way to tag & hide the record from view... or my Nav key looking through inventory.. Then later i suppose I purge hidden records to archive..

Thanks

[efen]

If you're viewing the inventory table on a layout based on another table through a portal with a cartesian [x] relationship you can add an extra condition to that relationship via a field that can have, say an "x" or "1" added if the record is not to show.

So the relationship will be

key [x] key

and markfield [does not equal] markfield

[redgeorge]

Hi, how can I hide the record? is there a special record property? I have table that holds season trips every year I need to archive this old trips and i was thinking on putting a flag like you said, but how can i filter and just show the ones that arent archived?

Thanks in advanced

[bcooney]

If you archive a record, that means you are moving the data from one table to another. Therefore, you have no need to "hide," the record is no longer in the table (it's in an archive table).

"Hiding" can be done with a Find. For example, if you have a field flag_Active, you can Find for all records where flag_Active=1. That'll "hide" all inactive records.

You can attach this script in a navigation script, an OnLayoutLoad script trigger or just a button at the top of a list view "Hide Inactive."

If you use a portal, you would include, as efen describes, a second predicate to the relationship.

[redgeorge]

Thanks so much for your quick answer, It worked great using the onlayoutload event