Value List Find - checkboxes

[amypaulsmom]

I have a value list that is a list of 25 or so award categories. The last has some values - such as: book award, book award finalist, pulitzer award, pulitzer award finalist

I want to be able to do a Find on this value list. If I do a Find and check the checkbox with the category Book Award - the find does a find for any of the values that have the word Book or the word Award in them. So it finds all the book awards and the book award finalists, not just the sing value Book Award.

I tried creating a new filed that is a Text field - that does look at the value lists and pulls any of the awards over into it with a space between each word. but - still here - i am not able to do just a single Find to get the exact data that is wanted.

I have tried Finds with literal text ("") and with exact match (==). But when the data is moved over from the list to the field, it just places one award right after another and then I lose my specific Find capabilites.

All I am after - is to be able to do a Find on the value list for a particular type of award and have to find that set only. I don't want to have to use any scripting.

Can anyone help.

[Lee Smith]

Hi Tweety,

Since the information has duplication in it (Book Award) the == will aways return a request with both of the words in it, because it has found your request == Book Award. Try using the == and quotes and see what happens. I think this will only return the =="Book Award" and not the "book award finalists" This should also work in the concatenate field too.

HTH

Lee

[amypaulsmom]

Hi -

Thanks for the advice. Using =="" doesn't work on every category unfortunatetly. Unless someone has another idea. I think i will have to split apart the value lists into two - one be awards and one being awards finals. And still from there - I will have to adjust my wording slightly to catch those matchines.

Thanks for your help and any other ideas would be greatly appreciated.

[CobaltSky]

Hi,

I suggest that you consider a radically different approach to get the outcome you are looking for. Try this:

1. Create a global text field called gFilter, and attach your value list to it.

2. Create a self-join relationship which matches gFilter to your existing value list field

3. Place a button on the layout next to the gFilter field, which is directly attached to the command Go to Related Record [show] using the relationship defined at 2 above.

Once the above is in place, you will be able to do your searches by selecting some values in the gFilter field and clicking the button. You won't even have to go into 'find' mode - nor worry about juggling obscure operators or creating additional calculations.

[Lee Smith]

Good one Ray,

A little twist to this:

I used a portal to bring over the info on to the layout. That way I can see the related records and know what records I would go to.

HTH

Lee

[amypaulsmom]

That worked wonderfully!!!

Thank you for help on this one.

Tweety