I hope someone is able to help me with this. I have three related tables: Connections (tbl_CNX), Systems (tbl_SYS), and Components (tbl_CMP). These tables have each been set up with a description field. I have created a form that uses comboboxes to identify interfaces by connections between components in different systems. Everything is working great. My problem is this: I need to grab the descriptions from each table and concatenate the descriptions into one string. Here's an example: tbl_CNX.Conn_Type = VDC tbl_CNX.Conn_Description = "Voltage DC" tbl_SYS.ID = 1 tbl_SYS.Description = "Engine Compartment" tbl_SYS.ID = 2 tbl_SYS.Description = "Surveillance System" tbl_CMP.ID = A tbl_CMP.Description = "Generator" tbl_CMP.ID = B tbl_CMP.Description = "Power Converter" Let's say there is a VDC connection between System 1 Component A and System 2 Component B. The key on my form would look like this VAC.1A.2B and my desired description would read "Voltage DC connection from Engine Compartment Generator to Surveillance System Power Converter". I have tried to use SQL to accomplish this but have had difficulty since i am not very experienced in that language. I would prefer to be able to assign a string variable to the descriptions that match the type and ID's but I'm not sure how to go about this either. If I could get the descriptions into a series of string variables, I could easily accomplish what I need. Thanks for your time and any help you can provide.