I hope someone can help me preform this find.

I want to find all my open jobs. This is what I am doing now is finding all jobs from a certain date to present (field name Open Date), then sorting them and omitting the completed jobs (drop down menu, field name is Job Status), but this is really a pain.

1. The original find that I wanted to do was with a radio button that has 2 buttons, open and closed. I could not get it to even search this field.

2. The second way I could search was by a drop down menu that says, In Queue, At vendor, Complete, Cancelled, On Hold and Rush. I guess I could search by closed jobs, but how do you tell FM to show the opposite of what find? I know I just can't omitted them.

3. The third way I could do my open job search is to search in a date field called Complete, which we put the closed date in. This date is different every time, so was not sure how I would or could do a find with this field.

Thanks in advance

I hope someone can help me preform this find.

I want to find all my open jobs. This is what I am doing now is finding all jobs from a certain date to present (field name Open Date), then sorting them and omitting the completed jobs (drop down menu, field name is Job Status), but this is really a pain.

1. The original find that I wanted to do was with a radio button that has 2 buttons, open and closed. I could not get it to even search this field.

Is the field enabled to be searchable in Find Mode? How are you trying to do the Find? Are you going into Find Mode or are using a script step?

2. The second way I could search was by a drop down menu that says, In Queue, At vendor, Complete, Cancelled, On Hold and Rush. I guess I could search by closed jobs, but how do you tell FM to show the opposite of what find? I know I just can't omitted them.

When I know in Browse Mode there is an Omit Multiple records somewhere. I can't exactly remember in FileMaker 9. There is the "Omit Record" script step.

You can use the menu item under Records or the script step to "Show Omitted Only" after you do the find.

3. The third way I could do my open job search is to search in a date field called Complete, which we put the closed date in. This date is different every time, so was not sure how I would or could do a find with this field.

I'm supposing that the only time the date field has data in it is when it is closed. Use an asterix* in that field to find the ones with data in it. Or have it omit those records if you want the opposite.

Hope That Helps