>I have knots in my brain...
>
>I have a variable (concatenation of keywords)
>I have one view of keys (keyword, cuecard id)
>I have another view of cuecards (cuecard id)
>
>I want to select all the cuecards that have a keyword that's in my concatenated keyword variable.
>
>This is what I've roughed out. But, I'm uncertain, and I can't test it, practically, til I get some data which means my form needs to work, which means my views, blah blah blah
>
>CREATE SQL VIEW "LimitedCues" ;
>AS SELECT * FROM cuecards!cuecards WHERE EXISTS ( SELECT * FROM CUECARDS!KEYS WHERE UPPER( keyword ) $ c_keys )
>
>I'll keep plugging away, but if anyone has a suggestion, I'd be glad for it!
>
>TIA
First check your SET EXACT condition.
Try adding this to your statement ;
SELECT * FROM cuecards!cuecards WHERE EXISTS ( SELECT * FROM CUECARDS!KEYS WHERE UPPER( keyword ) $ c_keys AND cuecards.cuecard.id == keys.cuecard.id)
That should work.
Sanjay Kapoor
Relatively speaking is a conversation with Einstein