How many records are in each table and what do they look like (just the columns in question). The only way I'd see you getting more than one record back is if there are several different records in the clients table with the same client_id. I'm guessing the tables look similar to this:
CLIENTS: client_id 1 2 3 client_family_id 123 456 789 FAMILY_GROUPS group_id 123 456 789 group_name smith james johnson So, when your url.client_id variable equals 1, you're going to get client_id = 1, fg.group_id = 123, fg.group_name = smith Am I missing something here???? >>>> 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 >>>> >>>> >>>> >>>> >>>> >>>> >>> >>> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:219928 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
