Yeah, kinda sorta. Keep in mind, I'm not advocating this as a solution. I've used it, and finally decided to merge the databases into one, eliminating the Access database.
But anyway, for awhile I was in a situation where employee information was kept in Oracle and employee Intranet accounts were stored in Access. I ended up creating a link table in Access to the Oracle DB, using an ODBC reference, and building queries out of the Access tables and the link table. We ended up merging the account information into Oracle, though. Hope this helps. Matt Osbun Web Developer Health Systems, International -----Original Message----- From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: Monday, April 11, 2005 11:15 AM To: CF-Talk Subject: Create 1 CFSELECT from two sources Using 6.1 and Access DB... Is there a way to combine two data sources to generate a CFSELECT list? I have a list of storage locations, and a list of participants. My select list will result in allowing the end user to tell me that the item is at a storage location, or with a participant. The list of participants is in one database, and the list of locations is in another. How do I make them appear in one list? ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ********************************************************************** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202191 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
