Use remote queries. http://www.vb123.com/toolshed/02_accvb/remotequeries.htm
It allows you to join multiple dbm files in one query. I have also seen syntax like: Select * from c:\path\accessdb.mdb\tablename And this works, I've done it but it's been a long time. - Matt Small -----Original Message----- From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: Monday, April 11, 2005 12:15 PM 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:202218 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
