<% Dim connect var=server.MapPath("/pthk.mdb") set connect = server.createobject("ADODB.Connection") connect.Open "dbq=" & var & ";driver={microsoft access driver (*.mdb)}; driverid=25; file=ms access;" Set Areas = connect.execute("SELECT * FROM Areas ORDER BY AreaName") Set AssignedAreas = connect.execute("SELECT * FROM Attorneys_Areas WHERE AttorneyID=" & Request("id") & " ORDER BY SortForAttorneys") Set AssignedBarAdmissions = connect.execute("SELECT * FROM Attorneys_BarAdmissions WHERE AttorneyID=" & Request("id") & " ORDER BY BarAdmissionID") Set AssignedEducation = connect.execute("SELECT * FROM Attorneys_Education WHERE AttorneyID=" & Request("id") & " ORDER BY EducationID") Set AssignedPublications = connect.execute("SELECT * FROM Attorneys_Publications WHERE AttorneyID=" & Request("id") & " ORDER BY PublicationID") 'Set AssignedClubs = connect.execute("SELECT FROM Attorneys_Edu_Clubs WHERE AttorneyID=" & Request("id") & " ORDER BY EducationID") Set AssignedClubs = connect.execute("SELECT Attorneys_Edu_Clubs.clubdetails, Attorneys_Education.School, Attorneys_Education.EducationID, Attorneys_Edu_Clubs.ClubID FROM Attorneys_Edu_Clubs INNER JOIN Attorneys_Education ON Attorneys_Edu_Clubs.EducationID=Attorneys_Education.EducationID where Attorneys_Edu_Clubs.AttorneyID=" & Request("id") & " ORDER BY Attorneys_Education.EducationID") %> ">

Add or remove attorney's properties and then close window.
Practice Areas Hold CTRL while clicking to handle multiple areas at once.
<% Dim AreaList AreaList = "" If AssignedAreas.eof<>true Then do until AssignedAreas.eof AreaList = AreaList & "|" & AssignedAreas("AreaID") & "| " AssignedAreas.MoveNext Loop AssignedAreas.MoveFirst End If %> <% do until Areas.eof %> <% If InStr(AreaList,"|" & Areas("AreaID") & "|")>0 Then %> <% Else %> "><%=Areas("AreaName")%> <% End If %> <% Areas.MoveNext Loop Areas.MoveFirst %>		<% If AssignedAreas.eof<>true Then do until AssignedAreas.eof set AssignedAreasInfo = connect.execute("SELECT * FROM Areas WHERE AreaID=" & AssignedAreas("AreaID") & "") %> " ><%=AssignedAreasInfo("AreaName")%> <% set AssignedAreasInfo = nothing AssignedAreas.MoveNext Loop End If %>
Bar Admissions
<% If AssignedBarAdmissions.eof <> true Then do until AssignedBarAdmissions.eof %> <% AssignedBarAdmissions.MoveNext Loop Else End If %> Bar Admission Year   <%=AssignedBarAdmissions("BarAdmission")%> <%=AssignedBarAdmissions("Year")%> '"> ">
Education
<% If AssignedEducation.eof <> true Then do until AssignedEducation.eof %> <% AssignedEducation.MoveNext Loop Else End If %> School Name Degree Acquired Year   <%=AssignedEducation("School")%> <%=AssignedEducation("Degree")%> <%=AssignedEducation("Year")%> '"> ">
Educational Clubs or Memberships
<% If AssignedClubs.eof <> true Then do until AssignedClubs.eof %> <% AssignedClubs.MoveNext Loop Else End If %> School Name Club Details   <% AssignedEducation.MoveFirst If AssignedEducation.eof <> true Then do until AssignedEducation.eof %> "><%=AssignedEducation("School")%> <% AssignedEducation.MoveNext Loop Else End If %> <%=AssignedClubs("School")%> <%=AssignedClubs("clubdetails")%> '"> ">
Publications
<% If AssignedPublications.eof <> true Then do until AssignedPublications.eof %> <% AssignedPublications.MoveNext Loop Else End If %> Publication Info Year   <%=AssignedPublications("Publication")%> <%=AssignedPublications("PubYear")%> '"> ">