It looks like you need to add TravH_ID to the TravD table. That way you have the association between the header and its details:
TravD_ID TravH_ID 1 1 2 1 3 1 etc. Then you can get it all with TravH_ID to include OP_ID HTH Michael Corrigan Programmer Endora Digital Solutions www.endoradigital.com 630/942-5211 x-134 ----- Original Message ----- From: Gonzo Rock To: CF-Talk Sent: Thursday, December 20, 2001 12:52 PM Subject: SQL Question Given 3 tables: Table Operations(Op) Op_ID, Op_Name,... and Table TravelerHEADER(TravH) TravH_ID, TravName, Part_ID,... and Table TravelerDetail(TravD) TravD_ID, Op_ID, TravOrder,... How can I retrieve the OP RecordSet associated with the subset of TravD records given a single TravH_ID IE: For every singular TravH header record there are multiple TravD detail records, each of which is related to a singular OP record. I want the OP RecordSet represented by the travD RecordSet. I've been trying to do this in a single query statement... do I sound way new ;) ... I am. thanks, Gonzo ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
