Parameter like

Hi
I would like to give the users a list to select from
ie
Selsey
Runcton
Fruit

When they select Selsey (for example) I want information returned for Selsey and Selsey Leaf

Hope this makes sense
Gordon

That's fine, just put those values into the selection list of the parameter.

Hi

Do I still create a formula
UpperCase({?myparam}) = uppercase(left({myfield},len({?mymaram})))

Gordon

Hi

I tried to add the formula
?myparam guess this is replaced with ?factory being the parameter

Not sure what the other 2 are replaced with?

Gordon

Create a parameter with values like London, Selsey, etc.. the use the following record selection criteria:

{table.field} like {?param}

No need to convert to uppercase unless your database doesn't allow for case insensitivity (Oracle, for example) AND you have mixed case data.  A "like" isn't particularly efficient, but at least it processes on the databaes, where as an uppercase against a databased field won't be.

~Kurt

Hi
I found the solution
A simple case of using the slect feature and adding field with starts with and add the ?parameter
It works ok
Gordon