searching for multiple records with different status(es)

[geraldh]

Hello,

 

I can't seem to figure this out, and I can imagine the solution is quite simple, but...

 

The database is for an Events Mangement Company; they have many records of Events.

Each Event is designated a status (Received, Confirmed, Declined, Invoiced, Closed, etc...)

 

Sometimes I need to display Event records that are match one or more statuses.

 

I wish to use a Checkbox option so that the user can click/unclick the desired statuses.

 

So if the user clicks "Received", "Confirmed", "Invoiced" than the user will see all the Records that have one of these statuses.

 

Any guidance would be much appreciated.

Thank you.

 

 

 

 

[bcooney]

No, actually, the solution is not simple.

 

In order to accomplish what you want, you have two choices. You can teach users how to use FM's native find or you can create a script.

 

If they use native find, you will do a new find request for each criteria. So, user enters Find, types "Received" in the status field, does a New Find Request, enters "Confirmed" in status field and then Performs Find. You may be able to also use the Extend Found Set command.

 

To script this with the checkbox interface, you would assign the checkbox set to a global field that is assigned a value list that consists of the status values. Then, loop thru the global doing a Find>New Find Request until you've exhausted the global. (see KB: http://help.filemaker.com/app/answers/detail/a_id/3474/related/1)

[geraldh]

bcooney,

 

Thank you for assuring me that this is not that simple!

I thought I gave up too easily!

 

Thank you for the link.

Best