Date select using list box

[#1]

I have a data set as follows:

Rcv Status Rcv Date Load Status Load Dt Loaded Status Loaded Dt

12 10-06-2010 22 11-06-2010 23 12-06-2010

What I want to achieve is I should have a listbox with the values 12,22 and 23. Based on my selections I have another list box called Date

which has values as Jan-2010, Feb -2010 etc.

So when I select status 12, this date listbox should actually pass the values for Rcv Date, similarly when 22 selected it should pass the values of Load Dt and Loaded Dt when 23 is selected.

How Can I go about achieving this.

Many thanks,

Kiran.

[dirk_konings · Accepted solution]

load RcvStatus as Status,

RcvDate as Date

from xyz;

load LoadStatus as Status,

LoadDate as Date

from xyz ;

load LoadedStatus as Status,

LoadedDate as Date

from xyz;

Now you have 2 fields with the corresponding values.

[#3]

thanks for the reply sir.

Once I get these 2 fields, when I select 12 (Rcv status) wont the date listbox show me values for all the status.

E.G. loaded data is as follows

12 12-05-2010

22 12-06-2010

23 12-07-2010

12 12-07-2010

So when I select drop down value 12 - it should select dates as 12-05-2010 and 12-07-2010

when I select drop down 22 - it should select dates as 12-06-2010

and when I select 23 - it should select date 12-07-2010

The selection should be independent of the status but from the same date field. Will this work as per your solution.

Thanks again.