2 recordset

[1000kisoen]

hi,
i have 2 recordsets each have there own connection string and database

how can I link these 2 together?
both have the same recordid and ofcourse different data

please advise
kisoen

 

[lebisol]

u would create a query in DB and then DW will treat it as one table/recordset
see a sample:

http://mostarnet.com/tutorials/access/bickyz.zip

All the best!

:--------------------------------------------------------------------------:

ok,ok...I did shoot the deputy but he told me he was the sheriff!
:--------------------------------------------------------------------------:

 

[CTekMedia]

How do you want to link the data - you will need to be more specific. You could link the data from one database to another then run a view or query as lebisol suggested. If you are using ColdFusion you could look at the query of query feature - there is likely some equivalent in .asp

More data needed.

Live Free or Die

http://www.bluetone-media.com

BT