Hiding records using a script

[lesley1160]

Please could someone tell me if it is possible to write a script to carry out this task?

I would like to hide multiple records if two separate fields in the records meet a specific criteria ( "No" in both fields).

I did manage to create a simple script but it only omitted one record at a time and it may involve omitting anything between ten and twenty records.

Many thanks in advance.

[-Queue-]

Why not create a calculation field of

field1 = "no" and field2 = "no"

Then you can either add a find request to omit records with a 1 in the field or only find records with a zero in it.

[wmugrad28]

What if I have a Customer table with a field called Status and the radio box options are Active or Inactive? My file has multiple tables and I would like be able to select a customer as inactive then have all records (from all tables) hidden or transfered to a seperate place. I don't want to delete them because we might need to go back to reference something... but on a typical day we don't want them to get in the way.

Greg

[-Queue-]

You may want to create a duplicate db and import all customers with a Status of 'inactive'. Otherwise, you'll need to add Status = 'active' criteria to your finds or run a loop to omit inactive records after your finds.