Help with Parameter 1

[suburbanites]

Hi All,

I am using CRXI SP1. I have a problem with parameters. I am prompting the user to input 3 parameters:

parm1
parm2
parm3

I want to limit parm 3 to only the values that they have previously entered in parm1 and parm2. Ex.

parm1 = 1
parm2 = 200

parm3 should only be able to accept either 1 or 200.

Can this be done?

Thanks for any help that you can provide.

 

[IanWaterman]

Why not change Param 3 to allow user to select 1 or 2.
With a user prompt explaining use.

Then in select of wherever you use it

(If param 3 = 1 then Field = param1 else field = param2)

Ian

 

[suburbanites]

Parm1 and Parm2 can be any number ranging from 1 to whatever number. So I would like that when the parameter screen comes up, the user is limited to whatever the inputs are in parm1 and parm2 for parm2 value. Not sure if this is viable. The record selection is easy enough to code. It's more the parameter screen and defining parm3 values that's a challenge.

 

[IanWaterman]

I did appreciate Param 1 could be any number.

I do not think you can cascade actual values into Param3. However, sine they will be limited to value of either Param1 or Param2, then you can word prompt text of Param3 so it is clear user is selecting value in Param1 or 2.

YOu can make Param3 text if you like, such as
Use Param 1
or
Use Param 2

Then the formula I suggested becomes

(If param 3 = "Use Param1" then Field = param1 else field = param2)

Ian

 

[suburbanites]

Good idea Ian. Thanks so much for your help.