Excluding records

[Opieos]

Hello gang:

I'm looking to acheive the following and would appreciate any suggestions.

My current database has a main screen which shows all current years records. When a record is completed it is labeled as closed (check box being checked) and or a field with a drop down box which has closed, pending etc listed).

I am looking to be able to exclude or hide all closed records from the main screen when the database is opened. Not sure how to accomplish this.

Bryan

[mr_vodka]

My current database has a main screen which shows all current years records.

Not 100% sure what your setup is here. Are you using a portal or just showing the actual records.

If its a regular set of records and it is already only showing only the current years records, then there is already a script that has some kind of find criteria as part of the opening script.

So you can modify it to something like:

Enter Find Mode []

Set Field [ YourDate; Date ( 1; 1; Year ( Get ( CurrentDate ) - 1 )

New Record / Request

Set Field [ Status; "Closed" ]

Omit Record []

Perform Find []

[Opieos]

John:

Thank you for the reply that works they way I'm looking.

Out of curiosity how or what would I add to exclude additional records by status (example we have records that are closed, unfound, pending) I have the script set now to exclude closed how can I also exclude unfound at the same time?

Thank you

Opieos

[mr_vodka]

Just add before your perform find.

New Record / Request

Set Field [ Status; "unfound" ]

Omit Record []