I have a db that has names, comments and a status for each. Looking to run a script that will ommit the records that do not have any info in the comments or status fields.

help would be great

FileMaker Version: 5

Platform: Windows 95/98

Good morning,

This was made using FM6, but it should work fine for you.

Here are two methods....

One loops through all your records and omits any that have a blank in either field.

The other finds all records with either field blank, then shows the ommitted records.

I'm not sure which is faster, since I only created 6 records, but I suspect that the "find and omit" will be faster for large numbers of records.

Let me now if this is not the solution you need, or if I misunderstood the question.

Paul

FileMaker Version: 6

Platform: Windows XP

Omit Records with blanks.zip

is there anyway that you can allow me access to see the script steps or how to put it in my db. the script seems to do what I need it for but there is no way to get access to it.

thanks.

This should do it. Here are pictures of the scripts, and I re-inserted the FM file. Check again to see if you have access to the scripts.

(Ignore Layout #3 and any reference to "Serial". I'm playing with this file.)

Paul

Omit Records with blanks.zip

I cant seem to find the [exit after last,next] part for the end of the loop. Right now the script continues to run until I esc. I'm using fm pro 5.5 v1 so i dont know if it isnt present in the version or what?

any suggestions?

FileMaker Version: 5

sorry about the last post. Missed the check box.

thanks for everything