i need a script that will find and omit records with one or the other of two values in a value list.

attached is a screen shot of what i have now. i hope someone can point me in the right direction to debugging it.

thanks

deanna

Use a New Record Request for the Omit

There are two basic finds in Filemaker, [color:blue]AND and [color:blue]OR

[color:blue]Simple find.

Enter Find Mode:

Find X in Field 1

will find all records with X in Field 1

[color:blue]AND Find

Enter Find Mode

Find X in Field 1 AND Y in Field 2

will find all records that contain X in Field 1, and Y in Field 2

[color:blue]OR find

Enter Find Mode

Find X in Field 1

New Record Request

Find Y in Field 2

will find all records with X in Field 1, or with Y in Field 2

[color:blue]OMIT Find

Enter Find Mode

Find X in Field 1 (Select the Checkbox Omit)

will find all records where X [color:blue]isn't in Field 1

[color:blue]Multiple with Omit

Enter Find Mode

Find X in Field 1

New Record Request

Find Y in Field 2 OMIT

will find all records that contain X in Field 1, minus any of them that have Y in Field 2

HTH

Lee

Edited May 14, 200817 yr by Guest

that wasn't quite what i wanted. i tried to adapt the multiple with omit steps you gave me, but it still didn't work.

i don't know if this makes a difference, but the two values i want to omit records with are both the same variable. there is a list of values for the field "status" and there are two values in the list that i want to omit the record for if they correspond.

additionally, you may have seen that there are some other steps to the script to set up the final layout. when i go to that loop, is it going back to the full list? is there something i have to do to make sure it's manipulating the found set? or should i do the find/omit after i've done the loop?

thanks

deanna

Edited May 16, 200817 yr by Guest

My first thought was for you to attach a copy of your File.

But, before you do, let me see if this is what you are asking?

One Field

Several records with different variables of the same criteria that you want to Omit from the Found Set?

If so, each variable will need to have it's own Find Request.

i.e.

Enter Find Mode

enter variable ONE

New Record Requests

enter variable TWO

New Record Request

enter variable THREE

You can either OMIT these requests, or after the Find, SHOW OMITTED ONLY

HTH

Lee

the records i want to omit have the value of either "Former Member" or "Charter (NR)" in the status field.

i've tried to do it with a separate request for each value, but still no success.

here's the file attached as you requested. the script that this issue concerns is web directory.

thanks

GLCC_database.zip

Edited May 17, 200817 yr by Guest

Works for me?

Go to the Member Form View

Enter Find Mode

In the Status Field Select

Charter (NR)

Check the box for Omit

New Record Request

In the Status Field Select

Former Member

Check the Box for Omit

Perform Find

What is left, is the other members.

HTH

Lee

GLCC_member_database1.fp7.zip

Edited May 17, 200817 yr by Guest
your file with script

that works for me too. i guess i mostly had the syntax for the finds incorrect.

thanks so much for your help

deanna