cascading parameters

[eoggb]

CR 11

I have a date parameter call rig date and if the users does not know the rig date i want them the parameter to return the current date

 

[synapsevampire]

I use thismethod:

I create a command query for the pick list using a UNION, as in:

select '1970-01-01' TheDate from anyttable
UNION ALL
select TheDate from yourtable

Have them select the 1970 date when unknown, then codethe record selection as:

if{?MyParm} <> cdate(1970,1,1) then
{table.date} = {MyParm}
else
if{?MyParm} = cdate(1970,1,1) then
{table.date} = curentdate

It can get a lil hairy...

-k