Hello, I have a problem with INNER JOINS. I have 6 tables in a database and they all have the same fields. I would like the user to be able to search the 6 tables together based on a fieldname selected from a pulldown menu. I want any matches from all the tables displayed. Here&#039s what I have:<BR><BR>SQLStmt = "Select *"<BR>SQLStmt = SQLStmt & "FROM ""Fonds"" INNER JOIN (""Sous Fonds"" INNER JOIN (JOIN ""Series"" INNER JOIN (""Sub Series"" INNER JOIN (""File"" INNER JOIN ""Item"" ON ""File"".IDLOOKUP = ""Item"".IDLOOKUP) ON ""Sub Series"".IDLOOKUP = ""File"".IDLOOKUP) ON ""Series"".IDLOOKUP = ""Sub Series"".IDLOOKUP) ON ""Sous Fonds"".IDLOOKUP = ""Series"".IDLOOKUP) ON ""Fonds"".Identifier = ""Sous Fonds"".IDLOOKUP" <BR><BR><BR><BR>If FieldCombo = "IDENTIFIER" Then<BR> SQLStmt = SQLStmt & "Where ""IDENTIFIER"" LIKE &#039%" & ID_NUM & "%&#039 "<BR>ElseIf FieldCombo = "TITLE" Then<BR> SQLStmt = SQLStmt & "Where ""TITLE/STMNT OF RESPONSIBILITY"" LIKE &#039%" & ID_NUM & "%&#039 "<BR>ElseIf FieldCombo = "ADMINISTRATIVE" Then<BR> SQLStmt = SQLStmt & "Where ""ADMINISTRATIVE HISTORY"" LIKE &#039%" & ID_NUM & "%&#039 " <BR>ElseIf FieldCombo = "CUSTODIAL" Then<BR> SQLStmt = SQLStmt & "Where ""CUSTODIAL HISTORY"" LIKE &#039%" & ID_NUM & "%&#039 " <BR>ElseIf FieldCombo = "SCOPE" Then<BR> SQLStmt = SQLStmt & "Where ""SCOPE AND CONTENT"" LIKE &#039%" & ID_NUM & "%&#039 "<BR>End If<BR><BR>The IF statements are there for the pulldown menu selections. Any help would be greatly appreciated.<BR><BR>Thanks, TP