Standard Jet DBnb` Ugr@?~1y0̝cǟFN7]D^(`T{6u߱wCϯ34ay[|*|OJl>`&_Љ$g'DeFx -{NKKD AccessVersionBuildAppTitle StartUpFormStartUpShowDBWindowStartUpShowStatusBarStartUpMenuBarAllowShortcutMenusAllowFullMenusAllowBuiltInToolbarsAllowToolbarChangesAllowBreakIntoCodeAllowSpecialKeysAppIcon  07.53   Skills Form          KKD AccessVersionBuildAppTitle StartUpFormStartUpShowDBWindowStartUpShowStatusBarStartUpMenuBarAllowShortcutMenusAllowFullMenusAllowBuiltInToolbarsAllowToolbarChangesAllowBreakIntoCodeAllowSpecialKeysAppIcon  07.53   Skills Form            KKDc RecordLocks ODBCTimeout MaxRecords RecordsetTypeFilterOrderBy OrderByOn Replicable1  <  KKDp OrderByOn ColumnWidth ColumnOrder ColumnHidden DecimalPlaces DefaultValueRequiredDisplayControl Tid      0  mZskill_id      0  mKKDd OrderByOn ColumnWidth ColumnOrder ColumnHiddenRequiredAllowZeroLengthDisplayControl 5skill_id   N skill      mKKDd OrderByOn ColumnWidth ColumnOrder ColumnHiddenRequiredAllowZeroLengthDisplayControl N fname      m/id   KKDW RecordLocks OVCS           2c   ct    j    O        IdParentIdNameType DateCreate DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtrasetni PPP Id ParentIdName        00-000000000046}#4.0#0#C:\Program Files\Common Files\Microsoft Shared\DAO\DAO350.DLL#Microsoft DAO 3.5 Object Library h4 Form_Form1 a3d1c8cdd*D (x g_q 6< MMSysDb#OVCIS     2  ObjectIdSIDACM FInheritablebc ObjectIdgruo,vljmmvgruo!ov}vda!!ov}vda!!ov}vda!ov}vda! ;'2r҄@;'2r҄@UserDefined***********  ;'2r҄@;'2r҄@SummaryInfo***********  ;'2r҄@;'2r҄@AccessLayout+++++++++++ 1r҄@1r҄@SysRel%%%%%%%%%%% 1r҄@1r҄@Scripts&&&&&&&&&&& 1r҄@1r҄@Reports&&&&&&&&&&& 1r҄@1r҄@Modules&&&&&&&&&&& 1r҄@1r҄@Forms$$$$$$$$$$$ 1r҄@1r҄@MSysRelationships22222222220 1r҄@1r҄@MSysQueries,,,,,,,,,,* 1r҄@1r҄@MSysACEs))))))))))' 1r҄@1r҄@MSysObjects,,,,,,,,,,* 1r҄@1r҄@MSysDb''''''''''% 1r҄@1r҄@Relationships.........., 1r҄@1r҄@Databases**********( 1r҄@1r҄@Tables''''''''''% VC?#S  #           ObjectId AttributeOrderName1Name2 ExpressionFlagilnzjtz ObjectIdAttribute         z@`a|||<?8$ st0SC7?DetailEC7?cmd1AC7?Label5Label6List7Label10GC7? chkShowSQL cmd1_Click Form_Load t48<@Z;|?1GS SELECT fname, skill  # FROM names, skills, SkillDescrips 1 _ WHERE names.id = skills.id And skills.skill_id = SkillDescrips.skill_id and skills.skill_id =  order by fname , Skills as Skills  AND Names.id = Skills .id AND Skills .skill_id = @ČF1BJ h)aN?  qm.ym.1m. VBA332.DLL  S Nobody has that skill. Nobody has all those skills. fnameF;|?  __SRP_1&rU~~~~~~~q   A ( 8 H AX hXVCS      P    P  szRelationshipgrbitccolumnicolumnszObjectszColumnszReferencedObjectszReferencedColumnPP PP PP szObjectszReferencedObjectszRelationship :9ʾSkillDescripsqrySkillsSkills Form :9>,j]!&Snames Sskills2SSkillDescrips}J&Snames1SskillsgdSkillDescripsbeSkills2rgSkillDescrips_1 {qg]SI?5$o{N     0=Babc-e g hiXjB6k G{@Arial[Event Procedure]d2hgh MS Sans Serifj1ghm45n2`Detailn3U8`abcdTList0 Table/Query SkillDescrips288m7U`ab| cTkText2h1U`a bc hicmd1GO AHEAD[Event Procedure]d5U7`ab c,eLabel5(Multi)Select Skills You Wantd5U7`ab cheLabel6Guys That Have All Those Skillsn3U`abc4dTlList7 Table/Query qrySkills576d5U7`ab4c,eLabel8Guys and Their Skillsd5U7`ab!cd eLabel10ݢSomeone wanted a way to show everyone that had all of a set of selected skills. So I build a query in code thao{N..   2skill_idskill.0 .1 PrimaryKeyskill_id4Label5,Label6,List7Label8,Click _B_str_from' _B_str_where _B_str_ordbyTCollectValueKmsgQ _B_var_msgbr _B_var_IfP<   dirb^0* pHdskills$@T=j h4 J"< DAO>DAOP *\G{00025PE01-0C  0046}#4.0#0#C:\Program Files\@Common Micro pG@pG@qrySkills((((((((((( (ZpG@pG@names$$$$$$$$$$$ 7pG@ZpG@MSysModules2+++++++++++ 7pG@7pG@MSysModules***********  pG@7pG@Example with Inner Joins77777777777 pG@pG@Form1$$$$$$$$$$$  pG@pG@UserDefined***********  pG@pG@SummaryInfo***********  pG@pG@AccessLayout+++++++++++ pG@pG@SysRel%%%%%%%%%%% pG@pG@Scripts&&&&&&&&&&& pG@pG@Reports&&&&&&&&&&& pG@pG@Modules&&&&&&&&&&& pG@pG@Forms$$$$$$$$$$$ pG@pG@MSysRelationships22222222220 pG@pG@MSysQueries,,,,,,,,,,* pG@pG@MSysACEs))))))))))' pG@pG@MSysObjects,,,,,,,,,,* pG@pG@MSysDb''''''''''% pG@pG@Relationshi@@ @@@@ vljmmvgruod`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfv1vt,bvljmmvgruo1vt,bmjvwVf|`osmf{jwijppfukrjpvov}v`bfvov}vordxmfvov}vordxmfvXov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsvp`ofvtu}vljmmvvljmmdfvbujsvvljmmv`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfd     ?cmd1AC7?Label5Lab(8 namesskillsnames.id = skills.id7  SkillDescrips.skill+ g  names.fname# g SkillDescrips  skills  names   G  G     T names.fname# ' T2@ ' Skills2SkillDescrips_1+@."  namesSkills2o{@@ gruoWd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvf|`osmf{jwijppfukrjpvov}v`bfvov}vordxmfvov}vordxmfvXov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsvp`ofvtu}vljmmv`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfd' @ @ @        ',1@[LS S8LX8L8LLLLL>'@# FROM names, skills, SkillDescrips ' l  ' h !f'electe " &!(!  L t f%~' Debug.  %6. order by fname' 0X   %~ 4.intI =?MsgBox List0.Column(0, varItm) & vbCr & List0.Column(1, varItm) SkillDescrips' ND !8. !:X ("J ("N B@B) @ @ @ @                                          ! "   H1` ,Q2"(+__SRP_0|K)^ Form_Form1 Form_Form1rU~~~~~~~k >N`  a Q1  Form_Form1skillsF=C:\Program Files\Common Files\Microsoft Shared\VBA\VBA332.DLLVBA 4߹"X߹88&߹@@,߹1T߹;߹pp<߹4=P߹4>߹4?߹HHHH4@L߹PPPP4A߹XXXX4B߹xxxx4CH߹4D߹$E߹$FD߹$G߹$H߹$I@߹$J߹$K߹߹ $O8߹$P߹$  @ KQ]u=i-Tw-  *\G{000204EF-0000-0000-C000-000000000046}#3.0#9#C:\Program Files\Common Files\Microsoft Shared\VBA\VBA332.DLL#Visual Basic For Applications*\G{ *srG@6hsrG@~sq_cSkills Form~sq_cList0:*@ 8SSSG;;;;;;9 `1K({@**{@skills7@8333'''''''% @,'{@'w({@SkillDescrips@8:::......., @ Bh*{@e*{@qrySkillsE"@8@7NBB6******( `'&{@w@'{@names@8222&&&&&&&$ @ю{@ю{@MSysModules2----------+ ю{@ю{@MSysModules,,,,,,,,,,*  a۪pG@@pG@Example with Inner Joins@8$@7QEE99999997 @C/{@3rG@Skills Form,,,,,,,,,,*  ю{@ю{@UserDefined,,,,,,,,,,*  ԃю{@ԃю{@SummaryInfon@8888,,,,,,,* @ L݁{@rG@AccessLayout*@8@7E99-------+ @>>Ҏ{@>>Ҏ{@SysRel''''''''''% Ҏ{@Ҏ{@Scripts((((((((((& Ҏ{@Ҏ{@Reports((((((((((& Ҏ{@Ҏ{@Modules((((((((((& Ҏ{@Ҏ{@Forms&&&&&&&&&&$ jЎ{@jЎ{@MSysRelationships22222222220 jЎ{@jЎ{@MSysQueries,,,,,,,,,,* jЎ{@jЎ{@MSysACEs))))))))))' jЎ{@jЎ{@MSysObjects,,,,,,,,,,* jЎ{@*QrG@MSysDb@8333'''''''% @jЎ{@jЎ{@Relationships.........., jЎ{@jЎ{@Databases**********( jЎ{@jЎ{@Tables''''''''''% #cCFVC0 ]{hU5 @L L L L  L `L  PrimaryKey L L  L L 8L xL  L `HL  PrimaryKeyL L v 0L (L L v L L L L v L L HL 0 L  SkillDescrips    G     SkillDescrips.skill_id. '  names.fname# ' skillsSkillDescrips(@+  namesskillsnames.id = skills.id7  SkillDescrips.skill+ g  names.fname# g SkillDescrips  skills  names   G  G      names.fname# ' 2@ ' Skills2SkillDescrips_1+@."  namesSkills2names.id = Skills2.id9  skillsSkillDescrips(@+  namesskillsnames.id = skills.id7  SkillDescrips_1.skill- g SkillDescrips.skill+ g  names.fname# g SkillDescripsSkillDescrips_1((  SkillsSkills2  SkillDescrips  skills  names   G  G    ALVAL{Si'Qm3rItm) & vbCr & List0.Column(1, varItm) amesah . " &%2' .escr \ Z8P $ , . 0'`# FROM names, skills, SkillDescrips ' ,  ,, Ski@ rG@rG@Example with Inner Joins77777777777 rG@rG@Skills Form***********  rG@rG@UserDefined***********  rG@rG@SummaryInfo***********  rG@rG@AccessLayout+++++++++++ rG@rG@SysRel%%%%%%%%%%% rG@rG@Scripts&&&&&&&&&&& rG@rG@Reports&&&&&&&&&&& rG@rG@Modules&&&&&&&&&&& rG@rG@Forms$$$$$$$$$$$ rG@rG@MSysRelationships22222222220 rG@rG@MSysQueries,,,,,,,,,,* rG@rG@MSysACEs))))))))))' rG@rG@MSysObjects,,,,,,,,,,* rG@rG@MSysDb''''''''''% skills.skill_id = SkillDescrips.skill_id(((skills.skill_id)=1) AND ((Skills2.skill_id)=2))Skills2.skill_id = SkillDescrips_1.skill_idskills.skill_id = SkillDescrips.skill_idVCEN __A__          ObjectId AttributeOrderName1Name2 ExpressionFlagilnzjtz ObjectIdAttribute         z@`a|||<?8$ st0SC7?DetailEC7?cmd1AC7?Label5Label6List7Label10GC7? chkShowSQL cmd1_Click Form_Load t48<@Z;|?1GS SELECT fname, skill  # FROM names, skills, SkillDescrips 1 _ WHERE names.id = skills.id And skills.skill_id = SkillDescrips.skill_id and skills.skill_id =  order by fname , Skills as Skills  AND Names.id = Skills .id AND Skills .skill_id = @ČF1BJ h)aN?  qm.ym.1m. VBA332.DLL  S Nobody has that skill. Nobody has all those skills. fnameF;|?  __SRP_1&rU~~~~~~~q   A ( 8 H AX hX{@@   vljmmvgruod`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfd2ApG@ApG@skills%%%%%%%%%%% -pG@ApG@SkillDescrips,,,,,,,,,,,  pG@pG@qrySkills((((((((((( (ZpG@pG@names$$$$$$$$$$$ 7pG@ZpG@MSysModules2+++++++++++ 7pG@7pG@MSysModules***********  pG@7pG@Example with Inner Joins77777777777 pG@pG@Form1$$$$$$$$$$$  pG@pG@UserDefined***********  pG@pG@SummaryInfo***********  pG@pG@AccessLayout+++++++++++ pG@pG@SysRel%%%%%%%%%%% pG@pG@Scripts&&&&&&&&&&& pG@pG@Reports&&&&&&&&&&& pG@pG@Modules&&&&&&&&&&& pG@pG@Forms$$$$$$$$$$$ pG@pG@MSysRelationships22222222220 pG@pG@MSysQueries,,,,,,,,,,* pG@pG@MSysACEs))))))))))' pG@pVCeN            sFlagsFormModuleNameReplicationVersionTypeTypeInfoVersion&Index1 vbujswv v}vufm w`amfvf|`osmf{jwijppfukrjpvov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfd@ rG@rG@Example with Inner Joins77777777777 rG@rG@Skills Form***********  rG@rG@UserDefined***********  rG@rG@SummaryInfo***********  rG@rG@AccessLayout+++++++++++ rG@rG@SysRel%%%%%%%%%%% rG@rG@Scripts&&&&&&&&&&& rG@rG@Reports&&&&&&&&&&& rG@rG@Modules&&&&&&&&&&& rG@rG@Forms$$$$$$$$$$$ rG@rG@MSysRelationships22222222220 rG@rG@MSysQueries,,,,,,,,,,* rG@rG@MSysACEs))))))))))' rG@rG@MSysObjects,,,,,,,,,,* rG@rG@MSysDb''''''''''% JrG@JrG@Relationships.........., JrG@JrG@Databases**********( JrG@JrG@Tables''''''''''% {qg @ @                    Id ParentIdName        00-000000000046}#4.0#0#C:\Program Files\Common Files\Microsoft Shared\DAO\DAO350.DLL#Microsoft DAO 3.5 Object Library h4 Form_Form1 a3d1c8cdd*D (@LVAL+@@ @@ @vljmmvgruod`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvf|`osmf{jwijppfukrjpvov}v`bfvov}vordxmfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfd ;'2r҄@;'2r҄@UserDefined***********  ;'2r҄@;'2r҄@SummaryInfo***********  ;'2r҄@;'2r҄@AccessLayout+++++++++++ 1r҄@1r҄@SysRel%%%%%%%%%%% 1r҄@1ͬ g_q DetailnList0mText2h cmd1d Label5d Label6nList7d Label8d Label10d Label12j chkShowSQLLVAL i_VBA_MODULE?p>N`g_q >N`xTZ>N`>N`vLL tDHrLpPvTxXz\|`dhH @[LS S8LX8L8LLLLL>'@# FROM names, skills, SkillDescrips ' l  ' h !f'electe " &!(!  L t f%~' Debug.  %6. order by fname' 0X   %~ 4.intI =?MsgBox List0.Column(0, varItm) & vbCr & List0.Column(1, varItm) SkillDescrips' ND !8. !:X ("J ("N B@BLVAL ?MsgBox List0.Column(0, varItm) & vbCr & List0.Column(1, varItm) amesah . " &%2' .escr \ Z8P $ , . 0'`# FROM names, skills, SkillDescrips ' ,  ,, Skills as Skills ' ,@SELECT fname, skill ' $ ' _ WHERE names.id = skills.id And skills.skill_id = SkillDescrips.skill_id and skills.skill_id = ' .(8 &!(!*Fug . AND Names.id = Skills .id AND Skills  .skill_id =  " &%2' .harryhstopA@H ">'@ !:Fqg !:uh` aaNobody has all those skills.A@<hPNobody has that skill.A@<P j A@<hl'jAttribute VB_Name = "Form_ 1" Bas0{98EAE60E-8912-11D1-9367-00805F710B97} |CreatablTrue PredecdlaId"E xposeFals @TemplateDeriv%Customiz$Optio@n Comp@ &DTv Dim sql As Sng  db rst RecordsDetqdf QueryDef)PQU Sub cmd1_Click() %j%, varItm, sel$ If List0.ItemsSelected.Count0 Then Exxit0$"SELECT fn@}kill lfrom$@ FROM As S Descrips where WHERE .ijs sAnd D_u .a (Wbyer by׃2C;j00 EachDS InO ?j + 1[A1UA >&Column(0qDv >E®A\& ", Es aAP" & j"` AND A\=D"Ba@1cK93IXxNex\!!e="V ##7#Set @i= CurrentDbUg=.beh(>"$ d*!o= .Openo7.EOF 8:MsgBox "Nobody h1thatX.P 9Pakth_` ) vETm@-2[!"w#%DoMove2 #% & vbCrLf8L Loop Until ! *G#@ chkShowSQL-# 7ci< A_Load = `|__SRP_2D rU (aLVAL  q Q Y 1 I q A9a a@Da)ttt@HAi1@Lrrr@Pppp@ T)vvv@XAixxx@\Azzz@`|||@dA@h!E?4X\`! ` T\ lX)`\9CdCTCPCLpz(\`! ` TQ\[Hh`rD~ kzpz kz:lPF$4h`! ` (4`1P`64qlT*#kz# *1T2 ulP*#kz# *# *#kz#*# *F4h`! ` (4`1P2  `64 hsD$ldlT*#lP*# lL*42 `" $ Q`8'`4F%:$%_8 Q`@-`'%'%'4%_@ Q`<64_< 4k kz`+''':$N44 64+''':$N44 64"4:$%_< $4! 54 _< _< 4kDQ4`! ` L4:$:%_< $%! `64_< 4k`! Q`o4<LVALHhã            FlagsFormModuleNameReplicationVersionTypeTypeInfoVersion'Index1KKD AccessVersionBuildAppTitle StartUpFormStartUpShowDBWindowStartUpShowStatusBarStartUpMenuBarAllowShortcutMenusAllowFullMenusAllowBuiltInToolbarsAllowToolbarChangesAllowBreakIntoCodeAllowSpecialKeysAppIcon  07.53   Skills Form            KKDc RecordLocks ODBCTimeout MaxRecords RecordsetTypeFilterOrderBy OrderByOn Replicable1  <  KKDp OrderByOn ColumnWidth ColumnOrder ColumnHidden DecimalPlaces DefaultValueRequiredDisplayControl Tid      0  mZskill_id      0  mKKDd OrderByOn ColumnWidth ColumnOrder ColumnHiddenRequiredAllowZeroLengthDisplayControl 5skill_id   N skill      mKKDd OrderByOn ColumnWidth ColumnOrder ColumnHiddenRequiredAllowZeroLengthDisplayContr('''44M$@ 64@(HDPdLTh<  `\4D(l%! $ THS__SRP_3rU t$`0 $)`4 pLVALItemsSelectedoCount0vfrom~ where֍ordbyAColumni CurrentDbSCreateQueryDefzN OpenRecordset|EOFMsgBoxRfnameRText2~MoveNextL!vbCrLfFormDetail2cmd14Label5,Label6,List7Label8,Click _B_str_from' _B_str_where _B_str_ordbyTCollectValueKmsgQ _B_var_msgbr _B_var_ifPLabel10@Label12B chkShowSQL\ Form_Load{<   dirb^0* pHdskills$@T=j h4 J"< DAO>DAOP *\G{00025PE01-0C  0046}#4.0#0#C:\Program Files\@Common Microsoft Shared\w350.DL L# 3.5 Object LibraryHE Form_1 _VBA_MOD@ULE2VBo_MqDULE H1`ist0 ItemsSelectedoCount0vfrom~ where֍ordbyAColumni CurrentDbSCreateQueryDefzN OpenRecordset|EOFMsgBoxRfnameRText2~0=Babc-e g hiXjB6k G{@Arial[Event Procedure]d2hgh MS Sans Serifj1ghm45n2`Detailn3U8`abcdTList0 Table/Query SkillDescrips288m7U`ab| cTkText2h1U`a bc hicmd1GO AHEAD[Event Procedure]d5U7`ab c,eLabel5(Multi)Select Skills You Wantd5U7`ab cheLabel6Guys That Have All Those Skillsn3U`abc4dTlList7 Table/Query qrySkills576d5U7`ab4c,eLabel8Guys and Their Skillsd5U7`ab!cd eLabel10ݢSomeone wanted a way to show everyone that had all of a set of selected skills. So I build a query in code that keeps adding AND clauses for each skill selected.j2U`a bci chkShowSQLd5`a b ceLabel12Show SQL statementtst0SC7?DetailEC7?cmd1AC7?Label5Label6List7Label10GC7? chkShowSQL cmd1_Click Form_Load t48<@Z;|?1GS SELECT fname, skill  # FROM names, skills, SkillDescrips 1 _ WHERE names.id = skills.id And skills.skill_id = SkillDescrips.skill_id and skills.skill_id =  order by fname , Skills as Skills  AND Names.id = Skills .id AND Skills .skill_id = @ČF1BJ h)aN?  qm.ym.1m. VBA332.DLL  S Nobody has that skill. Nobody has all those skills. fnameF;|?  __SRP_1&rU~~~~~~~q   A ( #MSysDb#= d)Form_Skills FormEA51-LVAL %< P EsP`? H      }< o dirfb0* pHdskills$@T=j f= J"< DAO>DAOP *\G{00025PE01-0C  0046}#4.0#0#C:\Program Files\@Common Microsoft Shared\w350.DL L# 3.5 Object LibraryHE For(m_S  _VBA_MODULE2!VBr_MtDULE H1E ,5"( +=LVALȰ_VBA_PROJECTI a^  *\G{000204EF-0000-0000-C000-0000000000 @     `  PrimaryKey      8 x  `H  PrimaryKey  v 0 (  v     v   H 0  @ @s @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @     X    `    skills@  @  @  0 `    names PrimaryKey@ $ p $  @ $   8  h   $ @ P X d  PrimaryKey0 t   p x  PrimaryKey SkillDescripsskill_id@ 0 @ 0    @  0     skill_id`   ` ,   P skill_id 8  h    @ @p @  @ @ @ @ @ @ @ @  8   H  x    H  x (  8  @gruo,vljmmvgruo!ov}vda!ordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvf|`osmf{jwijppfukrjpvov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfd@ rG@rG@Example with Inner Joins77777777777 rG@rG@Skills Form***********  rG@rG@UserDefined***********  rG@rG@SummaryInfo***********  rG@rG@AccessLayout+++++++++++ rG@rG@SysRel%%%%%%%%%%% rG@rG@Scripts&&&&&&&&&&& rG@rG@Reports&&&&&&&&&&& rG@rG@Modules&&&&&&&&&&& rG@rG@Forms$$$$$$$$$$$ rG@rG@MSysRelationships22222222220 rG@rG@MSysQueries,,,,,,,,,,* rG@rG@MSysACEs))))))))))' rG@rG@MSysObjects,,,,,,,,,,* rG@rG@MSysDb''''''''''% JrG@JrG@Relationships.........., JrG@JrG@Databases**********( JrG@JrG@Tables''''''''''% VCN((   2idfname_HP(*x(+ id PrimaryKey('''44M$@ 64@(HDPdLTh<  `\4D(l%! $ THS__SRP_3rU t$`0 $)`4 p{q'BobHarry Joe')))('''44M$@ 64@(HDPdLTh<  `\4D(l%! $ THS__SRP_3rU t$`0 $)`4 p')))  O        IdParentIdNameType DateCreate DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtrasetni PPP Id ParentIdName        00-000000000046}#4.0#0#C:\Program Files\Common Files\Microsoft Shared\DAO\DAO350.DLL#Microsoft DAO 3.5 Object Library h4 Form_Form1 a3d1c8cdd*D (x g_q 6< MMSysDb#OVCN--   2skill_idskillPQ-/ -0 PrimaryKeyskill_idr CrG@CrG@qrySkills((((((((((( 'rG@CrG@names$$$$$$$$$$$ rG@rG@MSysModules2+++++++++++ rG@rG@MSysModules***********  rG@rG@Example with Inner Joins77777777777 rG@rG@Skills Form***********  rG@rG@UserDefined***********  rG@rG@SummaryInfo***********  rG@rG@AccessLayout+++++++++++ rG@rG@SysRel%%%%%%%%%%% rG@rG@Scripts&&&&&&&&&&& rG@rG@Reports&&&&&&&&&&& rG@rG@Modules&&&&&&&&&&& rG@rG@Forms$$$$$$$$$$$ rG@rG@MSysRelationships22222222220 rG@rG@MSysQueries,,,,,,,,,,* rG@rG@MSysACEs))))))))))' rG@rG@MSysObjects,,,,,,,,,,* rG@rG@MSysDb''''''''''% JrG@JrG@Relationships.........., JrG@JrG@Databases**********( JrG@JrG@Tables''''''''''% {q @ @ @ @                                      @ namesskillsnames.id = skills.id7  SkillDescrips.skill+ g  names.fname# g SkillDescrips  skills  names   G  G      names.fname# ' 2@ ' Skills2SkillDescrips_1+@."  namesSkills2@@,@@ @   vljmmvgruod`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvf|`osmf{jwijppfukrjpvov}v`bfvov}vordxmfvov}vordxmfvXov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsvp`ofvtu}vljmmv`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfdMS AccessOracle SQLVB,....r CrG@CrG@qrySkills((((((((((( 'rG@CrG@names$$$$$$$$$$$ rG@rG@MSysModules2+++++++++++ rG@rG@MSysModules***********  rG@rG@Example with Inner Joins77777777777 rG@rG@Skills Form***********  rG@rG@UserDefined***********  rG@rG@SummaryInfo***********  rG@rG@AccessLayout+++++++++++ rG@rG@SysRel%%%%%%%%%%% rG@rG@Scripts&&&&&&&&&&& rG@rG@Reports&&&&&&&&&&& rG@rG@Modules&&&&&&&&&&& rG@rG@Forms$$$$$$$$$$$ rG@rG@MSysRelationships22222222220 rG@rG@MSysQueries,,,,,,,,,,* rG@rG@MSysACEs))))))))))' rG@rG@MSysObjects,,,,,,,,,,* rG@rG@MSysDb''''''''''% JrG@JrG@Relationships.........., JrG@JrG@Databases**********( JrG@JrG@Tables''''''''''% ,....VCN22  idskill_idHP2425idskill_id{q 1i'Qm3wC 1<rG@<rG@skills%%%%%%%%%%% ,CrG@<rG@SkillDescrips,,,,,,,,,,,  CrG@CrG@qrySkills((((((((((( 'rG@CrG@names$$$$$$$$$$$ rG@rG@MSysModules2+++++++++++ rG@rG@MSysModules***********  rG@rG@Example with Inner Joins77777777777 rG@rG@Skills Form***********  rG@rG@UserDefined***********  rG@rG@SummaryInfo***********  rG@rG@AccessLayout+++++++++++ rG@rG@SysRel%%%%%%%%%%% rG@rG@Scripts&&&&&&&&&&& rG@rG@Reports&&&&&&&&&&& rG@rG@Modules&&&&&&&&&&& rG@rG@Forms$$$$$$$$$$$ rG@rG@MSysRelationships22222222220 rG@rG@MSysQueries,,,,,,,,,,* rG@rG@MSysACEs))))))))))' rG@rG@MSysObjects,,,,,,,,,,* rG@rG@MSysDb''''''''''% JrG@JrG@Relationships.........., JrG@JrG@Databases**********(1 @333333       IdParentIdNameType DateCreate DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtrasetni PPP Id ParentIdName        00-000000000046}#4.0#0#C:\Program Files\Common Files\Microsoft Shared\DAO\DAO350.DLL#Microsoft DAO 3.5 Object Library h4 Form_Form1 a3d1c8cdd*D (x g_q 6< MMSysDb#O1 @3333338.o`QB qbO@1"s`QB>/  ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Tۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o     ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o     ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o     ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   2LVALBN>,j]!&Snames Sskills2SSkillDescrips}J&Snames1SskillsgdSkillDescripsbeSkills2rgSkillDescrips_1ʾSkillDescripsqrySkillsSkills Form :9ALVAL NTZZZ#aKKDc RecordLocks ODBCTimeout MaxRecords RecordsetTypeFilKKD KeepLocal TKKD KeepLocal TKKDc RecordLocks ODBCTimeout MaxRecords RecordsetTypeFilterOrderBy OrderByOn Replicable1  <  KKDp OrderByOn ColumnWidth ColumnOrder ColumnHidden DecimalPlaces DefaultValueRequiredDisplayControl Tid      0  mZskill_id      0  mKKDd OrderByOn ColumnWidth ColumnOrder ColumnHiddenRequiredAllowZeroLengthDisplayControl 5skill_id   N skill      mKKDd OrderByOn ColumnWidth ColumnOrder ColumnHiddenRequiredAllowZeroLengthDisplayControl N fname      m/id   KKDW RecordLocks ODBCTimeout MaxRecords RecordsetTypeFilterOrderBy OrderByOn1  <  KKDTitleAuthorCompanyL skills  GE Consulting GE Capital ConsultingKKD AccessVersionBuildAppTitle StartUpFormStartUpShowDBWindowStartUpShowStatusBarStartUpMenuBarAllowShortcutMenusAllowFullMenusAllowBuiltInToolbarsAllowToolbarChangesAllowBreakIntoCodeAllowSpecialKeysAppIconStartupShortcutMenuBar  07.53   Skills Form            KKD KeepLocal TC~ok\MI:+' x  1<rG@<rG@skills%%%%%%  0%g/B($_A} KUn7inb?V#jKV#jKx6i\@AV#jKV#jKV#jKV#o     ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    1 1ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o 1 , ,ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ,    ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ' 'ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o '  ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   Tۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ;LVALGN  -]<yst`?@  A     2 SkillDescrips.skill_id SkillDescripsSkillDescrips.skill 6hsrG@ PS PSSkillDescripsX(HX 'w({@~sq_cSkills Form~sq_cList0   PS PSSkillDescrips      @HPX`                               @X `pX  |   `S( h  ( 0  ( X  SkillDescrips  0 skill_id PrimaryKeyH v P0@ s                               SkillDescrips PrimaryKey@ Px P@ X