Passing different variables and filtering recordsets

[sinistapenguin]

I have a page which has a recordset filtered by a session variable (OrderNo), it contains the following data:

StockCode – Description – Qty – Total

From this page I want to pass the ‘StockCode’ and the Session ‘OrderNo’ to the next page.

I then want to filter another recordset on these 2 variables so that the next page displays only records from that OrderNo which have that StockCode.

Can anyone tell me how to do this?

Thanks

Sinista

 

[Cheech]

Look at the tutorial for "Master/Detail" pages. What you are trying to do is just pass a forms details to another page and create a recordset based on that information.

Shout if the tutorial dosn't make sense.

Cheech

[Peace][Pipe]