Forums
This topic is locked
Recordset1 to filter the info from recordset2?
Posted 21 Jul 2002 23:25:34
1
has voted
21 Jul 2002 23:25:34 Gretarsson Ingi Orn posted:
Basically the question is this.. I have a result page that displays the information from a recordset. The recordset is filtered with a form variable and shows me the details of a specific order number. This Record also shows me the CustomerId. Now I need to display on this very same page the information on this customer based on the customerID and the details of the customer are stored in a seperate table. So the Real question here is this.. Can I some how use a specific recordset.feild information displayd on a page to retrive information in another recordset (from another table) and display the relevant information also on this same page..
I don´t know if I am making this clear enought.. let me know..
need to display information from 1 recordset relative to the information from another..
IIS//Ultradev 4//WinXP_Pro/ASP:VB/JS
Replies
Replied 21 Jul 2002 23:43:32
21 Jul 2002 23:43:32 Gretarsson Ingi Orn replied:
Ok.. I figuered this out my self..
What I did to make this simple was to just create a querie in the DB with all the relevant fields from both the order (with the orderID that is filtered in the other recordsets also) table and the customer table with the information needed. And then I just use this querie as for my new recordset on the page filtereing the orderID..
IIS//Ultradev 4//WinXP_Pro/ASP:VB/JS
What I did to make this simple was to just create a querie in the DB with all the relevant fields from both the order (with the orderID that is filtered in the other recordsets also) table and the customer table with the information needed. And then I just use this querie as for my new recordset on the page filtereing the orderID..
IIS//Ultradev 4//WinXP_Pro/ASP:VB/JS