Record selecttion formula

[nikol]

Hi,
I'm using 2 static prompts with lovs for
City Initials
---------- ----------
ALL Cities All Initials
Campbell AW
Cupertino BB
Fremont MU
Los Altos IL
Los Gatos PL
Milpitas
Morgan Hill
Mountain View
Palo Alto
San jose
Santa Clara
Saratoga
Sunnyvale

In record selection formula I have
--------------------------------
if {?my parameter 3} = 'All Initials'
then
1=1
else
{Command_2.initials} = {?My Parameter 3} and
(if {?my Parameter 2} = 'All Cities'
then
1=1
else
{command_7.city} = {?my Parameter 2} )..

My problem is that when I select City="campbell" with Initials= "All Initials"
It gives me "all cities" with "all intials" but I want all initials in Campbell city which has 2 initials 'Mu' & 'IL'.
But It works fine for reverse order like.
If I do City="allcities" any Initials="MU"
I gives me only 3 cities which have initials "MU"
Its working one way.Help wanted...

 

[lbass]

Try setting off both clauses in parens as in:

(
if {?my parameter 3} <> 'All Initials' then
{Command_2.initials} = {?My Parameter 3} else
if {?my parameter 3} = 'All Initials' then
true
) and
(
if {?my Parameter 2} <> 'All Cities' then
{command_7.city} = {?my Parameter 2} else
if {?my Parameter 2} = 'All Cities' then
true
)

-LB

 

[nikol]

Hi! its working ...
Thanks alot.