Find Script

[tryphe]

I know I have done this before but it has been a while since I scripted anything and know I am going crazy trying to get this to work...here is what I am trying to do...

I want to write a script that will find me only records that have no date in a certain field...unapproved records. and I want it to omit all the ones that are cancelled. I have tried numerous ways but it keeps omitting records with the same name and member numbers even though they are different records or it doesn't find them all just some. Like it will only find 35 out of the 50 that are actually unapproved.

I had written it so that it would look at the unapproved field and omit any that were ifvalid because the ifempty function never seems to work right. The cancelled field is a checkbox and if it says yes I want it omitted. I only want the records that have nothing in the unapproved field but aren't cancelled...why can't I seem to be able to get a script to work!

And why does every script I have keep omitting records of the same name and member number (all the data I use is submitted to me from another filemaker database that I import into my database...could they be linking hte records? is there somewhere I can check for that?

Going crazy so any help I can get would be appreciated.

'''''''''''''''''''''''''''''''''''''''

[Ugo DI LUCA]

Hi,

Use a boolean Case calculation (0 or 1)

c_checkrecords = Case(Is Empty(unapproved ), Case(status "cancelled", 1,0),0)

As this calc isn't related to anykind of relationship, you can index the calc and use it at right side of a relationship.

Create a global field g_match (populated with 1)

CheckRecordsRelationship = g_match::c_checkrecords

The big long script here

If Is Valid (CheckRecordsRelationship::Record_ID)

----Go to related records (::CheckRecordsRelationship- show only)

----Go to layout (the one you want for the list)

Else

----Show Message ("there are no match for this find")

End If