You will need to run queries from both datasources and compare the results.
HTH ---------- Original Message ---------------------------------- from: Kris Pilles <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Thu, 1 Nov 2001 11:52:31 -0500 Ok heres my problem. I have a Access database that our users can go into and register new studetns with. However all of our course information resides in another datasource. My problem is that I have to display the course names which reside in database 2. however I have to use the course ID's stored in Datasource 1. How can I dothis? Thanks for all your help Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

