Say I have a value list with 5 entries and use that value list in a check box format for field x.

I would like to find all records where field y equals one of the checked values.

Is there an efficient sequence of script steps to do this?? I'm envisioning a loop of 'extend found set' using 'middlevalues' for each of the checked items.

There's got to be a better way!

TIA

tomp

Create a relationship matching field x to field y. Then create a script to Go to Related Records [show only related; "yourRelationship"].

I don't understand how that would solve the problem.

If I relate x to y, and x has the list 'a,b,c,d,e', wouldn't that only 'go to' records where y was 'a,b,c,d,e' when what I want are records where y=a or y=b or y=c or y=d or y=e??

Thanks

"... x has the list 'a,b,c,d,e' ..."

No, it doesn't.

The selected options are paragraph separated, which makes them into a multi-key.

Just to keep you moving forward between Queue's help ...

If I relate x to y, and x has the list 'a,b,c,d,e', wouldn't that only 'go to' records where y was 'a,b,c,d,e'?

Nope. It will Go To Related Records[] A or B or C or D etc.

By their very nature, checkboxes (or value lists) create a multiline key, ie, each 'item' is on a separate line with a carriage return between them. So each item relates independently. So in your case, it will find (or relate) to any item in the checkbox list.

Update! Ah Vaughan! You beat me! But I certainly used many more words to say the exact same thing that you did. But I suppose some might appreciate a bit more explanation so I'll leave my post here.

LaRetta

Thanks!

I knew nothing about the existence or use of multi-line keys. Works like a champ!