Well, you haven't posted any data snapshot out here yet, but I'm betting you're getting what you should be getting back. Basically, what you're saying is this:
Select FG.Group_ID, FG.Group_Name, C.Client_ID, C.Client_First_Name, C.Client_Middle_Name, C.Client_Last_Name >From Clients C inner join Family_Groups FG on C.Client_Family_ID = FG.Group_ID Where C.Client_ID = '#URL.Client_ID#' I don't see any way that this is going to (sensibly) return you more than one record!!! You are effectively limiting it to one record with your where clause. If you feel that I'm wrong about this, please post your data out here so we can take a look at what is happening. --Ferg >>> Select FG.Group_ID, FG.Group_Name, >>> C.Client_ID, >>> C.Client_First_Name, C.Client_Middle_Name, >>>C.Client_Last_Name >>> from Family_Groups FG, Clients C >>> where FG.Group_ID = C.Client_Family_ID >>> and C.Client_ID = '#URL.Client_ID#' >>> >>>Rick >>> >>> >>> >>> >>> >> >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219940 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
