>I have an ODBC-Oracle database with a VFP front end with CRW 5.0. I have been trying to use a INLIST like function within CRW via the Record Selection Formula without success. Essentially, I have a front end with a list box of valid codes from which a user can select 1 to many items. I then concatonate the list (item1,item2,item...) for use in a INLIST type function. But, CRW does not appear to support that command. Any clues are appreciated, as always the deadline is tomorrow... tia
>
>Steve

in create report wizard on sort tab, select report field is one of ......
the 'is one of' option will show you all possible values for selected field. not sure how to code this (if you need to) -- i'm currently working with an eval copy