Standard Jet DBnb` Ugr@?~1y0̝cßFNm7yҜ(7 `p{6߱SbC93y[#|*|(f_Љ$g'DeFx -bT4.0; Y[[S  Y   Y Y  Y Y  Y  Y  Y   Y u Y o Y n Y z Y 2lY  Y  z Y  pY ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeni4##4#44#YYIdParentIdName        OY[SYQ^OQ^Q`QbSY Y Y  Y 2MWACMFInheritableObjectIdSIDahd StYObjectId Y'0 0 S'Y  Y Y Y  Y \ Y Y  Y \AttributeExpressionFlagLvExtra Name1 Name2ObjectId Order\ Y"ObjectIdAttribute -Y7[[S7Y Y Y  Y  Y  Y  Y  Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship#4#4 4#ׂ#4#4 4#ׂ#4#4 4#ׂYYYszObject$szReferencedObjectszRelationshipCt/ `  L  } 8 l bN : B B" !"A"$"@IQUR(H1J)JDB EIQAHI@**Q$%JRJ"TI&@   @@jPZ%B hi+#U@xj[٪5^Uji/iUB $&@T* ow9HRBVj$$%&EU*TLo9@    hivJkiQkfdbkQS^dskYbM^oOQfid[QMmQbhivSobQ^Q`Qbmkfid[QMmschivYbmQiqYQsMQbmQikLvkQU`QbmhiviQfdim`fkd^OhiviikmJ\QiQ^JmQOhivkoffdimQObJmYdbJ^S^dsk + :FDJBLOL>@B8H:D:BQ?Q@sAsBsCsDsEsFsGsHsIs Js Ks Ls Ms NsOsPsQsRsSsTsUsVsWsXsYsZs[s\s]s^s_s`s as!bs"cdefghijkl m n o p qrstuvwxyz{|}~     !"#  !"#      !      !"# $ % & ' ()*+,-./0123456789:;<=>?@A B C D E FGHIJKLMNOA%+058=BDGMS{ !2"6#:$>%BDGDMDQDUDZDDDDD D D D D DDDDDDDDDD'D=D`DeDiDnDrDDD D!D"D#D$D%D&D'       #).28?IOU\`eilsx} !"#$%  J) 4* b,>,sZ     $%&'() * + , 7 8 9 : ; < = > ?        !"#$%&'()*+,-./0123456789:;<=>?@ A B C!D!E!F"G"H"I#J##$$$%%%&& & ' ' ' ((()))***+++,,,---. .!."/#/$/%0&0'0(1)1*1+2,2-2.3/303142434455565768696:7;7<7=8>8?8@9A9B9C:D:E:F;G;H;I<J<<===>>>?? ? @ @ @ AAABBBCCCDDDEEEFFFG G!G"H#H$H%I&I'I(J)J*J+K,K-K.L/L0L1M2M3M4N5N6N7O8O9O:P;P<P=Q>Q?Q@RARBRCSDSESFTG-./012 3 4 5!6!7!8"9":";#<#=#>$?$@$A%B%C%D&E&F&G'H'I'J(K(L(M)N)O)***+++,,, - - - . ..///00011122233344 4!5"5#5$6%6&6'7(7)7*8+8,8-9.9/90:1:2:3;4;5;6<7<8<9=:=;=<>=>>>??@?A?B@C@D@EAFAGAHBIBJBCCCDDDEEE F F F G GGHHHIIIJJJKKKLLLMM M!N"N#N$O%O&O'P(P)P*Q+Q,Q-R.R/R0S1S2S3T4T5T6IGH@ABCADAEAF  !"#  @ @ @ @ @I$NMO$TU+ YZ3]_9ik?opDu(wJz4|S.X]degf0n uy| (9( 79 % 27     &F=F>F?F@FAF5FBFDFEIIFCIIIIIII I I I I IIIII IIIIIIIIIIIIII I!II"I$I%I&I'I(I)I*I+I,I-I.I/I0I1I2 I3 I4 I5 I6I#I7I9I:I;I<I= I> I?I8KKKKKKKKK K K K K KKKKKKKKK KKKKKKKKKK K!K"K#K$K%K& K' K(KK)K+K,K-K.K*K/K1K2K3K4K5K6 K7 K8K0K9K;K<K=K>K? K@ KA KBK:KCKEKFKGKHKDMMMMMK@@@@@@@@@@@@@+ 6@SDMHMMQDD>FJ:>Q@LO6QD@BSMDL+ +;K[+ 8QMSLMOHDDJH>SO8J>LB8JJOMHBBB86L>QD6JJDLQLFQ@DQ>LLQM+ +;K[+ :FDJBLOL>@B8H:D:B>HJJFL><@68L8DQJH@>O+ +;K[+ 68Q@:6J68@S>LMMJS8SSFJ>:FBF@SMOFH>JFDJ@@:D+ +;K[+ >@DMDLFSLFOF>MQSHMD6MLM8Q>Q8F@6O+ +;K[+ >@FDBHDD>F6@>MDQLSO6>>>6JH@JQ<:MBJBSMSSD+ +;K[ + FH<LLDO6HMHO>8L6O@SQ8M6L+ +;K[ + H8QQ>JOSBQMJ>OBSHLBLL>JS@SFL@DJ6+ +;K[ + H>LO:@M>D:DML8B8LOQJLS:DHD<<@SHH6<:MDSM:MBD:Q:S+ +;K[+ J8QFSHFH>OD6HFQBMO@HS86S+ +;K[+ LB:@8<>8O6SQ>DSLFO@:LBLLJDL8>8MH+ +;K[+ LFH@:DL8H>8JQF@<8ODMLLOD>BJ+ +;K[+ MF@6FJ88M@DQ>SBMFQ6DO@FOHFBQJ6MB+ +;K[+ O@QJJ8HD@8FQ>F@JHMJ>8+ +;K[+ QBD@:HLOFO>S>J8@FFD66DJDOSLOJ68<+ +;K[+ SM@MH@F>>8B>SMF@S>88JO:OOJLO@MJLQFQO+ +;K[+ SSBQDHD8B8:H>Q8@FO>BB6J:OFD@@B:O+ +;K[mL^JUiQQ`QbmkmL^JUiQQ`Qbmkfid[QMmkmL^JUiQQ`QbmkmL^JUiQQ`QbmkkmJ\QWd^OQikmL^Jf^YbQkmv^QmL^Q^Q`QbmkmL^Jf^YbQkmv^QmL^fid[QMmYbSdi`JmYdb mL^Jf^YbQkmv^QmL^iQUYdbJ^kQiqYMQk mL^Jf^YbQkmv^QmL^iiJiQJkmJ\QWd^OQikiik mL^Q^Q`QbmkmL^QfJiMW mL^Q^Q`QbmkmL^QfQ^Q`QbmkiQhoYiQ`Qbmk mL^Q^Q`QbmkmL^kQ^QMmQOYbmQiMdbbQMmkmL^Q^Q`QbmkmL^kQ^QMmQOYbmQiMdbbQMmk8mL^QbmYmYQkmL^S^dsiQ^JmYdbkWYfkmL^QbmYmYQkmL^S^dsiQ^JmYdbkWYfk8mL^QfQ^Q`QbmkiQhoYiQ`QbmkmL^QfJiMWiQhoYiQ`QbmkmL^QhoYf`QbmfJM\JUQkmL^QfQ^Q`QbmkiQhoYiQ`QbmkmL^QhoYf`QbmfJM\JUQkmL^Qf`fkmL^QhoYf`QbmfJM\JUQkmL^Qffid[QMmkmL^QhoYf`QbmfJM\JUQkmL^QfiQhoYiQ`QbmkmL^`Ji\QmfJM\JUQkmL^Qf`fkmL^`Ji\QmfJM\JUQkmL^`Ji\QmfJM\JUQQ^Q`QbmkmL^`Ji\QmfJM\JUQkmL^`Ji\QmfJM\JUQfid[QMmkmL^`Ji\QmfJM\JUQkmL^iQUYdbJ^kQiqYMQkmL^`Ji\QmfJM\JUQkmL^iiJiQJ`fkmL^fid[QMmYbSdi`JmYdbmL^JUiQQ`Qbmkfid[QMmk mL^fid[QMmYbSdi`JmYdbmL^QfJiMWiQhoYiQ`Qbmk mL^iiJiQJkmJ\QWd^OQikiikmL^iiJiQJkmJ\QWd^OQik mL^iiJiQJkmJ\QWd^OQikmL^iiJiQJkmJ\QWd^OQikiik mL^iiJiQJkmL^iiJiQJ`fk mL^iiJiQJkmL^iiJiQJkmJ\QWd^OQikmL^kmJ\QWd^OQikmL^JUiQQ`QbmkkmJ\QWd^OQikmL^kmJ\QWd^OQikmL^iiJiQJkmJ\QWd^OQikY@ @ @  @@@@@@@mL^JUiQQ`Qbmkfid[QMmkmL^JUiQQ`Qbmkfid[QMmk mL^JUiQQ`QbmkkmJ\QWd^OQikmL^JUiQQ`QbmkkmJ\QWd^OQikmL^Q^Q`Qbm`JffYbUmL^Q^Q`Qbm`JffYbUmL^Q^Q`QbmkmL^QfJiMW mL^QfJiMWmL^QfJiMWiQhoYiQ`QbmkmL^QfJiMWiQhoYiQ`Qbmk mL^QfQ^Q`QbmkiQhoYiQ`Qbmk mL^QfQ^Q`QbmkiQhoYiQ`QbmkmL^Qf`fkmL^Qf`fkmL^QfiQhoYiQ`QbmkmL^SY^mQiQbmYmvM^JkkQkmL^SY^mQiQbmYmvmvfQkmL^SY^mQiS^dsSomoiYkmYMmL^SY^mQiS^dsmvfQk mL^S^dsiQ^JmYdbkWYfkmL^S^dsiQ^JmYdbkWYfkmL^YbmQiqYQsMQbmQikLvkQU`QbmmL^`Ji\QmfJM\JUQQ^Q`Qbmk mL^`Ji\QmfJM\JUQQ^Q`QbmkmL^`Ji\QmfJM\JUQfid[QMmkmL^`Ji\QmfJM\JUQfid[QMmkmL^dmWQiQbmYmYQkmL^dmWQiQbmYmYQk mL^fid[QMmJiMWYmQMmoiQ mL^fid[QMmJiMWYmQMmoiQmL^fid[QMmQ^Q`QbmkmL^fid[QMmQ^Q`QbmkmL^fid[QMmYbSdi`JmYdb mL^iQUYdbJ^JiMWYmQMmoiQmL^iQUYdbJ^JiMWYmQMmoiQ mL^iQUYdbJ^JiMWYmQMmoiQmL^iQUYdbJ^kQiqYMQk mL^iQUYdbJ^kQiqYMQkmL^iiJiQJ`fkmL^iiJiQJ`fk mL^iiJiQJkmJ\QWd^OQik mL^iiJiQJkmJ\QWd^OQikmL^iiJiQJkmJ\QWd^OQikmL^iiJiQJkmJ\QWd^OQikiik mL^iiJiQJkmJ\QWd^OQikiik mL^kQ^QMmQOYbmQiMdbbQMmkmL^kQ^QMmQOYbmQiMdbbQMmkmL^kmJ\QWd^OQiLdobOYbmQiSJMQkmL^kmJ\QWd^OQiLdobOYbmQiSJMQkmL^kmJ\QWd^OQiid^QkmL^kmJ\QWd^OQiid^QkmL^oOQbmYmvS^dskmL^oOQbmYmvS^dskmL^oOQbmYmvS^dsk  @@@@@@@@    @mL^JUiQQ`QbmkmL^JUiQQ`QbmkmL^Jf^YbQkmv^QmL^Jf^YbQkmv^Q mL^Jf^YbQkmv^Q mL^Jf^YbQkmv^Q mL^Q^Q`QbmkmL^Q^Q`Qbmk mL^Q^Q`Qbmk mL^Q^Q`QbmkmL^Q^Q`QbmkmL^Q^Q`QbmkmL^Q^Q`Qbmk mL^Q^Q`Qbmk mL^Q^Q`QbmkmL^Q^Q`QbmkmL^QbmYmYQkmL^QbmYmYQkmL^QbmYmYQkmL^QbmYmYQkmL^QbmYmYQk mL^QbmYmYQkmL^QbmYmYQkmL^QbmYmYQkmL^QbmYmYQkmL^QbmYmYQkmL^QbmYmYQkmL^QfQ^Q`QbmkiQhoYiQ`QbmkmL^QhoYf`QbmfJM\JUQkmL^QhoYf`QbmfJM\JUQkmL^QhoYf`QbmfJM\JUQkmL^QhoYf`QbmfJM\JUQkmL^S^dskmL^S^dskmL^S^dsk mL^S^dskmL^YbmQiqYQskQU`QbmkmL^`Ji\QmfJM\JUQkmL^`Ji\QmfJM\JUQkmL^`Ji\QmfJM\JUQkmL^`Ji\QmfJM\JUQkmL^`Ji\QmfJM\JUQkmL^fid[QMmYbSdi`JmYdbmL^fid[QMmYbSdi`JmYdbmL^fid[QMmYbSdi`JmYdbmL^fid[QMmYbSdi`JmYdb mL^fid[QMmYbSdi`JmYdb mL^iQUYdbJ^JiMWYmQMmoiQ mL^iiJiQJk mL^iiJiQJkmL^iiJiQJkmJ\QWd^OQik mL^iiJiQJkmJ\QWd^OQikiik mL^kmJ\QWd^OQikmL^kmJ\QWd^OQikmL^kmJ\QWd^OQik-*d _ Z g  ~K _ V HzztpFlXTDD40Bt(͂t(͂@t(͂TFa@}Fa@qryAPInterconnectsShowAllV@@l``TTTTTTTR @Ȥ6@6@qryAPInterconnectsFilteredV@\ @nbbVVVVVVVT @Ea@1Ea@qryAPInterconnectsEnumerateV@|@pddXXXXXXXV @Ea@Ea@qryAPInterconnectsBasicMinV'@|@nbbVVVVVVVT @Da@Da@qryAPInterconnectsBasicV@@h\\PPPPPPPN @Da@Da@qryAPInterconnectsV@@^RRFFFFFFFD @]NDa@]NDa@qryAPFlowsRegionShowAllIDSelectVY@@xll```````^ @Ca@Ca@qryAPFlowsRegionShowAllCountV'@ |@rffZZZZZZZX @Ca@Ca@qryAPFlowsRegionShowAllV@ @h\\PPPPPPPN @fBa@fBa@qryAPFlowsRegionRevV'@ @`TTHHHHHHHF @C]Ba@fBa@qryAPFlowsRegionIDSelectVY@@j^^RRRRRRRP @Aa@ Ba@qryAPFlowsRegionForV'@@`TTHHHHHHHF @٢Aa@٢Aa@qryAPFlowsRegionEnumerateV@`@l``TTTTTTTR @dAa@٢Aa@qryAPFlowsRegionCountVY@|@dXXLLLLLLLJ @&Aa@dAa@qryAPFlowsRegionBothV'@@bVVJJJJJJJH @ o@a@&Aa@qryAPFlowsRegionV@@ZNNBBBBBBB@ @,?q1@@q1@MSysAccessObjectsVDDDDDDDDDDB   HĔӇ@ ;`@AdminV/8,,,,,,,,,*  xH@xH@AutonumFixV66666666664  &e@&e@turbo data schemaVDDDDDDDDDDB  7ee@7ee@modSearchQueriesVBBBBBBBBBB@ עI@עI@modAutoNumFixV<<<<<<<<<<: e@e@Search QueriesVT@JJJ>>>>>>>< @Z@Z@SysRelV.........., Z@Z@ScriptsV0000000000. Z@Z@ReportsV0000000000. Z@Z@ModulesV0000000000. Z@Z@FormsV,,,,,,,,,,* Z@Z@DataAccessPagesV@@@@@@@@@@> c@c@MSysRelationshipsTDDDDDDDDDDB c@c@MSysQueriesT88888888886 c@c@MSysACEsT22222222220 c@c@MSysObjectsT88888888886 c@c@MSysDbVx@:::......., @c@c@RelationshipsT<<<<<<<<<<: c@c@DatabasesT44444444442 c@c@TablesT..........,  Y/   N//Y Y DataIDi Q@YAOIndexv1K[= 0ctLLS@LL0 P\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\` MSysAccounts xx`{pzxyMSysObjects^_TpT      xx^K[ࡱ> 7?948 '& !"#$%&(-)*+,./2013'.789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entryw LVBA w VBAProject  w VBA w dir_VBA_PROJECTFOHNFTHTMVZCIEJTACFTNBKRSJGN:BJRMVVPBLQMAEODKXFMRXDRLXLQUL:M  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLNOPQRSTUVWXYZ[\]^_`abcdfghijklmnopqrstuvwxyz{|}~鳀0* pHdblank back endD@  = Vz Z@A J<  rstdole>stdole( h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\System32\e2.tlb#OLE Automation0hADODB> ADOBD DE1D10-8DAA006D2(EA4D1DProgram Files\CommonsM\ado\ms21NMicrosoft ActiveX Data Objects 2.1 LibraryHDAO>DAр[ Y25EY00-5O,'Shared\\dao360.dll# 3.6-,[X>(ZXQZ6*w[UZn7^ZCGZx*@" Ext.W7 for DDL and SecuritDZ,modNumFiPxG3mdauoNumFix@FOHNFTHTMVZCIEJTACFTNBKRSJGN2,8ApH@FTHMVZCIEJANB@KRS@G A@ 1`B,.@!+BForm_Search QueriesGT&Fr_ earcQ s Qei`usJRMVVPBLQMAEODKXFMRXDRLXLQULFJVP@LUM%EDX$M XoRLX`QUFa`H "B({4f ;5S RVLNFHCXKKKZEEFREWPFDGRFCONR3L/F@/CK`K6E5FEWF*GF7OLɯ 5f=5am  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\ProK[gram Files\Microsoft Office\Office\MSACC9.OLB#Microsoft Access 9.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\System32\stdole2.tlb#OLE Automation*\G{00000201-0000-0010-8000-00AA006D2EA4}#2.1#0#C:\Program Files\Common Files\system\ado\msado21.tlb#Microsoft ActiveX Data Objects 2.1 Library*\G{00025E01-0000-0000-C000-000000000046}#5.0#0#C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll#Microsoft DAO 3.6 Object Library*\G{00000600-0000-0010-8000-00AA006D2EA4}#2.7#0#C:\Program Files\Common Files\System\ado\msadox.dll#Microsoft ADO Ext. 2.7 for DDL and Security ZA8FOHNFTHTMVZCIEJTACFTNBKRSJGN0141b59292modAutoNumFix@8JRMVVPBLQMAEODKXFMRXDRLXLQUL0241b59292U&Form_Search Queriesa8RVLNFHCXKKKZEEFREWPFDGRFCONL0341b59292b modSearchQueriesf=0 P0C"GF[ʶxI 킺 x'z@rYf{+_09;h,AccessVBAWin16~Win32MacVBA6#blank back endstdole`ADODBsDAOADOX modAutoNumFix _Evaluate AutoNumFixcatJ}Catalog#tblPTablecolHColumnivarMaxIDL "!l @*Is seed negative or below existing values?Seed "%>'(r[ "!][ ,]$B'&e ( ( &rog 'Offer the next available value above 0.a &$D '*Pro * l'*agak ,Get confirmation before changing this table.rl\ $$$'$Table: F , HField: F "! HMax:  F & HSeed:  FSeed "%> H HReset seed to  *?'. $ . L N $Alter the AutoNumber for this table?$J'0 0 P<Set the value. *Seed ",>o 2 '2$&Write a trail in the Immediate Window.a\[ , "! ( => *.COkkky!#Table can have only one AutoNumber.E;kp Next columnSkPkH)If the user chose Cancel, no more tables. 0 RIEyk Next table.Clean up.".. 2'iAttribute VB_Name = "modAutoNumFix" Option Compare Database`Explicit ` FuncZ() As Long 'Pu@rpose:Find aocally fix ales in current project` wherz; 'rnumber is negative or below actual v@alues.ReturnE xof?5 seed was rPesetpUto K[dialog: YW= change . NBoskipC ancel quit,archiDng*Not Re79fw 5Microsoft ADO Ext. library Dim cas NebwX.CP 6'oc HtblAkX.TableW'EachD1CNoG Column C field varMaxIDVaria@u 'Highest exis>t@C@i&lngOldSAcēfoundK @qU aft@k s,tr=S@ng MsgA4 '@Box messageH @1Answ@ 1 'Responso CK Ku'$B'C=t tC]Set.AveConFn@Ё= CCP j.g#'LooVhrough wrC? F`jBEItatEsaP= 0&Ikb l.TypTABLE" The`G'` viewO 3= T.1asyste "M@" A1~athe c"`6%%  %Ae% @.3perties(" increm")&,adInt"FAk'?"p+ V-& Q3:  YBs5&"phB (!5?Dn=lW,@No+QИ!, ?"Al{W$7$?Es2 vb1?'s!<)ezdZ=E8o( ~rpo??'Wria trH! Imme`Wow Debug`[iu%5,X,A ^`X =t'"]C ?;x x'rBn haanon|/#N^'oK'(ubsychoП1, no mQИ N+4jE7  iW'Cleanx up@ioZR2@oY~h]CĒ`"K01 U ME (S<S<S<<N0{A4338A1F-8E86-4DEA-9CB8-BE0F93AFB9BC}x Vh@%@@  "   0@X `pxx X(ZZC `$^'\I \RL Not Found'\@k  X(ZonAttribute VB_Name = "Form_Search Queries" Bas0{A4338A1F-8E86-4DEA-9CB8-BE0F93AFB9BC} |@GlobalSpacIFalse dCreataDblTru Predecla Id"Expo se_TemplateDqvCustomizD$Option Comp@ DT Priv+ Sub cmdFind_Click()  Screen.MousePo inter`11txtResults ( #&#If "" Then"3Not FoundǁEnd IffC T$  1  f=xRVLNFHCXKKKZEEFREWPFDGRFCONL:e PROJECT PROJECTwmAcessVBADataK[ME(<<< <Xj+^@(id fx% h%X, FB PXh  p    n $P "x  ,  H ( BH  L    ( 8 @ ` x   X  $ @ ` px?Searches stored SQL (procedures/queries) for a specified string]`$l.f h f!n act h!r'p p d ^ h! H'^k( h the following ADO code didn't work as well because only some querydefs are classified as "views" by ADO Dim rst As ADODB.Recordset Dim intColumn As Integer% On Error GoTo Error_SearchQueriesA Set rst = CurrentProject.Connection.OpenSchema(adSchemaViews) Do While Not rst.EOF; If InStr(1, rst("VIEW_DEFINITION"), strSearch) ThenF SearchQueries = SearchQueries & rst("TABLE_NAME") & vbCrLf End If' rst.MoveNext Loop Set rst = Nothing Exit FunctionError_SearchQueries: 'clean upQ MsgBox ("Error " & Err.Number & ": " & Err.Description & " in SearchQueries") If Not rst Is Nothing Then Set rst = Nothing End Ifi8Attribute VB_Name = "modSearchQueries" Option Compare Database 'Zes stored SQL (procedures/q) for a specifiPsng Public Fun6cg ~(% A(s S2)  Dim db!DAO., qdfyDef0On Err!Resu{Next Set(= CurrentDb() FEach-Inz.-sHZ= . If Inc(1,r ) Then%Ћ&0݀& vbCrLpEnd Ip ' thellowing ADO code didn't work as well because only soKtydefs Aclasst "views" byA 'c!grstbDB.Record se\intC olumn IntegerlGoTon_JB nAoProject.Conn.OpenSchema(adV.y$o While Not .EOFD"4 q@("VIEW_DEFINITION")u') r= &("TABLE_NAME") Gx)xH$.Move| Loop@7 Hh@@Ex|itp`@dK-:a'clean u MsgBox ("Ck" .Number": eDes(criÊ&in="1 -0 Is2e 6nC` !%E am  ID="{9F1F7BA8-C5D3-41E6-BE60-F49CDAAB6B9C}" Module=modAutoNumFix DocClass=Form_Search Queries/&H00000000 Module=modSearchQueries Name="blank back end" HelpContextID="0" VersionCompatible32="393222000" CMG="474505C00B405644564456445644" DPB="8E8CCC8954979A989A989A" GC="D5D7975E99A49AA49A5B" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VK[BE;&H00000000 [Workspace] modAutoNumFix=44, 44, 719, 513, Z Form_Search Queries=0, 0, 0, 0, C modSearchQueries=22, 29, 760, 442, C $P+modAutoNumFixmodAutoNumFixForm_Search QueriesForm_Search QueriesmodSearchQueriesmodSearchQueriesere `*,`. tab`00289=Babc`e ghij k ](Forms w w 0w w Blob  PropData@sBc .  USearch Queries Arial8 h\\RONS LAPTOP\HP4P4C odXXLetterDINU"4z==*HP LaserJet 4P\\RONS LAPTOP\HP4P\\RONS LAPTOP\HP4Pd2 Tahomahgh Tahomam45 Tahoma`h Detail+!Au3+m7UF`a,b,c,txtFind^t{NlBqnd5U`a,b+c Label1 Find: Y(kIvm27WF`aHb(c ktxtResultsFr>UfK}Ed5]`aHbc Label3Results:쉆CJhVdh1U`da,bNcnicmdFindFind"[Event Procedure]Quit App$ Oc8\np Next columnSkPkHͬ3MDetailmtxtFindTypeInfoBlobDelta[DirData &PropDataK[d Label1mtxtResultsd Label3h cmdFind{00020430-0000-0000-C000-0000dhmmdmdhb#OLE Automation Search Queries000-0010-8000 0CB0D2EA4}#2.1#0#C:\Program ommon Files\system\ado\mslb#Microsoft ActiveX DataCmdbarsw w Modules 'w w 0w w PropData PropDataCopy1w w PropData PropDataCopyDirDataJPropDataPropDataCopyReports%w w modAutoNumFix$modSearchQueries 0CB0 1CB0C 0CB0ʶxI 킺 x'z@rYf{+_9;h,AccessVBAWin16~WͬHRBvZXReportHeaderdLabel201dLabel202PageHeaderDetailfLine0fLine1gImage2gImage3f0"w w Blob 6PropData!# TypeInfo$       !"#$%()*+,-/2014356K[0:<=Babc3e ghXiJj18k6$cFV@ U8Relationships for turbo data Arial834hHP LaserJet 4P@gXXLetter 8 1/2 x 11 in@MSUDHP LaserJet 4P<d < winspoolHP LaserJet 4PLPT1:d28 Arialg37n7 Arial`ReportHeaderd8"bceLabel2018Relationships for turbo datadabcLabel202.Thursday, July 29, 1999`PageHeader`4 Detailf2`sab Line0f2`a b Line1g`a" bZcx Image2h(@@@@@@@@@@@@@@@g`a}bcK Image3x( P@@@@@@@K[@@@@@@@f`a b c. Line4f2`$a$ b Line5f2`#ab Line6f`#abcX Line7f2`$a/ b Line8f2`#ab Line9f`#abc Line10f2`+a5b Line11f2`#ab Line12g`7#a bZcxImage13h(@@@@@@@@@@@@@@@g`+abcKImage14x( P K[@@@@@@@@@@@@@@f`#abc Line15f2`2ab Line16f2`--aZb Line17g`Z-abZcxImage18h(@@@@@@@@@@@@@@@ K[g`72abcKImage19x( P@@@@@@@@@@@@@@f`--abcS Line20f2`'ab Line21f2`#ab Line22g`7#a bZcxImage23h(@@@@@@@@@@@@@@ K[@g`3'a:bcKImage24x( P@@@@@@@@@@@@@@f`#ab Line25f2`1aub Line26f2`--aZb Line27g`Z-abZcxImage28h(@@@@@@@@ K[@@@@@@@g`1a bcKImage29x( P@@@@@@@@@@@@@@f`--abFc Line30f2`ab Line31f2`ab Line32g`a bZcxImage33h(@@@@@@@@ K[@@@@@@@g`aCbcKImage34x( P@@@@@@@@@@@@@@K[f`abc  Line35f2`K-ab Line36f2`=,a7b Line37f`-ab-c Line38f2`Z-ab Line39f2`=,a b Line40f`-a b<c  Line41f2`a-b Line42f2` a.b Line43f` a-bc- Line44f2`a/b Line45f2`a#(b Line46g` a'bZcxImage47h(@@@@@@@@@@@@@@@g`av/bcKImage48x( P@@@@@@@@@@@@@K[@f` a2(bc Line49f2`a0b Line50f2`a(b Line51g` a_(bZcxImage52h(@@@@@@@@@@@@@@@g`aH0bcKImage53x( P@@@@@@@K[@@@@@@@f` a)bc Line54f2`a,b Line55f2`a2(b Line56f` a2(bc Line57f2`a&b Line58f2`a#(b Line59g` a'bZcxImage60h(@@@@@@@@@@@@@@@g`a&bcKImage61x( P@@@@@@@K[@@@@@@@f` a&bc Line62f2`aQ'b Line63f2`a(b Line64g` a_(bZcxImage65h(@@@@@@@@@@@@@@@K[g`a&bcKImage66x( P@@@@@@@@@@@@@@f` a`'bc Line67f2`sab Line68f2` awb Line69g` abZcxImage70h(@@@@@@@@@@@@@@@K[g`abcKImage71x( P@@@@@@@@@@@@@@f` a#b cc Line72f2`sab Line73f2` awb Line74g` abZcxImage75h(@@@@@@@@K[@@@@@@@g`a<bcKImage76x( P@@@@@@@@@@@@@@f` ab c Line77f2`ab Line78f2`paAb Line79g`abZcxImage80h(@@@@@@@@K[@@@@@@@g`abcKImage81x( P@@@@@@@@@@@@@@K[f`Q ab7c Line82f2`ab Line83f2`paAb Line84g`abZcxImage85h(@@@@@@@@@@@@@@@g` aTbcKImage86x( P@@@@@@@@@@@@@@K[f`abic Line87f2`sawb Line88f2`paAb Line89g`abZcxImage90h(@@@@@@@@@@@@@@@g`abcKImage91x( P@@@@@@@K[@@@@@@@f`Q aPb" c6 Line92f2`ab Line93f2`F#aO b Line94g`d#a bZcxImage95h(@@@@@@@@@@@@@@@g`aFbcKImage96x( P@@@@@@@K[@@@@@@@f`a^ bc` Line97f2`ab Line98f2`1 ab Line99g`O a bZcxImage100h(@@@@@@@@@@@@@@@g`a:bcKImage101x( P@@K[@@@@@@@@@@@@f` abLine102f2`abLine103f2`a bLine104g`a" bZcxImage105h(@@@@@@@@@@@@@@@K[g` abcKImage106x( P@@@@@@@@@@@@@@f`a bc3 Line107f2`a! bLine108f2`a bLine109g`a" bZcxImage110h(@@@@@@@@@@@@@@@K[g`a bcKImage111x( P@@@@@@@@@@@@@@f`a bciLine112f2`a bLine113f2`^abLine114g`|a[bZcxImage115h(@@@@@@@@K[@@@@@@@g`a bcKImage116x( P@@@@@@@@@@@@@@f`a bcLine117f2` abLine118f2`a bLine119g`a" bZcxImage120h(@@@@@@@@K[@@@@@@@g` aLbcKImage121x( P@@@@@@@@@@@@@@K[f`a bcLine122f2`)abLine123f2`abLine124g` a[bZcxImage125h(@@@@@@@@@@@@@@@g`GabcKImage126x( P@@@@@@@@@@@@@@ K[f`ab-cLine127f2`aubLine128f2`a bLine129g`a" bZcxImage130h(@@@@@@@@@@@@@@@g`a bcKImage131x( P@@@@@@@!K[@@@@@@@f`abcCLine132f2` abLine133f2`a bLine134g`a" bZcxImage135h(@@@@@@@@@@@@@@@g` aqbcKImage136x( P@@@@@@@"K[@@@@@@@f`abcLine137f2`F#a bLine138f2`%abLine139g`%aJbZcxImage140h(@@@@@@@@@@@@@@@#K[g`d#a\ bcKImage141x( P@@@@@@@@@@@@@@f`'$a bcLine142n07"aTbKcddecl0Value List߄"MarketPackage";"ProjectID";"Applicability";"Touched";"Comment";"" Tahomad238"`Tajbcecltitle0&tblRegionalServices Tahoman07"abIcdlecl1Value List<"StakeholderID";"ElementID";"" Tahomad238"`ahbcecltitle1&tblStakeholderRoles Tahoman07"abIcSdlecl2Value Listz"StakeholderID";"StakeholderName";"StakeholderDescription";"" Tahomad238"`ahbScecltitle2tblStakeholders Tahoman07"a{bIcd&lecl3Value List"EntityID";"EntityAbbreviation";"EntityName";"EntityDescription";"EntityKind";"EntityClass";"EntityType";"" Tahomad238"`{ahbcecltitle3tblEntities Tahoman07"aibUcdlecl4Value List>"RegionalFlowID";"ProjectID";"" Tahomad238"`iatbcecltitle4,tblProjectArchitecture Tahoman07"alb cd&lecl5Value List"RegionalFlowID";"SourceElementID";"DestinationElementID";"FlowID";"InRegionalArchitecture";"FlowStatus";"To$K[uched";"Comment";"" Tahomad238"`la bcecltitle5.tblRegionalArchitecture Tahoman07"a*bx-cCdlecl6Value Listߘ"WorkspaceModified";"CurrentTask";"CurrentArchitecture";"InterviewStatus";"" Tahomad238"`*a,bCcecltitle6(tblApplicationStatus Tahoman07"a&bdElecl7Value Listߞ"FlowID";"FlowName";"FlowDescription";"FlowKind";"FlowFuturistic";"FlowType";"" Tahomad238"`&abcecltitle7tblFlows Tahoman07"avb'cd lecl8Value List"QuestionCategory";"QuestionSequence";"QuestionNarrative";"QuestionHelp";"QuestionType";"ChoiceA";"ChoiceA2";"ActionA";"ArgumentA";"NarrativeBranchA";"ChoiceB";"ActionB";"ArgumentB";"NarrativeBranchB";"" Tahomad238"`va&bcecltitle8tblInterview Tahoman07"a b-cddl ecl9Value Listߌ"ActionID";"ActionStep";"ActionType";"ActionName";"ActionParameter";"" Tahomad238"` a,bcecltitle9&tblInterviewActions Tahoman07"a b/cdl ecl10Value Listx"QuestionCategory";"QuestionSequence";"CenterID";"Answer";"" Tahomad238"` a.bcecltitle10&tblInterviewAnswers Tahoman07"a b%&cdl ecl11Value Listp"CurrentCategory";"CurrentSequence";"CurrentCenterID";"" Tahomad238"` aD%bcecltitle11$tblInterviewStatus Tahoman07"ay,bdl ecl12Value List:"EntityID";"OtherEntityID";"" Tahomad238"`y,abcecltitle12 tblOtherEntities Tahoman07"a*b&cdl ecl13Value List߀"RegionalArchitectureExists";"RegionName";"RegionDescription";"" Tahomad238"`*a&bcecltitle13,tblRegionalInformation Tahoman07"a.bdl ecl14Value List"EntityID";"EntityAbbreviation";"EntityName";"EntityDescription";"EntityKind";"EntityClass";"EntityType";"" Tahomad238"`.abcecltitle14tblEntities_1 Tahoman07"a'bIc dl ecl15Value ListR"SourceEntityID";"DestinationEntityID";"" Tahomad238"`'ahb cecltitle15:tblStakeholderBoundInterfaces Tahoman07"am b[cdl ecl16Value ListV"SourceElementID";"DestinationElementID";"" Tahomad238"`m az bcecltitle160tblSelectedInterconnects Tahoman07"a b*c4dl ecl17Value List^"SegmentID";"SegmentName";"QuestionCategory";"" Tahomad238"` a*b4cecltitle17(tblIntervie%K[wSegments Tahoman07"abcdl ecl18Value Listf"ElementID";"EntityID";"AutoGenerated";"Touched";"" Tahomad238"`abcecltitle18"tblElementMapping Tahoman07"a bcdl ecl19Value List4"ElementID";"ProjectID";"" Tahomad238"` abcecltitle19$tblProjectElements Tahoman07"ahb^ cddl ecl20Value Listߔ"ElementID";"ElementName";"ElementDescription";"ElementStatus";"Center";"" Tahomad238"`ha} bcecltitle20tblElements Tahoman07"abddl ecl21Value Listߔ"ElementID";"ElementName";"ElementDescription";"ElementStatus";"Center";"" Tahomad238"`a bcecltitle21tblElements_1 Tahoman07"a%bcEdl ecl22Value List2"EntityClass";"Select";"" Tahomad238"`%abEcecltitle22,tblFilterEntityClasses Tahoman07"a%b crdl ecl23Value List0"EntityType";"Select";"" Tahomad238"`%a brcecltitle23(tblFilterEntityTypes Tahoman07"a,.bdl ecl24Value List8"FlowFuturistic";"Select";"" Tahomad238"`,.abcecltitle24.tblFilterFlowFuturistic Tahoman07"a;.bdl ecl25Value List,"FlowType";"Select";"" Tahomad238"`;.abcecltitle25$tblFilterFlowTypes Tahoman07"abcdl ecl26Value List߂"ProjectID";"ProjectName";"ProjectDescription";"ProjectStatus";"" Tahomad238"`abcecltitle26*tblProjectInformation Tahoman07"aTbc dl ecl27Value Listb"MarketPackage";"ElementID";"Select";"Touched";"" Tahomad238"`Tab cecltitle270tblMarketPackageElements Tahoman07"abcCdl ecl28Value List߂"MarketPackage";"MarketPackageName";"MarketPackageDescription";"" Tahomad238"`a<bCcecltitle28"tblMarketPackages Tahoma`PageFooter`hReportFooter      !"#$%&'()- Line4f Line5f Line6f Line7f Line8fLine9fLine10fLine11fLine12gIm&K[age13gImage14fLine15fLine16fLine17gImage18gImage19fLine20fLine21fLine22gImage23gImage24fLine25fLine26f Line27g!Image28g"Image29f#Line30f$Line31f%Line32g&Image33g'Image34f(Line35f)Line36f*Line37f+Line38f,Line39f-Line40f.Line41f/Line42f0Line43f1Line44f2Line45f3Line46g4Image47g5Image48f6Line49f7Line50f8Line51g9Image52g:Image53f;Line54f<Line55f=Line56f>Line57f?Line58f@Line59gAImage60gBImage61fCLine62fDLine63fELine64gFImage65gGImage66fHLine67fILine68fJLine69gKImage70gLImage71fMLine72fNLine73fOLine74gPImage75gQImage76fRLine77fSLine78fTLine79gUImage80gVImage81fWLine82fXLine83fYLine84gZImage85g[Image86f\Line87f]Line88f^Line89g_Image90g`Image91faLine92fbLine93fcLine94gdImage95geImage96ffLine97fgLine98fhLine99giImage100gjImage101fkLine102flLine103fmLine104gnImage105goImage106fpLine107fqLine108frLine109gsImage110gtImage111fuLine112fvLine113fwLine114gxImage115gyImage116fzLine117f{Line118f|Line119g}Image120g~Image121fLine122fLine123fLine124gImage125gImage126fLine127fLine128fLine129gImage130gImage131fLine132fLine133fLine134gImage135gImage136fLine137fLine138fLine139gImage140gImage141fLine142necl0decltitle0necl1decltitle1necl2decltitle2necl3decltitle3necl4decltitle4necl5decltitle5necl6decltitle6necl7decltitle7necl8decltitle8necl9decltitle9necl10decltitle10necl11decltitle11necl12decltitle12necl13decltitle13necl14decltitle14necl15decltitle15necl16decltitle16necl17decltitle17necl18decltitle18necl19decltitle19necl20decltitle20necl21decltitle21necl22decltitle22necl23decltitle23necl24decltitle24necl25decltitle25necl26decltitle26necl27decltitle27necl28decltitle28PageFooterReportFooterbbreviation";"EntityName"dgnddffggfffffffffggfffggfBlobDeltaDirData &*,PropData+Scripts/+w w ffggfff'K[ggfffggffffffffffffggfffggffffffggfffggfffggfffggfffggfffggfffggfffggfffggfffggfffggfffggfffggfffggfffggfffggfffggfndndndndndndndndndndndndndndndndndndndndndndndndndndndndnd;"ChoiceA2";"ActionA";"Argume&turbo data schema";"ChoiceB 0CB0onB";"ArgumentB";"Narrati33!AutoNumFix () erview TahoAutonumFixcl9Value Listߌ"A 0CB0;"ActionStep";"ActionTyp0)w w Blob *,jBlobDeltaDirData(,.PropData-/PropDataCopy0PropData1Databases.30w w  0CB0 1CB1e List߀"RegionalArcijists";"RegionName";"RMSysDbption";"" Tahomad238"`*a&bcecltitle13,tblRegionalInformation Tahoman07"a.bdl ecl14Value List"EntityID";"EntityAbbreviation";"EntityName";"EntityDescription";"EntityKind";"En021w w Blob DirData2CustomGroups4w w DataAccessPages w w (K[Root Entry@LVBA VBAProject  VBA       !"#$%()*+,-/2014356>'&(<:;ABCDEFGHIJKLMNOPQR=TUVWXYZ[\]^-)*+,./2013'.789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~dirPROJECT PROJECTwmAcessVBAData 0 [Workspace] modAutoNumFix=44, 44, 719, 513, Z Form_Search Queries=0, 0, 0, 0, C modSearchQueries=22, 29, 760, 442, C CmodAutoNumFixmodAutoNumFixForm_Search QueriesForm_Search QueriesmodSearchQueriesmodSearchQueriesriesmodSearchQueriesmodSearchQueriesere `*`. tab`00289=Babc`e ghij k ](1txtResults ( #&#If "" Then"3Not FoundǁEnd IffC T$  1 !%E am  ID="{9F1F7BA8-C5D3-41E6-BE60-F49CDAAB6B9C}" Module=modAutoNumFix DocClass=Form_Search Queries/&H00000000 Module=modSearchQueries Name="blank back end" HelpContextID="0" VersionCompatible32="393222000" CMG="656727CCE935ED35ED35ED35ED" DPB="CAC8886FEC70EC70EC" GC="2F2D6D0AB70A1D0B1D0BE2" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H0000000XRWSUEBKDMUKVDVXFKMKKTUVXQPE:SBGEAPOVNZEILYMDHTDMTWIYYDAIYC:REMSVVLFAXTSFESJVEUPMSAXQHZB:)K[M _VBA_PROJECT  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~賀0* pHdblank back endD@  = Vz Z@A J<  rstdole>stdole( h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\System32\e2.tlb#OLE Automation0hADODB> ADOBD DE1D10-8DAA006D2(EA4D1DProgram Files\CommonsM\ado\ms21NMicrosoft ActiveX Data Objects 2.1 LibraryHDAO>DAр[ Y25EY00-5O,'Shared\\dao360.dll# 3.6-,[X>(ZXQZ6*w[UZn7^ZCGZx*@" Ext.W7 for DDL and SecuritDZ,modNumFiPxG3mdauoNumFix@XRWSUEBKDMUKVDVXFKMKKTUVXQPE28ARWSUEBKMKV@VX@KMKTAQP# AH@1ݨBE,.@!B+BForm_Search QueriesG&Fr_earc s Qe i`usGEAPOVNZEILYMDHTDMTWIYYDAIYCUGA@O@NZILYUDTT@I%`YA!Ca`H "B(4fv 5S REMSVVLFAXTSFESJVEUPMSAXQHZBRM#VL3A@4TFSJE4PSBX`'H`B 5f=5am  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Program Files\Microsoft Office\OFFICE11\MSACC.OLB#Microsoft Access 11.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\System32\stdole2.tlb#OLE Automation*\G{00000201-0000-0010-8000-00AA006D2EA4}#2.1#0#C:\Program Files\Common Files\system\ado\msado21.tlb#Microsoft ActiveX Data Objects 2.1 Library*\G{00025E01-0000-0000-C000-000000000046}#5.0#0#C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll#Microsoft DAO 3.6 Object Library*\G{00000600-0000-0010-8000-00AA006D2EA4}#2.7#0#C:\Program Files\Common Files\System\ado\msadox.dll#Microsoft ADO Ext. 2.7 for DDL and Security ZA8XRWSUEBKDMUKVDVXFKMKKTUVXQPE024333cc82modAutoNumFix@8GEAPOVNZEILYMDHTDMTWIYYDAIYC034333cc82U&Form_Search Queriesa8REMSVVLFAXTSFESJVEUPMSAXQHZB044333cc82b modSearchQueriesf=0 P0*K[߬^Oqhy/J_M1XfOS09;h,AccessVBAWin16~Win32MacVBA6#blank back endstdole`ADODBsDAOADOX modAutoNumFix _Evaluate AutoNumFixcatJ}Catalog#tblPTablecolHColumnivarMaxID "!l @*Is seed negative or below existing values?Seed "%>'([ "!][ ,]$B'& ( ( & 'Offer the next available value above 0. &$D '* * '*k ,Get confirmation before changing this table. $$$'$Table: F , HField: F "! HMax:  F & HSeed:  FSeed "%> H HReset seed to  *?'. $ . L N $Alter the AutoNumber for this table?$J'0 0 P<Set the value. *Seed ",> 2 '2$&Write a trail in the Immediate Window.[ , "! ( => *kkky!#Table can have only one AutoNumber.kp Next columnkPkH)If the user chose Cancel, no more tables. 0 Ryk Next table.Clean up.".. 2'iAttribute VB_Name = "modAutoNumFix" Option Compare Database`Explicit ` FuncZ() As Long 'Pu@rpose:Find aocally fix ales in current project` wherz; 'rnumber is negative or below actual v@alues.ReturnE xof?5 seed was rPesetpUto dialog: YW= change . NBoskipC ancel quit,archiDng*Not Re79fw 5Microsoft ADO Ext. library Dim cas NebwX.CP 6'oc HtblAkX.TableW'EachD1CNoG Column C field varMaxIDVaria@u 'Highest exis>t@C@i&lngOldSAcēfoundK @qU aft@k s,tr=S@ng MsgA4 '@Box messageH @1Answ@ 1 'Responso CK Ku'$B'C=t tC]Set.AveConFn@Ё= CCP j.g#'LooVhrough wrC? F`jBEItatEsaP= 0&Ikb l.TypTABLE" The`G'` viewO 3= T.1asyste "M@" A1~athe c"`6%%  %Ae% @.3perties(" increm")&,adInt"FAk'?"p+ V-& Q3:  YBs5&"phB (!5?Dn=lW,@No+QИ!, ?"Al{W$7$?Es2 vb1?'s!<)ezdZ=E8o( ~rpo??'Wria trH! Imme`Wow Debug`[iu%5,X,A ^`X =t'"]C ?;x x'rBn haanon|-K[/#N^'oK'(ubsychoП1, no mQИ N+4jE7  iW'Cleanx up@ioZR2@oY~h]CĒ`"K01 U .y  @ @ @ @ @ @      !"#$%&'()*+,-./0 1!2"3#4$5%6&7'8(9):*;+<,=->.?S YNBBY u Y Y  Y  Y ڂ Y Id LValueObjectGuidObjectNameProperty ValueBCBDBEYYYId$ObjectGuidProperty$ObjectNamePropertyBHv1b  A A AFZ"~) O % C `  v X : ^ 4 fzpR4h>\ZHJ ? G ? G? ? G?@G '?tblRegionalArchitecturetblProjectArchitecture@Gwk? ?ArrowStyle13%% o?StatusIDD@G-!! o? tblRegionalArchitecture.FlowID= g?X@G g?N@G g?L@G g?tblProjectArchitecture=== ?tblRegionalArchitecture??? ? G? G? ? G?X7YZ_____2v@G1% 7?X7YZ_____1x@G1% 7? G ? G? ? G ?DN@G / ?F@G g?F@G g?CountN@G' o?qryAPFlowsRegionEnumerateCCC ? G? G? ? G?qryAPFlowsRegionForqryAPFlowsRegionRevv@ Gi]7 ?qryAPFlowsRegionForqryAPFlowsRegionRevn@ Gi]7 ?qryAPFlowsRegionForqryAPFlowsRegionRev@ Gi]7 ?qryAPFlowsRegionForqryAPFlowsRegionRev@ Gi]7 ?ArrowStyle23%% o?qryAPFlowsRegionFor.StatusID; g?qryAPFlowsRegionFor.FlowID9 g?P@ G g?F@G g?D@G g?qryAPFlowsRegionRev777 ?qryAPFlowsRegionFor777 ? G? G? ? G tblFlows.FlowName0 ' F@G ' tblAPEntities_1.EntityOrder: ' tblAPEntities.EntityOrder8 '  ~@G ' qryAPFlowsRegionIDSelecttblAPEntities@Gg[A  qryAPFlowsRegionIDSelecttblAPEntities_1@Gk_A  tblFlowsqryAPFlowsRegionIDSelectb@G]Q!  B@G g data flowtblFlows.FlowNameB## o F@G g DestinationIDtblAPEntities_1.EntityOrderT++ o SourceIDtblAPEntities.EntityOrderH!! o  qryAPFlowsRegionIDSelectAAA   tblAPEntitiestblAPEntities_1II+   tblAPEntities+++   tblFlows!!!   G  G    GLVALx < b * F l  0>^DjDqryAPFlowsRegionIDs.DestinationElementID = tblTmpSelectedElements_1.ElementIDqryAPFlowsRegionIDs.SourceElementID = tblTmpSelectedElements.ElementIDqryAPFlowsRegionIDs.DestinationElementIDqryAPFlowsRegionIDs.SourceElementIDSELECT * FROM qryAPFlowsRegionBoth((([Arch])=-1) AND ((tblRegionalArchitecture.InRegionalArchitecture)=True)) OR ((([Arch])>0) AND ((tblProjectArchitecture.ProjectID)=[Arch]))tblRegionalArchitecture.RegionalFlowID = tblProjectArchitecture.RegionalFlowIDtblRegionalArchitecture.FlowStatustblRegionalArchitecture.DestinationElementIDtblRegionalArchitecture.SourceElementIDtblRegionalArchitecture.RegionalFlowIDSELECT qryAPFlowsRegionIDSelect.DestinationElementID AS ElementID, qryAPFlowsRegionIDSelect.FlowID, qryAPFlowsRegionIDSelect.SourceElementID AS OtherElement FROM qryAPFlowsRegionIDSelectSELECT qryAPFlowsRegionIDSelect.SourceElementID AS ElementID, qryAPFlowsRegionIDSelect.FlowID, qryAPFlowsRegionIDSelect.DestinationElementID AS OtherElement FROM qryAPFlowsRegionIDSelect Count(qryAPFlowsRegionEnumerate.FlowID)qryAPFlowsRegionEnumerate.ElementIDqryAPFlowsRegionEnumerate.ElementIDCount(qryAPFlowsRegionEnumerate.FlowID)qryAPFlowsRegionFor.StatusID = qryAPFlowsRegionRev.StatusIDqryAPFlowsRegionFor.FlowID = qryAPFlowsRegionRev.FlowIDqryAPFlowsRegionFor.DestinationElementID = qryAPFlowsRegionRev.SourceElementIDqryAPFlowsRegionFor.SourceElementID = qryAPFlowsRegionRev.DestinationElementIDqryAPFlowsRegionFor.DestinationElementIDqryAPFlowsRegionFor.SourceElementIDqryAPFlowsRegionFor.RegionalFlowIDqryAPFlowsRegionIDSelect.ArrowStyle(((tblAPEntities_1.EntityOrder)<[tblAPEntities].[EntityOrder]))qryAPFlowsRegionIDSelect.SourceElementID = tblAPEntities.ElementIDqryAPFlowsRegionIDSelect.DestinationElementID = tblAPEntities_1.ElementIDtblFlows.FlowID = qryAPFlowsRegionIDSelect.FlowIDqryAPFlowsRegionIDSelect.StatusIDqryAPFlowsRegionIDSelect.ArrowStyleLVALvp$~:0p>lCount(qryAPFlowsRegionShowAllEnumerate.FlowID)qryAPFlowsRegionShowAllIDSelect.ArrowStyle(((tblAPEntities_1.EntityOrder)<[tblAPEntities].[EntityOrder]))qryAPFlowsRegionShowAllIDSelect.DestinationElementID = tblAPEntities_1.ElementIDqryAPFlowsRegionShowAllIDSelect.SourceElementID = tblAPEntities.ElementIDtblFlows.FlowID = qryAPFlowsRegionShowAllIDSelect.FlowIDqryAPFlowsRegionShowAllIDSelect.StatusIDqryAPFlowsRegionShowAllIDSelect.ArrowStyle(((tblRegionalArchitecture.InRegionalArchitecture)=True) AND (([Arch])=-1)) OR ((([Arch])>0) AND ((tblProjectArchitecture.ProjectID)=[Arch]))tblRegionalArchitecture.RegionalFlowID = tblProjectArchitecture.RegionalFlowIDtblRegionalArchitecture.FlowStatustblRegionalArchitecture.SourceElementIDtblRegionalArchitecture.DestinationElementIDtblRegionalArchitecture.RegionalFlowID(((tblTmpSelectedElements.ElementShow)=Yes) AND ((tblTmpSelectedElements_1.ElementShow)=Yes) AND ((qryFilteredFlows.FlowShow)=Yes))qryFilteredFlows.RegionalFlowID = qryAPFlowsRegionIDs.RegionalFlowIDSELECT qryAPFlowsRegionFor.* FROM qryAPFlowsRegionFor LEFT JOIN qryAPFlowsRegionBoth ON (qryAPFlowsRegionFor.StatusID = qryAPFlowsRegionBoth.StatusID) AND (qryAPFlowsRegionFor.FlowID = qryAPFlowsRegionBoth.FlowID) AND (qryAPFlowsRegionFor.DestinationElementID = qryAPFlowsRegionBoth.DestinationElementID) AND (qryAPFlowsRegionFor.SourceElementID = qryAPFlowsRegionBoth.SourceElementID) WHERE (((qryAPFlowsRegionBoth.SourceElementID) Is Null)) UNION SELECT qryAPFlowsRegionRev.* FROM qryAPFlowsRegionRev LEFT JOIN qryAPFlowsRegionBoth ON (qryAPFlowsRegionRev.StatusID = qryAPFlowsRegionBoth.StatusID) AND (qryAPFlowsRegionRev.FlowID = qryAPFlowsRegionBoth.FlowID) AND (qryAPFlowsRegionRev.DestinationElementID = qryAPFlowsRegionBoth.SourceElementID) AND (qryAPFlowsRegionRev.SourceElementID = qryAPFlowsRegionBoth.DestinationElementID) WHERE (((qryAPFlowsRegionBoth.SourceElementID) Is Null)) @fH* ~ r ,  .  ~ ` B X . h~`B*tJYQ'q4^* ?D\@J / ?T@J g?T@J g?Count\@H' o?qryAPFlowsRegionShowAllEnumerateQQQ ? G? G? ? G ?tblFlows.FlowName0 ' ?T@H ' ?tblAPEntities_1.EntityOrder: ' ?tblAPEntities.EntityOrder8 '?~@H '?qryAPFlowsRegionShowAllIDSelecttblAPEntities_1@ HymO ?qryAPFlowsRegionShowAllIDSelecttblAPEntities@ HuiO ?tblFlowsqryAPFlowsRegionShowAllIDSelectp@ Hk_! ?P@ H g?data flowtblFlows.FlowNameB## o?T@ H g?DestinationIDtblAPEntities_1.EntityOrderT++ o?SourceIDtblAPEntities.EntityOrderH!! o?qryAPFlowsRegionShowAllIDSelectOOO ?tblAPEntitiestblAPEntities_1II+ ?tblAPEntities+++ ?tblFlows!!! ? G? G? ? G?@H '?tblRegionalArchitecturetblProjectArchitecture@Hwk? ?ArrowStyle-15%% o?StatusIDD@H-!! o? tblRegionalArchitecture.FlowID= g?N@H g?X@H g?L@H g?tblProjectArchitecture=== ?tblRegionalArchitecture??? ? G? G? ? G ? qryAPFlowsRegionIDs.ArrowStyle= '?@H '?qryFilteredFlowsqryAPFlowsRegionIDs@HcW1 ?qryAPFlowsRegionIDstblTmpSelectedElements_1@Gsg7 ?qryAPFlowsRegionIDstblTmpSelectedElements@Goc7 ?qryAPFlowsRegionIDs.StatusID; g? qryAPFlowsRegionIDs.ArrowStyle= g?qryAPFlowsRegionIDs.FlowID9 g?P@G g?F@G g?qryFilteredFlows111 ?tblTmpSelectedElementstblTmpSelectedElements_1mm= ?tblTmpSelectedElements=== ?qryAPFlowsRegionIDs777 ? G? G? ? G?X7YZ_____2D@G1% 7?X7YZ_____1@H1% 7LVALXL X  | Z tV<FqryAPInterconnectsBasic.SourceElementIDMin(qryAPInterconnectsBasic.StatusOrder)qryAPInterconnectsBasic.DestinationElementIDqryAPInterconnectsBasic.SourceElementIDSELECT DISTINCT tblRegionalArchitecture.DestinationElementID, tblRegionalArchitecture.SourceElementID, tblStatus.StatusOrder FROM (tblStatus RIGHT JOIN tblRegionalArchitecture ON tblStatus.StatusID = tblRegionalArchitecture.FlowStatus) LEFT JOIN tblProjectArchitecture ON tblRegionalArchitecture.RegionalFlowID = tblProjectArchitecture.RegionalFlowID WHERE (((tblRegionalArchitecture.InRegionalArchitecture)=Yes) AND (([Arch])=-1)) OR ((([Arch])=[ProjectID])) (((tblAPEntities_1.EntityOrder)<[tblAPEntities].[EntityOrder]))qryAPInterconnectsFiltered.DestinationElementID = tblAPEntities_1.ElementIDqryAPInterconnectsFiltered.SourceElementID = tblAPEntities.ElementIDqryAPInterconnectsFiltered.[data flow]qryAPInterconnectsFiltered.StatusID(((tblTmpSelectedElements.ElementShow)=Yes) AND ((qryFilteredFlows.FlowShow)=Yes)) OR (((tblTmpSelectedElements_1.ElementShow)=Yes) AND ((qryFilteredFlows.FlowShow)=Yes))qryFilteredFlows.RegionalFlowID = qryAPFlowsRegionIDs.RegionalFlowIDqryAPFlowsRegionIDs.DestinationElementID = tblTmpSelectedElements_1.ElementIDqryAPFlowsRegionIDs.SourceElementID = tblTmpSelectedElements.ElementIDqryAPFlowsRegionIDs.DestinationElementIDqryAPFlowsRegionIDs.SourceElementIDSELECT qryAPFlowsRegionShowAllIDSelect.DestinationElementID AS ElementID, qryAPFlowsRegionShowAllIDSelect.FlowID, qryAPFlowsRegionShowAllIDSelect.SourceElementID AS OtherElement FROM qryAPFlowsRegionShowAllIDSelectSELECT qryAPFlowsRegionShowAllIDSelect.SourceElementID AS ElementID, qryAPFlowsRegionShowAllIDSelect.FlowID, qryAPFlowsRegionShowAllIDSelect.DestinationElementID AS OtherElement FROM qryAPFlowsRegionShowAllIDSelect Count(qryAPFlowsRegionShowAllEnumerate.FlowID)qryAPFlowsRegionShowAllEnumerate.ElementIDqryAPFlowsRegionShowAllEnumerate.ElementIDIJ P N $ j " & B $  x @ 4 (=~@>zP2PvX:?X7YZ_____2@L1% 7?X7YZ_____1@L1% 7? G ? G? ? G ?V@L ' ?Dd@L / ?V@L g?ElementIDV@L/## o?Countd@L' o?qryAPInterconnectsEnumerateGGG ? G? G? ? G ?X@L g ?N@J g?MinStatusOrderP@J9-- o?X@J g?N@J g?qryAPInterconnectsBasic??? ? G? G? ? G?X7YZ_____2@L1% 7?X7YZ_____1@J1% 7? G ? G? ? G ?tblAPEntities_1.EntityOrder: ' ?tblAPEntities.EntityOrder8 '?~@J '?qryAPInterconnectsFilteredtblAPEntities_1@JocE ?qryAPInterconnectsFilteredtblAPEntities@ Jk_E ?ArrowStyle03%% o?L@ J g?F@ J g?DestinationIDtblAPEntities_1.EntityOrderT++ o?SourceIDtblAPEntities.EntityOrderH!! o?tblAPEntitiestblAPEntities_1II+ ?tblAPEntities+++ ?qryAPInterconnectsFilteredEEE ? G? G? ? G ? qryAPFlowsRegionIDs.ArrowStyle= '?T@ J '?qryFilteredFlowsqryAPFlowsRegionIDs@ JcW1 ?qryAPFlowsRegionIDstblTmpSelectedElements_1@Jsg7 ?qryAPFlowsRegionIDstblTmpSelectedElements@Joc7 ?qryAPFlowsRegionIDs.StatusID; g? qryAPFlowsRegionIDs.ArrowStyle= g?qryAPFlowsRegionIDs.FlowID9 g?P@J g?F@J g?qryFilteredFlows111 ?tblTmpSelectedElementstblTmpSelectedElements_1mm= ?tblTmpSelectedElements=== ?qryAPFlowsRegionIDs777 ? G? G? ? G?X7YZ_____2@J1% 7?X7YZ_____1@J1% 7? G ? G? ? GLVALf  T D >XDBTTqryAPInterconnectsShowAllFiltered.[data flow]qryAPInterconnectsShowAllFiltered.StatusIDqryFilteredInteconnectTypes.SourceElementID=qryAPInterconnectsBasicMin.SourceElementIDqryFilteredInteconnectTypes.DestinationElementID=qryAPInterconnectsBasicMin.DestinationElementIDqryFilteredMarketPackageInterconnect.SourceElementID=qryAPInterconnectsBasicMin.SourceElementIDqryFilteredMarketPackageInterconnect.DestinationElementID=qryAPInterconnectsBasicMin.DestinationElementIDqryFilteredElements_1.ElementID=qryAPInterconnectsBasicMin.DestinationElementIDqryFilteredElements.ElementID=qryAPInterconnectsBasicMin.SourceElementIDtblFilterFlowDeployment.FlowDeployment=tblStatus.StatusIDqryAPInterconnectsBasicMin.MinStatusOrder=tblStatus.StatusOrdertblTmpSelectedElements.ElementID=qryAPInterconnectsBasicMin.SourceElementIDtblTmpSelectedElements_1.ElementID=qryAPInterconnectsBasicMin.DestinationElementIDqryFilteredElements_1.ElementShowqryAPInterconnectsBasicMin.DestinationElementIDqryAPInterconnectsBasicMin.SourceElementIDSELECT qryAPInterconnectsFiltered.DestinationElementID FROM qryAPInterconnectsFilteredSELECT qryAPInterconnectsFiltered.SourceElementID FROM qryAPInterconnectsFiltered qryAPInterconnectsEnumerate.SourceElementIDCount(qryAPInterconnectsEnumerate.SourceElementID)qryAPInterconnectsEnumerate.SourceElementIDqryAPInterconnectsEnumerate.SourceElementIDCount(qryAPInterconnectsEnumerate.SourceElementID)qryAPInterconnectsBasic.DestinationElementIDSELECT DISTINCT tblRegionalArchitecture.SourceElementID, tblRegionalArchitecture.DestinationElementID, tblStatus.StatusOrder FROM (tblStatus RIGHT JOIN tblRegionalArchitecture ON tblStatus.StatusID = tblRegionalArchitecture.FlowStatus) LEFT JOIN tblProjectArchitecture ON tblRegionalArchitecture.RegionalFlowID = tblProjectArchitecture.RegionalFlowID WHERE (((tblRegionalArchitecture.InRegionalArchitecture)=Yes) AND (([Arch])=-1)) OR ((([Arch])=[ProjectID]))3R~: * ~ T  a I o ckM_ UO1u ?qryAPInterconnectsShowAllEnumerateUUU  ? G ? G ?  ? G ?tblAPEntities_1.EntityOrder: ' ?tblAPEntities.EntityOrder8 '?~@P '?qryAPInterconnectsShowAllFilteredtblAPEntities_1@P}qS ?qryAPInterconnectsShowAllFilteredtblAPEntities@PymS ?ArrowStyle03%% o?Z@L g?T@L g?DestinationIDtblAPEntities_1.EntityOrderT++ o?SourceIDtblAPEntities.EntityOrderH!! o?qryAPInterconnectsShowAllFilteredSSS ?tblAPEntitiestblAPEntities_1II+ ?tblAPEntities+++ ? G? G? ? G?@P '? qryFilteredInteconnectTypesqryAPInterconnectsBasicMin@L{G ? qryFilteredInteconnectTypesqryAPInterconnectsBasicMin@L{G ?qryFilteredMarketPackageInterconnectqryAPInterconnectsBasicMin@LY ?qryFilteredMarketPackageInterconnectqryAPInterconnectsBasicMin@LY ?qryFilteredElements_1qryAPInterconnectsBasicMin@L{o; ?qryFilteredElementsqryAPInterconnectsBasicMin@Lwk7 ?tblFilterFlowDeploymenttblStatusr@L]Q? ?qryAPInterconnectsBasicMintblStatus~@LcWE ?tblTmpSelectedElementsqryAPInterconnectsBasicMin@ L}q= ?tblTmpSelectedElements_1qryAPInterconnectsBasicMin@ LuA ?B@ L g?!qryFilteredElements.ElementShow> g?data flow""3## o?tblStatus.StatusID1 g?^@ L g?T@ L g? tblStatus### ?qryAPInterconnectsBasicMinEEE ?tblTmpSelectedElementstblTmpSelectedElements_1mm= ?tblTmpSelectedElements=== ?tblFilterFlowDeployment??? ?qryFilteredElements777 ?qryFilteredElementsqryFilteredElements_1aa7 ?qryFilteredMarketPackageInterconnectYYY ?qryFilteredInteconnectTypesGGG ? G? ? GO @ @ @ @ @ @ @ @ @ @ @ @ @ @ F F F F F F F F F F F F F F F F  F  F  F  F FFFFFFFFFFFF F!F"F#F$FF%F'F(F)F*F+ F, F-F&F.F0F1F2F3F/F4F6F7F8F9F:F;F<F=F>F?F@FAF5FBFDFEIIFCIIIIIII I I I I IIIII IIIIIIIIIIIIII I!II"I$I%I&I'I(I)I*I+I,I-I.I/I0I1I2 I3 I4 I5 I6I#I7I9I:I;I<I= I> I?I8KKKKKKKKK K K K K KKKKKKKKK KKKKKKKKKK K!K"K#K$K%K& K' K(KK)K+K,K-K.K*K/K1K2K3K4K5K6 K7 K8K0K9K;K<K=K>K? K@ KA KBK:KCKEKFKGKHKDMMMMMKNU @ @ @ @ @ @ @ @ @ @ @ @ @ @I%I&I'I(I)I*I+I,I-I.I/I0I1I2 I3 I4 I5 I6I#I7I9I:I;I<I= I> I?I8KKKKKKKKK K K K K KKKKKKKKK KKKKKKKKKK K!K"K#K$K%K& K' K(KK)K+K,K-K.K*K/K1K2K3K4K5K6 K7 K8K0K9K;K<K=K>K? K@ KA KBK:KCKEKFKGKHKDMMMMMMMMM M  M M M MMMMMMMMMMMM M MMMMMM M!M"M#M$M%M&M'M(M)M*M+ M, M-M M. M0 M1 M2 R R  R  R M/!R!R!R!R!R !R"R "R "R "R"R"R"R"R"R"R"R" R"R"R"R"R"R"R"R"R"R"R "R!"R""R#" R$" R%"R&"R #R'#R)#R*#R+#R,#R-#R($R.$R0$R1$R2$R3$R4$R5$R6$R7$R8$T$T$T$R/vLVAL<   J  L.jR&vqryFilteredInteconnectTypes.DestinationElementID = qryAPInterconnectsBasicMin.DestinationElementIDqryFilteredInteconnectTypes.SourceElementID = qryAPInterconnectsBasicMin.SourceElementIDqryFilteredMarketPackageInterconnect.DestinationElementID = qryAPInterconnectsBasicMin.DestinationElementIDqryFilteredMarketPackageInterconnect.SourceElementID = qryAPInterconnectsBasicMin.SourceElementIDqryFilteredElements.ElementID = qryAPInterconnectsBasicMin.SourceElementIDqryFilteredElements_1.ElementID = qryAPInterconnectsBasicMin.DestinationElementIDtblFilterFlowDeployment.FlowDeployment = tblStatus.StatusIDqryAPInterconnectsBasicMin.MinStatusOrder = tblStatus.StatusOrdertblTmpSelectedElements.ElementID = qryAPInterconnectsBasicMin.SourceElementIDtblTmpSelectedElements_1.ElementID = qryAPInterconnectsBasicMin.DestinationElementIDqryFilteredMarketPackageInterconnect.MinOfMPFilterShowqryAPInterconnectsBasicMin.DestinationElementIDqryAPInterconnectsBasicMin.SourceElementIDSELECT qryAPInterconnectsShowAllFiltered.DestinationElementID FROM qryAPInterconnectsShowAllFilteredSELECT qryAPInterconnectsShowAllFiltered.SourceElementID FROM qryAPInterconnectsShowAllFiltered Count(qryAPInterconnectsShowAllEnumerate.SourceElementID)qryAPInterconnectsShowAllEnumerate.SourceElementIDqryAPInterconnectsShowAllEnumerate.SourceElementIDCount(qryAPInterconnectsShowAllEnumerate.SourceElementID)(((tblAPEntities_1.EntityOrder)<[tblAPEntities].[EntityOrder]))qryAPInterconnectsShowAllFiltered.DestinationElementID = tblAPEntities_1.ElementIDqryAPInterconnectsShowAllFiltered.SourceElementID = tblAPEntities.ElementID(((qryFilteredElements.ElementShow)=Yes) AND ((qryFilteredElements_1.ElementShow)=Yes) AND ((tblTmpSelectedElements_1.ElementShow)=True) AND ((tblTmpSelectedElements.ElementShow)=True) AND ((tblFilterFlowDeployment.[Select])=Yes) AND ((qryFilteredMarketPackageInterconnect.MinOfMPFilterShow)=Yes) AND ((qryFilteredInteconnectTypes.InterconnectShow)=Yes))X miOK 7 L z B >J & eaG%rnD4AQ??L΂@L΂@@qryCusTempAppendProje?9<@x<@@qryCusTempAppendProjectInterconnectsFilterVw@$ @vvvvvvvt @>RTؐ@/ڐ@@qryCusTempAppendProjectInterconnectsV@@vvjjjjjjjh @ <Fx@]۴@@qryCusTempAppendProjectFlowsV@@ @rffZZZZZZZX @;جHa@Ha@qryCusSelectCurrentProjectInterconnectsUniqueV@|@|||||||z @:جHa@جHa@qryCusSelectCurrentProjectInterconnectsV@@||pppppppn @9nHa@Hِ@qryCusSelectCurrentProjectFlowsV@@xll```````^ @ 7nGa@nGa@qryBatchSelectInterfacesBasicV@`@thh\\\\\\\Z @6KGa@KGa@qryBatchSelectInterfacesV'@@ @j^^RRRRRRRP @5zY;n@,Fn@0qryASResponseFlowsSetStatusProjectV*@@~rrfffffffd @4iAΑ@ VaQS@qryASResponseFlowsNotIncludedRegionVl@@tthhhhhhhf @32@U n@qryASResponseFlowsNotIncludedProjectV@@@vvjjjjjjjh @1mJ@nXБ@0qryASResponseFlowsIncludeRegionV@@xll```````^ @07#3@ n@@qryASResponseFlowsIncludeProjectV@@znnbbbbbbb` @/jБ@$nБ@0qryASResponseFlowsExcludeRegionV@@xll```````^ @.^5@ׯ:@qryASResponseFlowsExcludeProjectVW@@znnbbbbbbb` @-~@= n@qryASResponseFlowsAllV@@dXXLLLLLLLJ @+d6Α@LS@qryASRequestFlowsNotIncludedRegionV@@~rrfffffffd @*K"1@P n@qryASRequestFlowsNotIncludedProjectV@@tthhhhhhhf @)@)Б@@qryASRequestFlowsMissingAppendV@@vjj^^^^^^^\ @(/Ϸ@=3gБ@0qryASRequestFlowsIncludeRegionV@@vjj^^^^^^^\ @& \Б@y2@0qryASRequestFlowsExcludeRegionV\@@vjj^^^^^^^\ @%!:@y:@qryASRequestFlowsExcludeProjectV@@xll```````^ @$ظ@kn@qryASRequestFlowsAllV<@@bVVJJJJJJJH @#B7@/7@ qryASDeleteFlowsProjectVx@|@h\\PPPPPPPN @" :@H:@qryAPInterconnectsShowAllFilteredV@\ @|ppdddddddb @ Fa@Fa@qryAPInterconnectsShowAllCountV'@|@vjj^^^^^^^\ @9f:F(  < $ | > F LZ0b8P&Z>$?F@S g$?D@S g$?X@S g$?N@S g$?tblProjectArchitecture=== $?tblFlowRelationships999 $?tblRegionalArchitecture??? $?tblElementMapping333 $?tblElementMappingtblElementMapping_1YY3 $? $? G#?X@S '#?H@S g#?tblProjectArchitecture.*7 g#?tblProjectArchitecture=== #? G#? #? G"?@S '"? qryFilteredInteconnectTypesqryAPInterconnectsBasicMin@P{G "? qryFilteredInteconnectTypesqryAPInterconnectsBasicMin@P{G "?qryFilteredMarketPackageInterconnectqryAPInterconnectsBasicMin@PY "?qryFilteredMarketPackageInterconnectqryAPInterconnectsBasicMin@PY "?qryFilteredElementsqryAPInterconnectsBasicMin@Pwk7 "?qryFilteredElements_1qryAPInterconnectsBasicMin@P{o; "?tblFilterFlowDeploymenttblStatusv@P]Q? "?qryAPInterconnectsBasicMintblStatus@PcWE "?tblTmpSelectedElementsqryAPInterconnectsBasicMin@P}q= "?tblTmpSelectedElements_1qryAPInterconnectsBasicMin@ PuA "?l@ P g"?data flow""3## o"?tblStatus.StatusID1 g"?^@ P g"?T@ P g"? qryFilteredInteconnectTypesGGG "?qryFilteredMarketPackageInterconnectYYY "?qryFilteredElementsqryFilteredElements_1aa7 "?qryFilteredElements777 "?tblFilterFlowDeployment??? "?qryAPInterconnectsBasicMinEEE "?tblStatus### "?tblTmpSelectedElementstblTmpSelectedElements_1mm= "?tblTmpSelectedElements=== "? G"? G"? "? G!?X7YZ_____2@ P1% 7!?X7YZ_____1@P1% 7!? G! ? G!? !? G ?Dr@P / ?d@P g ?ElementIDd@P/## o ?Countr@P' o^LVAL 2 P dnXH :j[qryASResponseFlowsNotIncludedRegion].[DestinationElementID]=[tblRegionalArchitecture].[SourceElementID][qryASResponseFlowsNotIncludedRegion].[SourceElementID]=[tblRegionalArchitecture].[DestinationElementID][qryASResponseFlowsNotIncludedProject].[SourceElementID]=[tblRegionalArchitecture].[DestinationElementID][qryASResponseFlowsNotIncludedProject].[DestinationElementID]=[tblRegionalArchitecture].[SourceElementID][qryASResponseFlowsNotIncludedProject].[FlowIDRequest]=[tblRegionalArchitecture].[FlowID][tblRegionalArchitecture].[RegionalFlowID][qryASResponseFlowsNotIncludedProject].[ProjectID]tblRegionalArchitecture.RegionalFlowID=tblProjectArchitecture.RegionalFlowIDtblElementMapping_1.EntityID=tblFlowRelationships.EntityIDIFtblElementMapping_1.ElementID=tblRegionalArchitecture.DestinationElementIDtblFlowRelationships.FlowIDRequest=tblRegionalArchitecture.FlowIDtblElementMapping.EntityID=tblFlowRelationships.EntityIDtblElementMapping.ElementID=tblRegionalArchitecture.SourceElementIDtblRegionalArchitecture.FlowStatustblRegionalArchitecture.RegionalFlowIDtblRegionalArchitecture.InRegionalArchitecturetblFlowRelationships.FlowIDResponsetblFlowRelationships.FlowIDRequesttblRegionalArchitecture.DestinationElementIDtblRegionalArchitecture.SourceElementID((([tblProjectArchitecture].[ProjectID])=0))[tblProjectArchitecture].[ProjectID](((qryFilteredMarketPackageInterconnect.MinOfMPFilterShow)=True) AND ((tblTmpSelectedElements_1.ElementShow)=True) AND ((tblFilterFlowDeployment.[Select])=True) AND ((qryFilteredElements.ElementShow)=True) AND ((qryFilteredElements_1.ElementShow)=True) AND ((qryFilteredInteconnectTypes.InterconnectShow)=True)) OR (((qryFilteredMarketPackageInterconnect.MinOfMPFilterShow)=True) AND ((tblFilterFlowDeployment.[Select])=True) AND ((qryFilteredElements.ElementShow)=True) AND ((qryFilteredElements_1.ElementShow)=True) AND ((tblTmpSelectedElements.ElementShow)=True) AND ((qryFilteredInteconnectTypes.InterconnectShow)=True)).`6H J N 0  ` 6 l ,  n"\8j$J(n(?tblRegionalArchitecture.FlowStatusb@VaU w(?tblRegionalArchitecture??? (?qryASRequestFlowsNotIncludedRegionUUU (? G(? (? G'?z@V ''?qryASRequestFlowsNotIncludedProjecttblRegionalArchitecture@VW '?qryASRequestFlowsNotIncludedProjecttblRegionalArchitecture@VW '?qryASRequestFlowsNotIncludedProjecttblRegionalArchitecture@VW '?ProjectIDZ@V/# w'?RegionalFlowIDL@V9- w'?tblRegionalArchitecture??? '?qryASRequestFlowsNotIncludedProjectWWW '? G'?tblProjectArchitecture=== O'? '? G&?qryASResponseFlowsNotIncludedRegiontblRegionalArchitecture@VW &?qryASResponseFlowsNotIncludedRegiontblRegionalArchitecture@SW &?qryASResponseFlowsNotIncludedRegiontblRegionalArchitecture@SW &?tblRegionalArchitecture.InRegionalArchitectureNo}m w&?tblRegionalArchitecture??? &?qryASResponseFlowsNotIncludedRegionWWW &? G&? &? G%?qryASResponseFlowsNotIncludedProjecttblRegionalArchitecture@SY %?qryASResponseFlowsNotIncludedProjecttblRegionalArchitecture@SY %?qryASResponseFlowsNotIncludedProjecttblRegionalArchitecture@SY %?T@S g%?d@S g%?tblRegionalArchitecture??? %?qryASResponseFlowsNotIncludedProjectYYY %? %? G$?tblRegionalArchitecturetblProjectArchitecture@Swk? $?tblElementMapping_1tblFlowRelationshipsx@Sk_7 $?tblElementMapping_1tblRegionalArchitecture@ Sqe7 $?tblRegionalArchitecturetblFlowRelationships@ Ssg? $?tblElementMappingtblFlowRelationshipsp@ Sg[3 $?tblElementMappingtblRegionalArchitecture@ Sma3 $?D@ S g$?L@S g$?"tblProjectArchitecture.ProjectID? g$?\@S gOZ @ @ @ @ @ @ @ @ @ @ @ @ @ @MMMM M  M M M MMMMMMMMMMMM M MMMMMM M!M"M#M$M%M&M'M(M)M*M+ M, M-M M. M0 M1 M2 R R  R  R M/!R!R!R!R!R !R"R "R "R "R"R"R"R"R"R"R"R" R"R"R"R"R"R"R"R"R"R"R "R!"R""R#" R$" R%"R&"R #R'#R)#R*#R+#R,#R-#R($R.$R0$R1$R2$R3$R4$R5$R6$R7$R8$T$T$T$T$T$T$T$T$T$T $R/%T %T %T %T%T%T%T%T%T &T&T&T&T&T&T&T&T&T'T'T'T'T 'T!'T"'T#'T$'T%'T&'T''T(T((T*(T+(T,(T-(W(W(W(W(T))W)W)W)W)W )W )W )W )W )W)W)W)W*W*W*W*W*W*W*W*W*W*W*W*W*W*W*W * W!* W"* W#*W$*W%*W&*W'*W(*W)*W**W+*W,*W+W-+Y+Y+Y+Y+Y+Y+Y+Y+Y+Y +Y +Y +Y +Y +Y+Y+W.LVALPF   t  x04NTtblFlows.FlowID=qryASResponseFlowsAll.FlowIDRequesttblElements_1.ElementID=qryASResponseFlowsAll.SourceElementIDtblElements.ElementID=qryASResponseFlowsAll.DestinationElementIDqryASRequestFlowsAll.SourceElementID=qryASResponseFlowsAll.DestinationElementIDqryASRequestFlowsAll.DestinationElementID=qryASResponseFlowsAll.SourceElementIDqryASRequestFlowsAll.FlowIDRequest=qryASResponseFlowsAll.FlowIDRequestqryASRequestFlowsAll.ProjectID=qryASResponseFlowsAll.ProjectIDqryASResponseFlowsAll.FlowIDResponse((([tblRegionalArchitecture].[SourceElementID]) Is Null) And (([tblRegionalArchitecture].[DestinationElementID]) Is Null) And (([tblRegionalArchitecture].[FlowID]) Is Null))[qryASResponseFlowsAll].[SourceElementID]=[tblRegionalArchitecture].[DestinationElementID][qryASResponseFlowsAll].[DestinationElementID]=[tblRegionalArchitecture].[SourceElementID][qryASResponseFlowsAll].[FlowIDRequest]=[tblRegionalArchitecture].[FlowID][qryASResponseFlowsAll].[FlowStatus][qryASResponseFlowsAll].[FlowIDRequest][qryASResponseFlowsAll].[SourceElementID][qryASResponseFlowsAll].[DestinationElementID][qryASRequestFlowsNotIncludedRegion].[FlowID]=[tblRegionalArchitecture].[FlowID][qryASRequestFlowsNotIncludedRegion].[DestinationElementID]=[tblRegionalArchitecture].[DestinationElementID][qryASRequestFlowsNotIncludedRegion].[SourceElementID]=[tblRegionalArchitecture].[SourceElementID][qryASRequestFlowsNotIncludedRegion].[FlowStatus](((qryASRequestFlowsNotIncludedProject.ProjectID)=[Project]))qryASRequestFlowsNotIncludedProject.SourceElementID = tblRegionalArchitecture.SourceElementIDqryASRequestFlowsNotIncludedProject.DestinationElementID = tblRegionalArchitecture.DestinationElementIDqryASRequestFlowsNotIncludedProject.FlowID = tblRegionalArchitecture.FlowIDqryASRequestFlowsNotIncludedProject.ProjectIDtblRegionalArchitecture.RegionalFlowID[qryASResponseFlowsNotIncludedRegion].[FlowIDRequest]=[tblRegionalArchitecture].[FlowID]/u= e  = w s I  S UL(V+? +? G*?@X '*?tblFlows_1qryASResponseFlowsAlll@X[O% *?tblFlowsqryASResponseFlowsAllf@VWK! *?tblElements_1qryASResponseFlowsAllz@VaU+ *?tblElementsqryASResponseFlowsAll@V]Q' *?qryASRequestFlowsAllqryASResponseFlowsAll@Voc9 *?qryASRequestFlowsAllqryASResponseFlowsAll@Voc9 *?qryASRequestFlowsAllqryASResponseFlowsAll@Voc9 *?qryASRequestFlowsAllqryASResponseFlowsAll|@Voc9 *? !qryASResponseFlowsAll.ProjectID> g*? "qryASResponseFlowsAll.FlowStatus? g*? CorrespondingFlowNametblFlows_1.FlowName\;; o*?CorrespondingFlowIDtblFlows_1.FlowIDV77 o*?H@V g*?tblFlows.FlowName0 g*?tblFlows.FlowID. g*?DestinationNametblElements_1.ElementNameV// o*?DestinationElementIDtblElements_1.ElementID^99 o*?SourceNametblElements.ElementNameJ%% o*?SourceElementIDtblElements.ElementIDR// o*?qryASResponseFlowsAll;;; *?qryASRequestFlowsAll999 *?tblElements''' *?tblElementstblElements_1AA' *?tblFlows!!! *?tblFlowstblFlows_155! *? *? G)?Z@V ')?qryASResponseFlowsAlltblRegionalArchitecture@Vui; )?qryASResponseFlowsAlltblRegionalArchitecture@Vui; )?qryASResponseFlowsAlltblRegionalArchitecture@Vui; )?FlowStatusH@V1% w)?FlowIDN@ V) w)?DestinationElementIDR@ VE9 w)?SourceElementID\@ V;/ w)?tblRegionalArchitecture??? )?qryASResponseFlowsAll;;; )?tblRegionalArchitecture??? O)? )? G(?qryASRequestFlowsNotIncludedRegiontblRegionalArchitecture@ VU (?qryASRequestFlowsNotIncludedRegiontblRegionalArchitecture@ VU (?qryASRequestFlowsNotIncludedRegiontblRegionalArchitecture@VU (?tblRegionalArchitecture.InRegionalArchitectureYes~m wLVAL R b 2 T X p^.BV*tblElementMapping_1.ElementID=tblRegionalArchitecture.SourceElementIDtblElementMapping.ElementID=tblRegionalArchitecture.DestinationElementIDtblElementMapping_1.EntityID=tblFlowRelationships.EntityIDIFtblElementMapping.EntityID=tblFlowRelationships.EntityIDtblRegionalArchitecture.FlowStatustblRegionalArchitecture.RegionalFlowIDtblRegionalArchitecture.InRegionalArchitecturetblFlowRelationships.FlowIDRequesttblFlowRelationships.FlowIDResponsetblRegionalArchitecture.DestinationElementIDtblRegionalArchitecture.SourceElementID(((qryASRequestFlowsNotIncludedProject.ProjectID)=[Project]) AND ((tblRegionalArchitecture.FlowStatus)=0))qryASRequestFlowsNotIncludedProject.FlowID=tblRegionalArchitecture.FlowIDqryASRequestFlowsNotIncludedProject.DestinationElementID=tblRegionalArchitecture.DestinationElementIDqryASRequestFlowsNotIncludedProject.SourceElementID=tblRegionalArchitecture.SourceElementIDqryASRequestFlowsNotIncludedProject.flowstatus(((tblRegionalArchitecture.InRegionalArchitecture)=False) AND ((qryASResponseFlowsAll.InRegionalArchitecture)=True))tblElements_1.ElementID = tblRegionalArchitecture.DestinationElementIDtblFlows_1.FlowID = qryASResponseFlowsAll.FlowIDResponsetblFlows.FlowID = tblRegionalArchitecture.FlowIDtblElements.ElementID = tblRegionalArchitecture.SourceElementIDqryASResponseFlowsAll.FlowIDRequest = tblRegionalArchitecture.FlowIDqryASResponseFlowsAll.DestinationElementID = tblRegionalArchitecture.SourceElementIDqryASResponseFlowsAll.SourceElementID = tblRegionalArchitecture.DestinationElementIDqryASResponseFlowsAll.FlowIDResponsetblRegionalArchitecture.DestinationElementIDtblRegionalArchitecture.SourceElementID(((qryASRequestFlowsAll.ProjectID) Is Null) And ((qryASRequestFlowsAll.SourceElementID) Is Null) And ((qryASRequestFlowsAll.DestinationElementID) Is Null) And ((qryASRequestFlowsAll.FlowIDRequest) Is Null))tblFlows_1.FlowID=qryASResponseFlowsAll.FlowIDResponseq44> I ] 3 g c s 1ISmOcyO%[-?tblElementMappingtblFlowRelationshipsp@Xg[3 -?D@X g-?L@X g-?"tblProjectArchitecture.ProjectID? g-?\@X g-?D@X g-?F@X g-?X@X g-?N@X g-?tblProjectArchitecture=== -?tblRegionalArchitecture??? -?tblFlowRelationships999 -?tblElementMapping333 -?tblElementMappingtblElementMapping_1YY3 -? -? G,?@X ',?qryASRequestFlowsNotIncludedProjecttblRegionalArchitecture@XW ,?qryASRequestFlowsNotIncludedProjecttblRegionalArchitecture@XW ,?qryASRequestFlowsNotIncludedProjecttblRegionalArchitecture@XW ,?tblRegionalArchitecture.FlowStatus\@ XaU w,?tblRegionalArchitecture??? ,?qryASRequestFlowsNotIncludedProjectWWW ,? G,? ,? G+?@ X '+?tblElements_1tblRegionalArchitecture@ XeY+ +?tblFlows_1qryASResponseFlowsAllp@ X[O% +?tblFlowstblRegionalArchitecture`@ X[O! +?tblElementstblRegionalArchitecture~@XaU' +?qryASResponseFlowsAlltblRegionalArchitecture@Xui; +?qryASResponseFlowsAlltblRegionalArchitecture@Xui; +?qryASResponseFlowsAlltblRegionalArchitecture@Xui; +? CorrespondingFlowNametblFlows_1.FlowName\;; o+? CorrespondingFlowIDtblFlows_1.FlowIDV77 o+?H@X g+?"qryASResponseFlowsAll.FlowStatus? g+?tblFlows.FlowName0 g+?DestinationNametblElements_1.ElementNameV// o+?SourceNametblElements.ElementNameJ%% o+? tblRegionalArchitecture.FlowID= g+?X@X g+?N@X g+?tblRegionalArchitecture??? +?qryASResponseFlowsAll;;; +?tblElements''' +?tblFlows!!! +?tblElementstblElements_1AA' +?tblFlowstblFlows_155! +? G+? GU_ @ @ @ @ @ @ @ @ @ @ @ @ @ @$T$T$T$T$T$T $R/%T %T %T %T%T%T%T%T%T &T&T&T&T&T&T&T&T&T'T'T'T'T 'T!'T"'T#'T$'T%'T&'T''T(T((T*(T+(T,(T-(W(W(W(W(T))W)W)W)W)W )W )W )W )W )W)W)W)W*W*W*W*W*W*W*W*W*W*W*W*W*W*W*W * W!* W"* W#*W$*W%*W&*W'*W(*W)*W**W+*W,*W+W-+Y+Y+Y+Y+Y+Y+Y+Y+Y+Y +Y +Y +Y +Y +Y+Y+ Y+ Y+Y+Y+Y+Y+Y+Y+Y+Y+W.,Y,Y,Y,Y,Y,Y ,Y!,Y",Y#,Y-Y$-Y&-Y'-Y(-Y)-Y*-Y+-Y,-Y--Y.-Y/-Y0-Y1-Y2-Y3-[-[-[-[-[-Y%.[.[.[.[ .[ .[ .[ .[ .[/[/[/[/[/[/[/[/[/[/[0[0[0[0[0[0[0[0[ 0[!0["0[#0[1[$1[&1['1[(1[)1[*1[+1]1]1[%2]2]2]2]2]2]2] 2] 2] 2] 2] 2]2]2]3]3]3]3]3]3]3]3]3]3], n P v L  r T 6  L &hJRv6 N k1qryASResponseFlowsNotIncludedRegiontblRegionalArchitecture@\W 1tblRegionalArchitecture.InRegionalArchitectureYes~m w1tblRegionalArchitecture.FlowStatusd@\aU w1tblRegionalArchitecture??? 1qryASResponseFlowsNotIncludedRegionWWW 1 G1 1 G0 |@\ '0qryASResponseFlowsNotIncludedProjecttblRegionalArchitecture@\Y 0qryASResponseFlowsNotIncludedProjecttblRegionalArchitecture@ \Y 0qryASResponseFlowsNotIncludedProjecttblRegionalArchitecture@ \Y 0ProjectID\@ \/# w0RegionalFlowIDL@ \9- w0 tblRegionalArchitecture??? 0 qryASResponseFlowsNotIncludedProjectYYY 0 G0tblProjectArchitecture=== O0  0 G/?qryASRequestFlowsNotIncludedRegiontblRegionalArchitecture@ \U /?qryASRequestFlowsNotIncludedRegiontblRegionalArchitecture@\U /?qryASRequestFlowsNotIncludedRegiontblRegionalArchitecture@\U /?tblRegionalArchitecture.InRegionalArchitectureNo}m w/?tblRegionalArchitecture??? /?qryASRequestFlowsNotIncludedRegionUUU /? G/? G/? /? G.?qryASRequestFlowsNotIncludedProjecttblRegionalArchitecture@\W .?qryASRequestFlowsNotIncludedProjecttblRegionalArchitecture@\W .?qryASRequestFlowsNotIncludedProjecttblRegionalArchitecture@\W .?b@\ g.?T@\ g.?tblRegionalArchitecture??? .?qryASRequestFlowsNotIncludedProjectWWW .? .? G-?tblRegionalArchitecturetblProjectArchitecture@\wk? -?tblFlowRelationshipstblRegionalArchitecture@\sg9 -?tblElementMapping_1tblRegionalArchitecture@Xqe7 -?tblElementMappingtblRegionalArchitecture@Xma3 -?tblElementMapping_1tblFlowRelationshipsx@Xk_7 LVAL|.^  X h Plft,^qryASRequestFlowsAll.SourceElementID = tblRegionalArchitecture.DestinationElementIDqryASRequestFlowsAll.DestinationElementID = tblRegionalArchitecture.SourceElementIDqryASRequestFlowsAll.FlowIDResponse = tblRegionalArchitecture.FlowIDqryASRequestFlowsAll.FlowIDResponseqryASRequestFlowsAll.SourceElementIDqryASRequestFlowsAll.DestinationElementID[qryASResponseFlowsNotIncludedRegion].[SourceElementID]=[tblRegionalArchitecture].[SourceElementID][qryASResponseFlowsNotIncludedRegion].[DestinationElementID]=[tblRegionalArchitecture].[DestinationElementID][qryASResponseFlowsNotIncludedRegion].[FlowID]=[tblRegionalArchitecture].[FlowID][qryASResponseFlowsNotIncludedRegion].[FlowStatus](((qryASResponseFlowsNotIncludedProject.ProjectID)=[Project]))qryASResponseFlowsNotIncludedProject.FlowID = tblRegionalArchitecture.FlowIDqryASResponseFlowsNotIncludedProject.DestinationElementID = tblRegionalArchitecture.DestinationElementIDqryASResponseFlowsNotIncludedProject.SourceElementID = tblRegionalArchitecture.SourceElementIDqryASResponseFlowsNotIncludedProject.ProjectIDtblRegionalArchitecture.RegionalFlowIDqryASRequestFlowsNotIncludedRegion.FlowIDResponse = tblRegionalArchitecture.FlowIDqryASRequestFlowsNotIncludedRegion.DestinationElementID = tblRegionalArchitecture.SourceElementIDqryASRequestFlowsNotIncludedRegion.SourceElementID = tblRegionalArchitecture.DestinationElementID[qryASRequestFlowsNotIncludedProject].[FlowIDResponse]=[tblRegionalArchitecture].[FlowID][qryASRequestFlowsNotIncludedProject].[DestinationElementID]=[tblRegionalArchitecture].[SourceElementID][qryASRequestFlowsNotIncludedProject].[SourceElementID]=[tblRegionalArchitecture].[DestinationElementID][qryASRequestFlowsNotIncludedProject].[ProjectID][tblRegionalArchitecture].[RegionalFlowID]tblRegionalArchitecture.RegionalFlowID=tblProjectArchitecture.RegionalFlowIDtblFlowRelationships.FlowIDResponse=tblRegionalArchitecture.FlowID3b< D ] ] w 5  ? As8#pxJ~`B4tblFlows!!! 4tblElementstblElements_1AA' 4tblFlowstblFlows_155! 4 G4 G4 4 G3@ ^ '3tblFlows_1qryASRequestFlowsAllh@ ^YM% 3tblFlowsqryASRequestFlowsAllf@^UI! 3tblElements_1qryASRequestFlowsAllx@^_S+ 3tblElementsqryASRequestFlowsAll~@^[O' 3qryASRequestFlowsAllqryASResponseFlowsAll@^oc9 3qryASRequestFlowsAllqryASResponseFlowsAll@^oc9 3qryASRequestFlowsAllqryASResponseFlowsAll@^oc9 3qryASRequestFlowsAllqryASResponseFlowsAll|@^oc9 3 qryASRequestFlowsAll.ProjectID= g3 CorrespondingFlowNametblFlows_1.FlowName\;; o3 CorrespondingFlowIDtblFlows_1.FlowIDV77 o3D@^ g3!qryASRequestFlowsAll.FlowStatus> g3tblFlows.FlowName0 g3tblFlows.FlowID. g3DestinationNametblElements_1.ElementNameV// o3DestinationElementIDtblElements_1.ElementID^99 o3SourceNametblElements.ElementNameJ%% o3SourceElementIDtblElements.ElementIDR// o3qryASResponseFlowsAll;;; 3qryASRequestFlowsAll999 3tblElements''' 3tblElementstblElements_1AA' 3tblFlows!!! 3tblFlowstblFlows_155! 3 3 G2B@^ '2qryASRequestFlowsAlltblRegionalArchitecture@\sg9 2qryASRequestFlowsAlltblRegionalArchitecture@\sg9 2qryASRequestFlowsAlltblRegionalArchitecture@\sg9 2FlowStatus!qryASRequestFlowsAll.FlowStatusR% w2FlowIDF@\) w2DestinationElementIDH@\E9 w2SourceElementIDR@\;/ w2tblRegionalArchitecture??? 2qryASRequestFlowsAll999 2 G2tblRegionalArchitecture??? O2 2 G1qryASResponseFlowsNotIncludedRegiontblRegionalArchitecture@\W 1qryASResponseFlowsNotIncludedRegiontblRegionalArchitecture@\W LVALz ` 2 < n |$X .6P^qryASResponseFlowsNotIncludedProject.SourceElementID=tblRegionalArchitecture.SourceElementIDqryASResponseFlowsNotIncludedProject.DestinationElementID=tblRegionalArchitecture.DestinationElementIDqryASResponseFlowsNotIncludedProject.FlowID=tblRegionalArchitecture.FlowIDqryASResponseFlowsNotIncludedProject.FlowStatus(((tblRegionalArchitecture.InRegionalArchitecture)=False) AND ((qryASRequestFlowsAll.InRegionalArchitecture)=True))tblElements_1.ElementID = tblRegionalArchitecture.DestinationElementIDtblFlows_1.FlowID = qryASRequestFlowsAll.FlowIDRequesttblFlows.FlowID = tblRegionalArchitecture.FlowIDtblElements.ElementID = tblRegionalArchitecture.SourceElementIDqryASRequestFlowsAll.SourceElementID = tblRegionalArchitecture.DestinationElementIDqryASRequestFlowsAll.DestinationElementID = tblRegionalArchitecture.SourceElementIDqryASRequestFlowsAll.FlowIDResponse = tblRegionalArchitecture.FlowIDqryASRequestFlowsAll.FlowIDRequesttblRegionalArchitecture.DestinationElementIDtblRegionalArchitecture.SourceElementID(((qryASResponseFlowsAll.ProjectID) Is Null) And ((qryASResponseFlowsAll.SourceElementID) Is Null) And ((qryASResponseFlowsAll.DestinationElementID) Is Null) And ((qryASResponseFlowsAll.FlowIDRequest) Is Null))tblFlows_1.FlowID=qryASRequestFlowsAll.FlowIDRequesttblFlows.FlowID=qryASRequestFlowsAll.FlowIDResponsetblElements_1.ElementID=qryASRequestFlowsAll.SourceElementIDtblElements.ElementID=qryASRequestFlowsAll.DestinationElementIDqryASRequestFlowsAll.FlowIDResponse=qryASResponseFlowsAll.FlowIDResponseqryASRequestFlowsAll.SourceElementID=qryASResponseFlowsAll.DestinationElementIDqryASRequestFlowsAll.DestinationElementID=qryASResponseFlowsAll.SourceElementIDqryASRequestFlowsAll.ProjectID=qryASResponseFlowsAll.ProjectIDqryASRequestFlowsAll.FlowIDRequest(((tblRegionalArchitecture.SourceElementID) Is Null) AND ((tblRegionalArchitecture.DestinationElementID) Is Null) AND ((tblRegionalArchitecture.FlowID) Is Null))Zk @ @ @ @ @ @ @ @ @ @ @ @ @ @+ Y+Y+Y+Y+Y+Y+Y+Y+Y+W.,Y,Y,Y,Y,Y,Y ,Y!,Y",Y#,Y-Y$-Y&-Y'-Y(-Y)-Y*-Y+-Y,-Y--Y.-Y/-Y0-Y1-Y2-Y3-[-[-[-[-[-Y%.[.[.[.[ .[ .[ .[ .[ .[/[/[/[/[/[/[/[/[/[/[0[0[0[0[0[0[0[0[ 0[!0["0[#0[1[$1[&1['1[(1[)1[*1[+1]1]1[%2]2]2]2]2]2]2] 2] 2] 2] 2] 2]2]2]3]3]3]3]3]3]3]3]3]3]3]3]3]3]3]3 ] 3 ]!3 ]"3]#3]$3]%3]&3]'3](3])3]*3]+3]4],4].4]/4]04]14]24`4`4`4`4`4`4`4`4`4` 4` 4 ` 4 ` 4` 4`4`4`4`4`4`4`4]-5`5`5`5`5`5`5`5`5`5`6`6`!6`"6`#6`$6`%6`&6`'6`(6`)6`*6`+6`,6`-6`.6`/6`06`16i6i6i6i6i6i6i6` 7i7i 7i 7i 7i 7i8i 8i8i8i8i8i8i8i8i8i8 i8i9i9i9i9i9i9i42:E Z 0 d d v  6 LRjL.85 e 6qryBatchSelectInterfacesBasictblTmpBatch@hmaK 6tblTmpBatch_1.ElementShow8 g6tblTmpBatch.ElementShow6 g6DestinationNametblElements_1.ElementNameV// o6d@h g6SourceNametblElements.ElementNameJ%% o6Z@h g6tblElementstblElements_1AA' 6tblElements''' 6qryBatchSelectInterfacesBasicKKK 6tblTmpBatchtblTmpBatch_1AA' 6tblTmpBatch''' 6qryFilteredElementsqryFilteredElements_1aa7 6qryFilteredElements777 6tblFilterFlowDeployment??? 6 G6 G6 6 G5@h '5qryASResponseFlowsNotIncludedProjecttblRegionalArchitecture@^Y 5qryASResponseFlowsNotIncludedProjecttblRegionalArchitecture@^Y 5qryASResponseFlowsNotIncludedProjecttblRegionalArchitecture@^Y 5tblRegionalArchitecture.FlowStatus^@^aU w5tblRegionalArchitecture??? 5qryASResponseFlowsNotIncludedProjectYYY 5 G5 5 G4@^ '4tblElements_1tblRegionalArchitecture@^eY+ 4tblFlows_1qryASRequestFlowsAlll@^YM% 4tblFlowstblRegionalArchitecture`@^[O! 4tblElementstblRegionalArchitecture~@^aU' 4qryASRequestFlowsAlltblRegionalArchitecture@^sg9 4qryASRequestFlowsAlltblRegionalArchitecture@^sg9 4qryASRequestFlowsAlltblRegionalArchitecture@^sg9 4 CorrespondingFlowNametblFlows_1.FlowName\;; o4 CorrespondingFlowIDtblFlows_1.FlowIDV77 o4D@ ^ g4!qryASRequestFlowsAll.FlowStatus> g4tblFlows.FlowName0 g4DestinationNametblElements_1.ElementNameV// o4SourceNametblElements.ElementNameJ%% o4 tblRegionalArchitecture.FlowID= g4X@ ^ g4N@ ^ g4tblRegionalArchitecture??? 4qryASRequestFlowsAll999 4tblElements''' LVAL%Zj h $ r $ ~  ^  "@FR@2(((qryFunEPElements.ElementID) Is Null) AND ((tblApplicationStatus.CurrentArchitecture) Is Not Null))qryFunEPElementsRelated.ElementID = qryFunEPElements.ElementIDtblApplicationStatus.CurrentArchitecture = tblProjectElements.ProjectIDqryFunEPElementsRelated.ElementID = tblProjectElements.ElementIDqryFunEPElementsRelated.ElementName(((qryFunEPElements.ElementID) Is Null))qryFunEPElementsRelated.ElementID = qryFunEPElements.ElementID(((tblEPArch.ArchitectureID)=[Arch]) AND ((tblEPArch.EquipmentPackageID)=[EP]))tblElements.ElementID = tblEPArch.ElementID(((tblEPArch.ArchitectureID)=[Arch]))(((tblElements.ElementID) Like [Element]))tblElements.ElementID = qryFunEPArch.ElementIDtblElements.ElementID = qryFunArchRequirementsKeys.ElementIDqryFunArchRequirementsKeys.ElementID(((tblProjectElements.ElementID) Like [Element]) AND ((tblProjectElements.ProjectID)=[Arch]))tblProjectElements.ElementID = tblElements.ElementIDtblProjectElements.ProjectID = qryFunEPArch.ArchitectureIDtblProjectElements.ElementID = qryFunEPArch.ElementIDtblProjectElements.ProjectID = qryFunArchRequirementsKeys.ArchitectureIDtblProjectElements.ElementID = qryFunArchRequirementsKeys.ElementIDqryFunArchRequirementsKeys.ElementID(((tblElementMapping.ElementID)=[Element]))tblEntities.EntityID = tblElementMapping.EntityIDtblEntities.EntityID = tblEquipmentPackages.EntityIDtblEquipmentPackages.EquipmentPackageNametblEquipmentPackages.EquipmentPackageOrdertblEquipmentPackages.EquipmentPackageIDqryFunElementEPsRelated.EquipmentPackageNameqryFunElementEPsRelated.EquipmentPackageOrderqryFunElementEPsRelated.EntityName(((qryFunElementEPs.EquipmentPackageID) Is Null))qryFunElementEPsRelated.EquipmentPackageID = qryFunElementEPs.EquipmentPackageIDqryFunElementEPsRelated.EquipmentPackageNameqryFunElementEPsRelated.EquipmentPackageIDqryFunElementEPsRelated.EntityNametblEquipmentPackages.EquipmentPackageNametblEquipmentPackages.EquipmentPackageOrderc @@@@@  @  @@ kQJiMWhoQiYQk`dOJomdbo`SYu`dOkQJiMWhoQiYQkmoiLdOJmJkMWQ`JJomdbo`SYuJO`YbOJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk`kvkJMMQkkdL[QMmk`kvkJMMQkku`^`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkhivJfS^dskiQUYdbhivJfS^dskiQUYdbLdmWhivJfS^dskiQUYdbMdobmhivJfS^dskiQUYdbQbo`QiJmQhivJfS^dskiQUYdbSdihivJfS^dskiQUYdbYOkhivJfS^dskiQUYdbYOkQ^QMmhivJfS^dskiQUYdbiQqhivJfS^dskiQUYdbkWdsJ^^hivJfS^dskiQUYdbkWdsJ^^Mdobm hivJfS^dskiQUYdbkWdsJ^^Qbo`QiJmQ!hivJfS^dskiQUYdbkWdsJ^^YOkQ^QMm"hivJfYbmQiMdbbQMmk#hivJfYbmQiMdbbQMmkLJkYM$hivJfYbmQiMdbbQMmkLJkYM`Yb%hivJfYbmQiMdbbQMmkMdobm&hivJfYbmQiMdbbQMmkQbo`QiJmQ'hivJfYbmQiMdbbQMmkSY^mQiQO(hivJfYbmQiMdbbQMmkkWdsJ^^)hivJfYbmQiMdbbQMmkkWdsJ^^MdobmQhivJfYbmQiMdbbQMmkkWdsJ^^Qbo`QiJmQQhivJfYbmQiMdbbQMmkkWdsJ^^SY^mQiQOQhivJkOQ^QmQS^dskfid[QMmQhivJkiQhoQkmS^dskJ^^QhivJkiQhoQkmS^dskQuM^oOQfid[QMmQhivJkiQhoQkmS^dskQuM^oOQiQUYdbQhivJkiQhoQkmS^dskYbM^oOQfid[QMmQhivJkiQhoQkmS^dskYbM^oOQiQUYdbQhivJkiQhoQkmS^dsk`YkkYbUJffQbOQ hivJkiQhoQkmS^dskbdmYbM^oOQOfid[QMmQ hivJkiQhoQkmS^dskbdmYbM^oOQOiQUYdbQ hivJkiQhoQkmS^dskkQmkmJmokfid[QMmQ hivJkiQkfdbkQS^dskJ^^Q hivJkiQkfdbkQS^dskQuM^oOQfid[QMmQhivJkiQkfdbkQS^dskQuM^oOQiQUYdbQhivJkiQkfdbkQS^dskYbM^oOQfid[QMmQhivJkiQkfdbkQS^dskYbM^oOQiQUYdbQhivJkiQkfdbkQS^dsk`YkkYbUJffQbOQhivJkiQkfdbkQS^dskbdmYbM^oOQOfid[QMmQhivJkiQkfdbkQS^dskbdmYbM^oOQOiQUYdbQhivJkiQkfdbkQS^dskkQmkmJmokfid[QMmQhivLJmMWkQ^QMmYbmQiSJMQkQhivLJmMWkQ^QMmYbmQiSJMQkLJkYMQhivMokMoiiQbmfid[QMmQ^Q`QbmkQhivMokkQ^QMmMoiiQbmfid[QMmS^dskQhivMokkQ^QMmMoiiQbmfid[QMmYbmQiMdbbQMmkQhivMokkQ^QMmMoiiQbmfid[QMmYbmQiMdbbQMmkobYhoQQhivMokmQ`fJffQbOfid[QMmS^dskQhivMokmQ`fJffQbOfid[QMmS^dskSY^mQiQhivMokmQ`fJffQbOfid[QMmYbmQiMdbbQMmkQhivMokmQ`fJffQbOfid[QMmYbmQiMdbbQMmkSY^mQiQhivMokmQ`fJffQbOfid[QMmYbmQiMdbbQMmkoffdimshivMokmQ`fJffQbOiQUYdbS^dskshivMokmQ`fJffQbOiQUYdbS^dskSY^mQishivMokmQ`fJffQbOiQUYdbYbmQiMdbbQMmkshivMokmQ`fJffQbOiQUYdbYbmQiMdbbQMmkSY^mQishivMokmQ`fJffQbOiQUYdbYbmQiMdbbQMmkoffdimshivSY^mQiQOQ^Q`QbmkshivSY^mQiQOS^dskshivSY^mQiQOS^dskQufJbOQOshivSY^mQiQOYbmQMdbbQMmmvfQks hivSY^mQiQOYbmQiMdbbQMmks hivSY^mQiQOYbmQiMdbbQMmkYbiQUYdbs hivSY^mQiQO`Ji\QmfJM\JUQYbmQiMdbbQMms hivSY^mQiQO`Ji\QmfJM\JUQYbmQiMdbbQMmLJkYMs hivSY^mQiQO`Ji\QmfJM\JUQkshivSY^mQiQO`Ji\QmfJM\JUQkQbmYmvS^dskshivSY^mQiQO`Ji\QmfJM\JUQkkoffdim8shivSY^mQiQO`Ji\QmfJM\JUQkkoffdim:shivSobJiMWiQhoYiQ`QbmkshivSobJiMWiQhoYiQ`Qbmk\QvkshivSobJomdJOOshivSobJomdJOOfid[QMmshivSobJomdfdmQbmYJ^shivSobJomdfdmQbmYJ^fid[QMmshivSobJomdiQ`dqQshivSobJomdiQ`dqQfid[QMmshivSobQ^Q`QbmQfkshivSobQ^Q`QbmQfkJOOYmYdbJ^sJMMQkk^Jvdom`kvkOL b   @@ @@   hivJkiQkfdbkQS^dskYbM^oOQiQUYdbQhivJkiQkfdbkQS^dsk`YkkYbUJffQbOQhivJkiQkfdbkQS^dskbdmYbM^oOQOfid[QMmQhivJkiQkfdbkQS^dskbdmYbM^oOQOiQUYdbQhivJkiQkfdbkQS^dskkQmkmJmokfid[QMmQhivLJmMWkQ^QMmYbmQiSJMQkQhivLJmMWkQ^QMmYbmQiSJMQkLJkYMQhivMokMoiiQbmfid[QMmQ^Q`QbmkQhivMokkQ^QMmMoiiQbmfid[QMmS^dskQhivMokkQ^QMmMoiiQbmfid[QMmYbmQiMdbbQMmkQhivMokkQ^QMmMoiiQbmfid[QMmYbmQiMdbbQMmkobYhoQQhivMokmQ`fJffQbOfid[QMmS^dskQhivMokmQ`fJffQbOfid[QMmS^dskSY^mQiQhivMokmQ`fJffQbOfid[QMmYbmQiMdbbQMmkQhivMokmQ`fJffQbOfid[QMmYbmQiMdbbQMmkSY^mQiQhivMokmQ`fJffQbOfid[QMmYbmQiMdbbQMmkoffdimshivMokmQ`fJffQbOiQUYdbS^dskshivMokmQ`fJffQbOiQUYdbS^dskSY^mQishivMokmQ`fJffQbOiQUYdbYbmQiMdbbQMmkshivMokmQ`fJffQbOiQUYdbYbmQiMdbbQMmkSY^mQishivMokmQ`fJffQbOiQUYdbYbmQiMdbbQMmkoffdimshivSY^mQiQOQ^Q`QbmkshivSY^mQiQOS^dskshivSY^mQiQOS^dskQufJbOQOshivSY^mQiQOYbmQMdbbQMmmvfQks hivSY^mQiQOYbmQiMdbbQMmks hivSY^mQiQOYbmQiMdbbQMmkYbiQUYdbs hivSY^mQiQO`Ji\QmfJM\JUQYbmQiMdbbQMms hivSY^mQiQO`Ji\QmfJM\JUQYbmQiMdbbQMmLJkYMs hivSY^mQiQO`Ji\QmfJM\JUQkshivSY^mQiQO`Ji\QmfJM\JUQkQbmYmvS^dskshivSY^mQiQO`Ji\QmfJM\JUQkkoffdim8shivSY^mQiQO`Ji\QmfJM\JUQkkoffdim:shivSobJiMWiQhoYiQ`QbmkshivSobJiMWiQhoYiQ`Qbmk\QvkshivSobJomdJOOshivSobJomdJOOfid[QMmshivSobJomdfdmQbmYJ^shivSobJomdfdmQbmYJ^fid[QMmshivSobJomdiQ`dqQshivSobJomdiQ`dqQfid[QMmshivSobQ^Q`QbmQfkshivSobQ^Q`QbmQfkJOOYmYdbJ^shivSobQ^Q`QbmQfkiQ^JmQOshivSobQ^Q`Qbmkfid[QMmshivSobQ^Q`QbmkiQUYdbshivSobQfJiMWshivSobQfQ^Q`Qbmks hivSobQfQ^Q`QbmkJOOYmYdbJ^s!hivSobQfQ^Q`QbmkJOOYmYdbJ^fid[QMms"hivSobQfQ^Q`QbmkiQ^JmQOhivSobQfQ^Q`QbmkiQhoYiQ`QbmkiQ^JmQOhivSobQfkMoiiQbmJiMWhivSobQfkMoiiQbmJiMWbdmYbiQUYdbhivSobQfkMoiiQbmJiMWbdmYbiQUYdbSJkdb^vhivSobQfkMoiiQbmJiMWbdmYbiQUYdbkfQ^^QOdomhivSobQfkfid[QMmhivSobQfkiQUYdbhivSobiQhMoiiQbmJiMWhivSobiQhMoiiQbmJiMWbdmYbiQUYdb hivSobiQhMoiiQbmJiMWbdmYbiQUYdb\Qvk hivSobiQhoYiQ`QbmkJffQbO hivSobkJqQJOO hivSobkJqQJiMWJOO hivSobkJqQJiMWkQmOQ^QmQhivSobkJqQofOJmQhivUQbJ^^dmWQiQbmYmvQbmiYQkhivUQbJffQbOJ^^qJ^YOS^dskhivUQbJffQbOJ^^qJ^YOS^dskMdbkQiqJmYqQhivUQbJffQbOJ^^qJ^YOS^dsk`dOQiJmQhivUQbJffQbOJ^^qJ^YOS^dsk`dOQiJmQkoffdimhivUQbJffQbOJ^^qJ^YOS^dskkoffdimhivUQbJffQbOJ^^qJ^YOS^dskkoffdim:hivUQbJffQbOJ^^qJ^YOS^dskkoffdim<hivUQbJffQbOJ^^qJ^YOfid[QMmS^dskhivUQbJffQbOJ^^qJ^YOfid[QMmS^dskMdbkQiqJmYqQhivUQbJffQbOJ^^qJ^YOfid[QMmS^dsk`dOQiJmQhivUQbJffQbOJ^^qJ^YOfid[QMmS^dsk`dOQiJmQkoffdimhivUQbJffQbOJ^^qJ^YOfid[QMmS^dskkoffdimhivUQbJffQbOJ^^qJ^YOfid[QMmS^dskkoffdim:hivUQbJffQbOJ^^qJ^YOfid[QMmS^dskkoffdim<hivUQbMoiiQbmfid[QMm`fkhivUQbbQsdmWQiQbmYmvQbmiYQk hivUQbkQ^QMmJ^^qJ^YOfid[QMmS^dskhivY`fdimQ^Q`Qbm`JffYbUkhivY`fdimiQhmQumMd`fJiQhivY`fdimiQhmQummiobMJmQ^dMJ^hivY`fdimiQhmQummiobMJmQiQ`dmQhivY`fdimkmJ\QWd^OQiid^QkJMMQkk^Jvdom`kvkOLBN w s C  m  a  Y  vX:mO1n+lN0j%Y;S btblApplicationStatustblProjectElements@"ai]9 bqryFunEPElementsRelatedtblProjectElements@!aoc? bqryFunEPElementsRelated.*8 gbqryFunEPElements111 btblApplicationStatus999 btblProjectElements555 bqryFunEPElementsRelated??? b Gb Gb b Ga F@ a 'aP@a 'aqryFunEPElementsRelatedqryFunEPElements|@ak_? aqryFunEPElementsRelated.*8 gaqryFunEPElements111 aqryFunEPElementsRelated??? a Ga Ga a G` tblElements.ElementName6 '`@a '`tblElementstblEPArchV@aE9' `tblElements.ElementName6 g`tblElements.ElementID4 g`tblEPArch### `tblElements''' ` G` G` ` G_J@a '_ tblEPArch.** g_tblEPArch### _ G_ G_ _ G^ tblElements.ElementName6 '^T@a '^tblElementsqryFunEPArch\@aK?' ^tblElementsqryFunArchRequirementsKeysx@ag[' ^ReqTestH@a+ o^FunctionalityqryFunEPArch.ElementIDO++ o^tblElements.ElementName6 g^tblElements.ElementID4 g^qryFunEPArch))) ^qryFunArchRequirementsKeysEEE ^tblElements''' ^ G^ G^ ^ G]@a ']tblProjectElementstblElementsh@aWK5 ]tblProjectElementsqryFunEPArcht@aYM5 ]tblProjectElementsqryFunEPArchj@aYM5 ]tblProjectElementsqryFunArchRequirementsKeys@aui5 ]tblProjectElementsqryFunArchRequirementsKeys@aui5 ]ReqTestH@a+ o]FunctionalityqryFunEPArch.ElementIDO++ o]tblElements.ElementName6 g]tblProjectElements.ElementID; g]tblElements''' ]qryFunEPArch)))  @ @ @ @ @ @ @ @ @ @ @ @ @ @XXXX X!X"X#X$X%X&X'X(X )X *X +X ,X -XY.Y0Y1Y2Y3Y4Y5Y6Y7Y8Y9YYYYYYYYYY Y  Y  Y  Y  Y Y/ZZZZZZZZZZZZZZ Z Z Z[ ["[#[$[%[&['[([)[*[+[ ,[ -[ .[!\/\1\2\3\4\5\6\7\8\9\:\;\<\=\0]>]@]A]B]C]d]d]d]d]d]d]d]d]d]d ]d ]d ]?^d ^d^d^d^d^d^d^d^d^d^d^d^d^ d^d _d_d_d_d_d _d!_d`d"`d$`d%`d&`d'`d(`d)`d*`d+` d,`d#ad-ad/ad0ad1ad2ad3ad4ad5a d6ad.bd7bd9bd:bd;bdbd?bd@bdAbfbfb fbd8cfcfcfcfcfcf cf cf cf cf cfc fcfdfdfdfdfdfdfdfdfdfdfefefefefefef ef!ef"ef#efff$ff&ff'ff(ff)ff*ff+ff,ff-ff%gf.gf/F^4v6 ~ ~ ;  S #  e 5 jXfxZpFfH rTitblElementMapping333 itblEntities''' itblEquipmentPackages999 i Gi Gi i GhX7YZ_____2@g1% 7hX7YZ_____1@g1% 7h Gh  Gh h Gg@ g 'gqryFunEPsCurrentArchNotInRegionqryFunReqCurrentArchNotInRegionKeys@ gO gqryFunEPsCurrentArchNotInRegionqryFunReqCurrentArchNotInRegionKeys@ gO gR@ g ggd@ g ggqryFunReqCurrentArchNotInRegionKeysWWW gqryFunEPsCurrentArchNotInRegionOOO g Gg Gg g GfZ@g 'fqryFunEPsCurrentArchqryFunEPArchn@g]Q9 fqryFunEPsCurrentArchqryFunEPArch@g]Q9 fqryFunEPsCurrentArch.*5 gfqryFunEPsCurrentArch999 fqryFunEPArch))) f Gf Gf f GetblEPArchtblApplicationStatus@gWK# etblEPArch.ArchitectureID7 getblEPArch.ElementID2 getblEPArch.EquipmentPackageID; getblEPArch### etblApplicationStatus999 e Ge Ge e GdtblEPArchtblEPRequirements@gQE# d!tblEPRequirements.RequirementID> gdtblEPArch.ElementID2 gdtblEPArch.EquipmentPackageID; gdtblEPArch### dtblEPRequirements333 d Gd Gd d Gc tblElements.ElementName6 'cd@g 'ctblElementstblElementMappingf@gUI' ctblEquipmentPackagestblElementMappingt@gg[9 ctblElements.ElementName6 gctblElements.ElementID4 gctblElements''' ctblElementMapping333 ctblEquipmentPackages999 c Gc Gc c Gb F@g 'b@$a 'bqryFunEPElementsRelatedqryFunEPElements|@#ak_? <LVALF| p p  ` P jSELECT tblElements.ElementName, tblEquipmentPackages.EquipmentPackageName, Null as RequirementID, Null as Requirement FROM (qryFunEPsCurrentArchNotInRegionFAsOnly INNER JOIN tblEquipmentPackages ON qryFunEPsCurrentArchNotInRegionFAsOnly.EquipmentPackageID = tblEquipmentPackages.EquipmentPackageID) INNER JOIN tblElements ON qryFunEPsCurrentArchNotInRegionFAsOnly.ElementID = tblElements.ElementIDSELECT tblElements.ElementName, tblEquipmentPackages.EquipmentPackageName, tblEPRequirements.RequirementID, tblEPRequirements.Requirement FROM tblEPRequirements INNER JOIN (tblElements INNER JOIN (tblEquipmentPackages INNER JOIN qryFunReqCurrentArchNotInRegionKeys ON tblEquipmentPackages.EquipmentPackageID = qryFunReqCurrentArchNotInRegionKeys.EquipmentPackageID) ON tblElements.ElementID = qryFunReqCurrentArchNotInRegionKeys.ElementID) ON (qryFunReqCurrentArchNotInRegionKeys.EquipmentPackageID = tblEPRequirements.EquipmentPackageID) AND (tblEPRequirements.RequirementID = qryFunReqCurrentArchNotInRegionKeys.RequirementID) ORDER BY tblElements.ElementName, tblEquipmentPackages.EquipmentPackageOrder, tblEPRequirements.RequirementID (((qryFunReqCurrentArchNotInRegionKeys.EquipmentPackageID) Is Null))qryFunEPsCurrentArchNotInRegion.ElementID = qryFunReqCurrentArchNotInRegionKeys.ElementIDqryFunEPsCurrentArchNotInRegion.EquipmentPackageID = qryFunReqCurrentArchNotInRegionKeys.EquipmentPackageIDqryFunEPsCurrentArchNotInRegion.ElementIDqryFunEPsCurrentArchNotInRegion.EquipmentPackageID(((qryFunEPArch.EquipmentPackageID) Is Null))qryFunEPsCurrentArch.ElementID = qryFunEPArch.ElementIDqryFunEPsCurrentArch.EquipmentPackageID = qryFunEPArch.EquipmentPackageIDtblEPArch.ArchitectureID = tblApplicationStatus.CurrentArchitecturetblEPArch.EquipmentPackageID = tblEPRequirements.EquipmentPackageID(((tblEquipmentPackages.EquipmentPackageID)=[EP]))tblElements.ElementID = tblElementMapping.ElementIDtblEquipmentPackages.EntityID = tblElementMapping.EntityIDqryFunEPElementsRelated.ElementNameLVAL*l H  j H *,FMin(qryCusSelectCurrentProjectInterconnects.InProjectArch)qryCusSelectCurrentProjectInterconnects.DestinationElementIDqryCusSelectCurrentProjectInterconnects.SourceElementIDtblApplicationStatus.CurrentArchitecture = tblProjectArchitecture.ProjectIDtblElements.ElementID = tblProjectElements.ElementIDtblApplicationStatus.CurrentArchitecture = tblProjectElements.ProjectIDSELECT DISTINCT tblRegionalArchitecture.SourceElementID, tblRegionalArchitecture.DestinationElementID, tblStatus.StatusID FROM (tblStatus RIGHT JOIN tblRegionalArchitecture ON tblStatus.StatusID = tblRegionalArchitecture.FlowStatus) LEFT JOIN tblProjectArchitecture ON tblRegionalArchitecture.RegionalFlowID = tblProjectArchitecture.RegionalFlowID WHERE ((((tblRegionalArchitecture.InRegionalArchitecture=Yes) AND ([Arch]=-1)) OR ([Arch]=[ProjectID])) AND (SourceElementID<DestinationElementID)) (((qryFilteredElements.ElementShow)=Yes) AND ((qryFilteredElements_1.ElementShow)=Yes) AND ((tblTmpBatch.ElementShow)=Yes) AND ((tblFilterFlowDeployment.[Select])=Yes)) OR (((qryFilteredElements.ElementShow)=Yes) AND ((qryFilteredElements_1.ElementShow)=Yes) AND ((tblTmpBatch_1.ElementShow)=Yes) AND ((tblFilterFlowDeployment.[Select])=Yes))tblElements.ElementID = qryBatchSelectInterfacesBasic.SourceElementIDtblElements_1.ElementID = qryBatchSelectInterfacesBasic.DestinationElementIDqryBatchSelectInterfacesBasic.StatusID = tblFilterFlowDeployment.FlowDeploymentqryBatchSelectInterfacesBasic.DestinationElementID = tblTmpBatch_1.ElementIDqryBatchSelectInterfacesBasic.DestinationElementID = qryFilteredElements_1.ElementIDqryBatchSelectInterfacesBasic.SourceElementID = qryFilteredElements.ElementIDqryBatchSelectInterfacesBasic.SourceElementID = tblTmpBatch.ElementIDqryBatchSelectInterfacesBasic.DestinationElementIDqryBatchSelectInterfacesBasic.SourceElementID(((qryASResponseFlowsNotIncludedProject.ProjectID)=[Project]) AND ((tblRegionalArchitecture.FlowStatus)=0))H?vj Z z \ > h J  F  ) n$f( DX.V(fv<RegionalFlowIDT@l9- w<qryCusSelectCurrentProjectFlowsOOO <tblElementstblElements_1AA' <tblRegionalArchitecture??? <qryCusCurrentProjectElementsIII <qryCusCurrentProjectElementsqryCusCurrentProjectElements_1I <tblStatus### <tblFlows!!! <tblElements''' <tblTempCustomize111 O< < G; p@l g; x@j g; n@j g;p@j g;InProjectArcht@h7++ o;x@h g;n@h g;qryCusSelectCurrentProjectInterconnects___ ; G; G; ; G:X7YZ_____2 @l1% 7:X7YZ_____1 @j1% 7: G:  G: : G9tblApplicationStatustblProjectArchitecture@hqe9 9tblProjectArchitecture.*7 g9tblApplicationStatus999 9tblProjectArchitecture=== 9 G9 G9 9 G8 tblElements.ElementName6 '8tblElementstblProjectElementsh@ hWK' 8tblApplicationStatustblProjectElements@ hi]9 8tblElements.ElementName6 g8tblProjectElements.ElementID; g8tblElements''' 8tblApplicationStatus999 8tblProjectElements555 8 G8 G8 8 G7X7YZ_____2@j1% 77X7YZ_____1@ h1% 77 G7  G7 7 G6@ h '6tblElementsqryBatchSelectInterfacesBasic@ hma' 6tblElements_1qryBatchSelectInterfacesBasic@hqe+ 6qryBatchSelectInterfacesBasictblFilterFlowDeployment@hyK 6qryBatchSelectInterfacesBasictblTmpBatch_1@hqeK 6qryBatchSelectInterfacesBasicqryFilteredElements_1@huK 6qryBatchSelectInterfacesBasicqryFilteredElements@h}qK LVAL DfqryCusSelectCurrentProjectInterconnects.DestinationElementIDqryCusSelectCurrentProjectInterconnects.SourceElementIDqryCusSelectCurrentProjectInterconnects.InterconnectShowSELECT DISTINCT qryFilteredInterconnects.SourceElementID, qryFilteredInterconnects.DestinationElementID, IIf(IsNull([ProjectID]),False,True) AS InProjectArch, qryFilteredInterconnects.InterconnectShow FROM (((qryCusSelectCurrentProjectFlows RIGHT JOIN tblRegionalArchitecture ON qryCusSelectCurrentProjectFlows.RegionalFlowID = tblRegionalArchitecture.RegionalFlowID) LEFT JOIN qryFilteredInterconnects ON (tblRegionalArchitecture.SourceElementID = qryFilteredInterconnects.SourceElementID) AND (tblRegionalArchitecture.DestinationElementID = qryFilteredInterconnects.DestinationElementID)) LEFT JOIN qryCusCurrentProjectElements ON tblRegionalArchitecture.SourceElementID = qryCusCurrentProjectElements.ElementID) LEFT JOIN qryCusCurrentProjectElements AS qryCusCurrentProjectElements_1 ON tblRegionalArchitecture.DestinationElementID = qryCusCurrentProjectElements_1.ElementID WHERE (((qryFilteredInterconnects.SourceElementID) Is Not Null) AND ((qryFilteredInterconnects.DestinationElementID) Is Not Null) AND ((qryCusCurrentProjectElements.ElementID) Is Not Null)) OR (((qryFilteredInterconnects.SourceElementID) Is Not Null) AND ((qryFilteredInterconnects.DestinationElementID) Is Not Null) AND ((qryCusCurrentProjectElements_1.ElementID) Is Not Null)) SELECT DISTINCT tblRegionalArchitecture.DestinationElementID, tblRegionalArchitecture.SourceElementID, tblStatus.StatusID FROM (tblStatus RIGHT JOIN tblRegionalArchitecture ON tblStatus.StatusID = tblRegionalArchitecture.FlowStatus) LEFT JOIN tblProjectArchitecture ON tblRegionalArchitecture.RegionalFlowID = tblProjectArchitecture.RegionalFlowID WHERE ((((tblRegionalArchitecture.InRegionalArchitecture=Yes) AND ([Arch]=-1)) OR ([Arch]=[ProjectID])) AND (DestinationElementID<SourceElementID))_p @ @ @ @ @ @ @ @ @ @ @ @ @ @3]3]3]3]3]3 ] 3 ]!3 ]"3]#3]$3]%3]&3]'3](3])3]*3]+3]4],4].4]/4]04]14]24`4`4`4`4`4`4`4`4`4` 4` 4 ` 4 ` 4` 4`4`4`4`4`4`4`4]-5`5`5`5`5`5`5`5`5`5`6`6`!6`"6`#6`$6`%6`&6`'6`(6`)6`*6`+6`,6`-6`.6`/6`06`16i6i6i6i6i6i6i6` 7i7i 7i 7i 7i 7i8i 8i8i8i8i8i8i8i8i8i8 i8i9i9i9i9i9i9i9i 9i:i!:i#:i$:i%:i&:i";i';i);i*;i+;i,;i-;i.;i/; i0; i1; i2;i(<i3<i5<i6<i7<i8<i9<i:<i;<i<<i=<i><m<m<m<m<m<m<m< m< m<m <m <m <m <m <m<m<m<i4=m=m=m=m=m=m=m=m=m=m=m= m=m=m=m =m!=m"=m#=m$=m%= m&= m'= m(=m)=m*=m+=m,=o=o=o=o=o=m>o>o>o>o >o >o >o >o >o>o>o>o>o>o> o> o> o>o?o?o?o?o?o?oLVAL *f |2>qryCusCurrentProjectElements_1.ElementID=[tblRegionalArchitecture].[DestinationElementID][qryCusCurrentProjectElements].[ElementID]=[tblRegionalArchitecture].[SourceElementID][tblRegionalArchitecture].[RegionalFlowID]=[qryCusSelectCurrentProjectFlows].[RegionalFlowID][tblRegionalArchitecture].[DestinationElementID]=tblElements_1.ElementID[tblRegionalArchitecture].[Comment][tblRegionalArchitecture].[InRegionalArchitecture][tblRegionalArchitecture].[LastBuild]IIf(IsNull([ProjectID]),32767,[StatusOrder])[tblRegionalArchitecture].[FlowStatus]IIf(IsNull([ProjectID]),False,True)[tblRegionalArchitecture].[RegionalFlowID]qryCusSelectCurrentProjectInterconnects.InterconnectShowSELECT DISTINCT qryFilteredInterconnects.SourceElementID, qryFilteredInterconnects.DestinationElementID, IIf(IsNull([ProjectID]),False,True) AS InProjectArch, qryFilteredInterconnects.InterconnectShow FROM (((qryCusSelectCurrentProjectFlows RIGHT JOIN tblRegionalArchitecture ON qryCusSelectCurrentProjectFlows.RegionalFlowID = tblRegionalArchitecture.RegionalFlowID) LEFT JOIN qryFilteredInterconnects ON (tblRegionalArchitecture.DestinationElementID = qryFilteredInterconnects.SourceElementID) AND (tblRegionalArchitecture.SourceElementID = qryFilteredInterconnects.DestinationElementID)) LEFT JOIN qryCusCurrentProjectElements ON tblRegionalArchitecture.SourceElementID = qryCusCurrentProjectElements.ElementID) LEFT JOIN qryCusCurrentProjectElements AS qryCusCurrentProjectElements_1 ON tblRegionalArchitecture.DestinationElementID = qryCusCurrentProjectElements_1.ElementID WHERE (((qryFilteredInterconnects.SourceElementID) Is Not Null) AND ((qryFilteredInterconnects.DestinationElementID) Is Not Null) AND ((qryCusCurrentProjectElements.ElementID) Is Not Null)) OR (((qryFilteredInterconnects.SourceElementID) Is Not Null) AND ((qryFilteredInterconnects.DestinationElementID) Is Not Null) AND ((qryCusCurrentProjectElements_1.ElementID) Is Not Null))^-6e u = 5  ? k -  y+aU?Z=qryCusCurrentProjectElements_1tblRegionalArchitecture@ n{M =qryCusCurrentProjectElementstblRegionalArchitecture@ nwI =tblRegionalArchitectureqryCusSelectCurrentProjectFlows@ n}? =tblRegionalArchitecturetblElements_1@ neY? = ShowqryFilteredFlows.FlowShow@ w= Comment!tblRegionalArchitecture.CommentL w= InRegionalArch\@ n9- w=LastBuildB@n/# w=FlowStatusDisplayFlowStatusDisplayX@naU3 =FlowStatusD@n1% w=InArchInArchF@n5) =FlowNametblFlows.FlowName@! w=DestinationElementtblElements_1.ElementName\5 w=SourceElementtblElements.ElementNameP+ w=RegionalFlowIDL@n9- w= tblStatus### =qryFilteredFlows111 =qryCusSelectCurrentProjectFlowsOOO =tblElementstblElements_1AA' =tblRegionalArchitecture??? =qryCusCurrentProjectElementsIII =qryCusCurrentProjectElementsqryCusCurrentProjectElements_1I =tblFlows!!! =tblElements''' = G=tblTempCustomize111 O= = G<@n '<tblElementstblRegionalArchitecture@naU' <tblFlowstblRegionalArchitecturel@n[O! <tblStatustblRegionalArchitecturez@n]Q# <qryCusCurrentProjectElements_1tblRegionalArchitecture@ l{M <qryCusCurrentProjectElementstblRegionalArchitecture@ lwI <tblRegionalArchitectureqryCusSelectCurrentProjectFlows@ l}? <tblRegionalArchitecturetblElements_1@ leY? < CommentF@l+ w< InRegionalArchd@l9- w<LastBuildJ@l/# w<FlowStatusDisplayFlowStatusDisplayX@laU3 <FlowStatusL@l1% w<InArchInArchF@l5) <FlowName[tblFlows].[FlowName]D! w<DestinationElementtblElements_1.ElementName\5 w<SourceElement[tblElements].[ElementName]T+ wLVAL P n , D H XljBLZMin(qryCusTempAppendProjectInterconnectSupport.InRegionalArch)Min([InterconnectShow] And [MinOfMPFilterShow] And qryFilteredElements.ElementShow And qryFilteredElements_1.ElementShow)Min(qryCusTempAppendProjectInterconnectSupport.InProjectArch)Min(qryCusTempAppendProjectInterconnectSupport.MinOfLastBuild)(((tblElements_1.ElementName)>[tblElements].[ElementName]))qryCusTempAppendProjectInterconnectSupport.DestinationElementID = tblElements_1.ElementIDqryCusTempAppendProjectInterconnectSupport.SourceElementID = tblElements.ElementIDMin(qryCusTempAppendProjectInterconnectSupport.InRegionalArch)Min(qryCusTempAppendProjectInterconnectSupport.InProjectArch)Min(qryCusTempAppendProjectInterconnectSupport.MinOfLastBuild)(((qryCusCurrentProjectElements.ElementID) Is Not Null)) OR (((qryCusCurrentProjectElements_1.ElementID) Is Not Null))tblStatus.StatusID = tblRegionalArchitecture.FlowStatustblElements.ElementID = tblRegionalArchitecture.SourceElementIDtblFlows.FlowID = tblRegionalArchitecture.FlowIDtblRegionalArchitecture.RegionalFlowID = qryFilteredFlows.RegionalFlowIDqryCusCurrentProjectElements_1.ElementID = tblRegionalArchitecture.DestinationElementIDqryCusCurrentProjectElements.ElementID = tblRegionalArchitecture.SourceElementIDtblRegionalArchitecture.RegionalFlowID = qryCusSelectCurrentProjectFlows.RegionalFlowIDtblRegionalArchitecture.DestinationElementID = tblElements_1.ElementIDtblRegionalArchitecture.InRegionalArchitecturetblRegionalArchitecture.LastBuildIIf(IsNull([ProjectID]),32767,[StatusOrder])tblRegionalArchitecture.FlowStatusIIf(IsNull([ProjectID]),False,True)tblRegionalArchitecture.RegionalFlowID((([qryCusCurrentProjectElements].[ElementID]) Is Not Null)) Or (((qryCusCurrentProjectElements_1.ElementID) Is Not Null))[tblElements].[ElementID]=[tblRegionalArchitecture].[SourceElementID][tblFlows].[FlowID]=[tblRegionalArchitecture].[FlowID][tblStatus].[StatusID]=[tblRegionalArchitecture].[FlowStatus]+ H  5 j  _ 3 cEQaJ%}Q?qryCusTempAppendProjectInterconnectSupportqryFilteredElements_1@qe ?qryFilteredElementsqryCusTempAppendProjectInterconnectSupport@q7 ?qryCusTempAppendProjectInterconnectSupporttblElements_1@qe ?qryCusTempAppendProjectInterconnectSupporttblElements@q{e ?MinOfInRegionalArchInRegionalArch|@n_S7 ?Expr1Show@n/# ?MinOfInProjectArchInArchz@nMA5 ?MinOfMinOfLastBuildLastBuild|@nUI7 ?DestinationElementtblElements_1.ElementName\5 w?SourceElementtblElements.ElementNameP+ w?qryFilteredInteconnectTypesGGG ?qryFilteredMarketPackageInterconnectYYY ?qryFilteredElementsqryFilteredElements_1aa7 ?tblElementstblElements_1AA' ?tblElements''' ?qryCusTempAppendProjectInterconnectSupporteee ?qryFilteredElements777 ?tblTempCustomize111 O? ? G> v@n '> tblElements_1.ElementName8 g> tblElements.ElementName6 g>qryCusTempAppendProjectInterconnectSupporttblElements_1@ne >qryCusTempAppendProjectInterconnectSupporttblElements@n{e >MinOfInRegionalArchInRegionalArch|@n_S7 >ShowShow Min(True)8! >MinOfInProjectArchInArchz@nMA5 >MinOfMinOfLastBuildLastBuild|@nUI7 >DestinationElementtblElements_1.ElementName\5 w>SourceElementtblElements.ElementNameP+ w>tblElementstblElements_1AA' >tblElements''' >qryCusTempAppendProjectInterconnectSupporteee > G>tblTempCustomize111 O> > G=@n '=tblStatustblRegionalArchitecturen@n]Q# =tblElementstblRegionalArchitecture~@naU' =tblFlowstblRegionalArchitecture`@n[O! =tblRegionalArchitectureqryFilteredFlows@nk_? kw @ @ @ @ @ @ @ @ @ @ @ @ @ @9i 9i:i!:i#:i$:i%:i&:i";i';i);i*;i+;i,;i-;i.;i/; i0; i1; i2;i(<i3<i5<i6<i7<i8<i9<i:<i;<i<<i=<i><m<m<m<m<m<m<m< m< m<m <m <m <m <m <m<m<m<i4=m=m=m=m=m=m=m=m=m=m=m= m=m=m=m =m!=m"=m#=m$=m%= m&= m'= m(=m)=m*=m+=m,=o=o=o=o=o=m>o>o>o>o >o >o >o >o >o>o>o>o>o>o> o> o> o>o?o?o?o?o?o?o?o?o?o ?o!?o"?o#?o$?o%?o&?o'?o(?o)?o*?r?r?r?r? r? r? r?o@r@r @r @r @r @rAr ArArArArArArArArArArArArArArA rArArAr Ar!ArBr"Br$Br%Br&Br'Br(Br)Br*Br+Br,Br-Br.Br/Br0Br1Br2B r3BuBuBuBuBuBr#CuCuCuCu Cu Cu Cu Cu CuCuCuCuC uC uC uCuDuDuDuDuDuDuDuDuDuDuDu Du!Du"Du#Du$Du%Du&Du'DuLVAL `D R t Z ftblRegionalArchitecture.RegionalFlowIDSELECT tblRegionalArchitecture.SourceElementID, tblRegionalArchitecture.DestinationElementID, Min(tblRegionalArchitecture.LastBuild) AS MinOfLastBuild, Min(IIf(IsNull([ProjectID]),False,True)) AS InProjectArch, Min([InRegionalArchitecture]) as InRegionalArch FROM ((tblRegionalArchitecture LEFT JOIN qryCusCurrentProjectElements ON tblRegionalArchitecture.SourceElementID = qryCusCurrentProjectElements.ElementID) LEFT JOIN qryCusCurrentProjectElements AS qryCusCurrentProjectElements_1 ON tblRegionalArchitecture.DestinationElementID = qryCusCurrentProjectElements_1.ElementID) LEFT JOIN qryCusSelectCurrentProjectFlows ON tblRegionalArchitecture.RegionalFlowID = qryCusSelectCurrentProjectFlows.RegionalFlowID GROUP BY tblRegionalArchitecture.SourceElementID, tblRegionalArchitecture.DestinationElementID, qryCusCurrentProjectElements.ElementID, qryCusCurrentProjectElements_1.ElementID HAVING (((qryCusCurrentProjectElements.ElementID) Is Not Null)) OR (((qryCusCurrentProjectElements_1.ElementID) Is Not Null)) (((tblElements_1.ElementName)>tblElements.ElementName))qryCusTempAppendProjectInterconnectSupport.SourceElementID=qryFilteredInteconnectTypes.SourceElementIDqryCusTempAppendProjectInterconnectSupport.DestinationElementID=qryFilteredInteconnectTypes.DestinationElementIDqryCusTempAppendProjectInterconnectSupport.SourceElementID=qryFilteredMarketPackageInterconnect.SourceElementIDqryCusTempAppendProjectInterconnectSupport.DestinationElementID=qryFilteredMarketPackageInterconnect.DestinationElementIDqryCusTempAppendProjectInterconnectSupport.DestinationElementID=qryFilteredElements_1.ElementIDqryFilteredElements.ElementID=qryCusTempAppendProjectInterconnectSupport.SourceElementIDqryCusTempAppendProjectInterconnectSupport.DestinationElementID=tblElements_1.ElementIDqryCusTempAppendProjectInterconnectSupport.SourceElementID=tblElements.ElementID4:t Z <  f H * > z  g1I~> `2ZJB Show[qryFilteredFlows].[FlowShow]D wBLastBuildJ@ t/# wBFlowStatusDisplayFlowStatusDisplayb@ taU3 BFlowStatusL@ t1% wBInArchd@ t) wBFlowName[tblFlows].[FlowName]D! wBDestinationElementtblElements_1.ElementName\5 wBSourceElement[tblElements].[ElementName]T+ wBRegionalFlowIDT@ t9- wBqryFilteredFlows111 BtblElementstblElements_1AA' BtblRegionalArchitecture??? BtblFlows!!! BtblElements''' BtblStatus### BtblTempCustomize111 OB B GAtblRegionalArchitecturetblStatusj@t]Q? AtblElementstblRegionalArchitecturez@taU' AtblFlowstblRegionalArchitecture\@t[O! AtblRegionalArchitecturetblElements_1@teY? A Comment!tblRegionalArchitecture.CommentL wALastBuildB@t/# wAFlowStatusDisplayFlowStatusDisplayb@taU3 AFlowStatusD@t1% wAInArch\@t) wAFlowNametblFlows.FlowName@! wADestinationElementtblElements_1.ElementName\5 wASourceElementtblElements.ElementNameP+ wARegionalFlowIDL@ q9- wAtblStatus### AtblElementstblElements_1AA' AtblRegionalArchitecture??? AtblFlows!!! AtblElements''' AtblTempCustomize111 OA A G@X7YZ_____2@t1% 7@X7YZ_____1@ q1% 7@ G@  G@ @ G? n@q '? tblElements_1.ElementName8 g? tblElements.ElementName6 g?qryCusTempAppendProjectInterconnectSupportqryFilteredInteconnectTypes@qe ?qryCusTempAppendProjectInterconnectSupportqryFilteredInteconnectTypes@qe ?qryCusTempAppendProjectInterconnectSupportqryFilteredMarketPackageInterconnect@qe ?qryCusTempAppendProjectInterconnectSupportqryFilteredMarketPackageInterconnect@qe .#UQOr LN : J g ?;H#ECAbbXς@Xς@qrybzXa@zXa@qryFunEPElementsAdditionalProjectV'@@|ppdddddddb @aTCWa@TCWa@qryFunEPElementsAdditionalV'@@nbbVVVVVVVT @_Ua@Ua@qryFunEPArchV'@|@RFF:::::::8 @^Ta@Ta@qryFunElementsRegionV'@@bVVJJJJJJJH @]Ra@Ra@qryFunElementsProjectV'@@dXXLLLLLLLJ @\pQa@pQa@qryFunElementEPsRelatedV'@@h\\PPPPPPPN @Z@Oa@@Oa@qryFunElementEPsV'@@ZNNBBBBBBB@ @YMa@;HNa@qryFunAutoRemoveProjectV'@@h\\PPPPPPPN @XgLa@gLa@qryFunAutoRemoveV'@@ ZNNBBBBBBB@ @WDLa@DLa@qryFunAutoPotentialProjectVy@$ @ nbbVVVVVVVT @ULa@La@qryFunAutoAddProjectV'@@ bVVJJJJJJJH @TKa@Ka@qryFunAutoAddV'@@THH<<<<<<<: @SKa@Ka@qryFunArchRequirementsKeysV'@@nbbVVVVVVVT @R]XKa@Ka@qryFunArchRequirementsV'@|@fZZNNNNNNNL @Q.@7Xz@qryFilteredMarketPackagesSupport2VI@@|ppdddddddb @O!R/@`R/@qryFilteredMarketPackagesEntityFlowsV[@@vvjjjjjjjh @N" ,@YM@qryFilteredMarketPackagesV@@l``TTTTTTTR @MJa@2F@qryFilteredMarketPackageInterconnectBasicV@`@tttttttr @L_Ja@!1@qryFilteredMarketPackageInterconnectV @|@vvjjjjjjjh @ Jq5z@F@qryFilteredInterconnectsV@@j^^RRRRRRRP @I4Xؐ@e Е@qryFilteredInteconnectTypesV@@pddXXXXXXXV @HIa@H2\z@qryFilteredFlowsExpandedV @@j^^RRRRRRRP @GW3z@lYM@qryFilteredFlowsV @\ @ZNNBBBBBBB@ @ EWؐ@Wؐ@qryCusTempAppendRegionInterconnectSupportVH@|@tttttttr @D3Vؐ@W L   C Z<h$2@r*xDqryFilteredElementsqryCusTempAppendRegionInterconnectSupport@ v7 DqryCusTempAppendRegionInterconnectSupportqryFilteredInteconnectTypes@ vc DqryCusTempAppendRegionInterconnectSupportqryFilteredInteconnectTypes@ vc DqryCusTempAppendRegionInterconnectSupporttblElements_1@ v}c DqryCusTempAppendRegionInterconnectSupporttblElements@ vyc DExpr1Show@v/# DMinOfMinOfLastBuildLastBuildz@vUI7 DMinOfMinOfInRegionalArchitectureInArch@vi]Q DDestinationElementtblElements_1.ElementName\5 wDSourceElementtblElements.ElementNameP+ wDqryFilteredInteconnectTypesGGG DtblElementstblElements_1AA' DtblElements''' DqryCusTempAppendRegionInterconnectSupportccc DqryFilteredElements777 DqryFilteredElementsqryFilteredElements_1aa7 DqryFilteredMarketPackageInterconnectYYY D GDtblTempCustomize111 OD D GC v@v 'C tblElements_1.ElementName8 gC tblElements.ElementName6 gCqryCusTempAppendRegionInterconnectSupporttblElements_1@v}c CqryCusTempAppendRegionInterconnectSupporttblElements@vyc CMinOfMinOfLastBuildLastBuildz@vUI7 CMinOfMinOfInRegionalArchitectureInArch@vi]Q CDestinationElementtblElements_1.ElementName\5 wCSourceElementtblElements.ElementNameP+ wCtblElementstblElements_1AA' CtblElements''' CqryCusTempAppendRegionInterconnectSupportccc C GCtblTempCustomize111 OC C GBtblStatustblRegionalArchitecturez@v]Q# BtblElementstblRegionalArchitecture@taU' BtblFlowstblRegionalArchitecturel@t[O! BtblRegionalArchitectureqryFilteredFlows@tk_? BtblRegionalArchitecturetblElements_1@teY? LVALx &  N ,8XSELECT tblRegionalArchitecture.SourceElementID, tblRegionalArchitecture.DestinationElementID, Min(tblRegionalArchitecture.InRegionalArchitecture) AS MinOfInRegionalArchitecture, Min(tblRegionalArchitecture.LastBuild) AS MinOfLastBuild FROM tblRegionalArchitecture GROUP BY tblRegionalArchitecture.SourceElementID, tblRegionalArchitecture.DestinationElementID (((tblElements_1.ElementName)>[tblElements].[ElementName]))qryFilteredMarketPackageInterconnect.SourceElementID = qryCusTempAppendRegionInterconnectSupport.SourceElementIDqryFilteredMarketPackageInterconnect.DestinationElementID = qryCusTempAppendRegionInterconnectSupport.DestinationElementIDqryFilteredElements_1.ElementID = qryCusTempAppendRegionInterconnectSupport.DestinationElementIDqryFilteredElements.ElementID = qryCusTempAppendRegionInterconnectSupport.SourceElementIDqryCusTempAppendRegionInterconnectSupport.DestinationElementID = qryFilteredInteconnectTypes.DestinationElementIDqryCusTempAppendRegionInterconnectSupport.SourceElementID = qryFilteredInteconnectTypes.SourceElementIDqryCusTempAppendRegionInterconnectSupport.DestinationElementID = tblElements_1.ElementIDqryCusTempAppendRegionInterconnectSupport.SourceElementID = tblElements.ElementIDMin([InterconnectShow] And [MinOfMPFilterShow] And [qryFilteredElements].[ElementShow] And [qryFilteredElements_1].[ElementShow])Min(qryCusTempAppendRegionInterconnectSupport.MinOfLastBuild)Min(qryCusTempAppendRegionInterconnectSupport.MinOfInRegionalArchitecture)(((tblElements_1.ElementName)>[tblElements].[ElementName]))qryCusTempAppendRegionInterconnectSupport.DestinationElementID = tblElements_1.ElementIDqryCusTempAppendRegionInterconnectSupport.SourceElementID = tblElements.ElementIDMin(qryCusTempAppendRegionInterconnectSupport.MinOfLastBuild)Min(qryCusTempAppendRegionInterconnectSupport.MinOfInRegionalArchitecture)[tblStatus].[StatusID]=[tblRegionalArchitecture].[FlowStatus]p| @ @ @ @ @ @ @ @ @ @ @ @ @ @?o?o?o ?o!?o"?o#?o$?o%?o&?o'?o(?o)?o*?r?r?r?r? r? r? r?o@r@r @r @r @r @rAr ArArArArArArArArArArArArArArA rArArAr Ar!ArBr"Br$Br%Br&Br'Br(Br)Br*Br+Br,Br-Br.Br/Br0Br1Br2B r3BuBuBuBuBuBr#CuCuCuCu Cu Cu Cu Cu CuCuCuCuC uC uC uCuDuDuDuDuDuDuDuDuDuDuDu Du!Du"Du#Du$Du%Du&Du'Du(Du)DxDxDxD xD xD xDuExExEx Ex Ex ExFx FxFxFxFxFxFxFxFxFxFxFxF xF xF xFx GxGxGxGx Gx!Gx"Gx#Gx$Gx%G x&Gx'Gx(Gx)Gx*Gx+Gx,Gx-Gx.Gx/Gx0Gx1Gx2Gx3GzGzGzGxHzHzHzHzHzHz Hz Hz Hz Hz HzHzHzHzH zH zH zH zH zHzHzHzHzHzIzIzIzIzIz Iz!Iz"Iz#Iz$Iz%Iz&Iz'Iz(Iz)Iz*Iz+Iz,IzJz-Jz/Jz0Jz1Jz2Jz3Jz.L4Z J  j ,  j $ i ) U ;_1_U+Cj0PLGtblRegionalArchitectureqryFilteredMarketPackages@y}q? GtblFilterFlowDeploymenttblRegionalArchitecture@yym? GqryFilteredElementstblRegionalArchitecture@yqe7 GqryFilteredElements_1tblRegionalArchitecture@yui; GtblFlowstblFilterFlowTypesj@ yQE! GFlowShow6@ y-!! oGT@ y gGFlowTypeShow[tblFilterFlowTypes].[Select]T)) oGFlowFuturisticShow@ yA55 oGFlowStatusShowD@ y9-- oGDestinationElementShowB@yI== oGSourceElementShowF@y?33 oGT@y gG qryFilteredMarketPackagesCCC GtblRegionalArchitecture??? GqryFilteredElementsqryFilteredElements_1aa7 GqryFilteredElements777 GtblFilterFlowDeployment??? GtblFilterFlowTypes555 GtblFlows!!! GqryFilteredInteconnectTypesGGG GtblFilterFlowFuturistic??? G G GF tblElementMapping.ElementID: 'F Z@y 'F tblElementMapping.ElementID: gFtblEntitiestblElementMappingb@yUI' FtblEntitiestblFilterEntityTypesp@y[O' FtblEntitiestblFilterEntityClassesx@y_S' FElementShow@y3'' oFtblElementMapping.ElementID: gFtblElementMapping333 FtblEntities''' FtblFilterEntityTypes999 FtblFilterEntityClasses=== F GF GF F GEX7YZ_____2@y1% 7EX7YZ_____1@v1% 7E GE  GE E GD v@v 'D tblElements_1.ElementName8 gD tblElements.ElementName6 gDqryFilteredMarketPackageInterconnectqryCusTempAppendRegionInterconnectSupport@vY DqryFilteredMarketPackageInterconnectqryCusTempAppendRegionInterconnectSupport@vY DqryFilteredElements_1qryCusTempAppendRegionInterconnectSupport@v; LVAL0  . r  R 8^"z6tblRegionalArchitecture.FlowStatustblRegionalArchitecture.InRegionalArchitecturetblRegionalArchitecture.RegionalFlowID[qryFilteredInteconnectTypes].[DestinationElementID]=[tblRegionalArchitecture].[DestinationElementID][qryFilteredInteconnectTypes].[SourceElementID]=[tblRegionalArchitecture].[SourceElementID][tblFlows].[FlowID]=[tblRegionalArchitecture].[FlowID][tblRegionalArchitecture].[RegionalFlowID]=[qryFilteredMarketPackages].[RegionalFlowID][tblFilterFlowDeployment].[FlowDeployment]=[tblRegionalArchitecture].[FlowStatus][qryFilteredElements].[ElementID]=[tblRegionalArchitecture].[SourceElementID]qryFilteredElements_1.ElementID=[tblRegionalArchitecture].[DestinationElementID][tblFlows].[FlowType]=[tblFilterFlowTypes].[FlowType][SourceElementShow] And [DestinationElementShow] And [FlowStatusShow] And [FlowFuturisticShow] And [FlowTypeShow] And [MPFilterShow] And [InterconnectShow][qryFilteredMarketPackages].[MPFilterShow]IIf((([tblFilterFlowFuturistic].[Select]=False) And ([tblFlows].[FlowFuturistic]=True)),False,True)[tblFilterFlowDeployment].[Select]qryFilteredElements_1.ElementShow[qryFilteredElements].[ElementShow][tblRegionalArchitecture].[RegionalFlowID](((tblElementMapping.ElementID) Is Not Null))tblEntities.EntityID = tblElementMapping.EntityIDtblEntities.EntityType = tblFilterEntityTypes.EntityTypetblEntities.EntityClass = tblFilterEntityClasses.EntityClassMin(IIf([tblFilterEntityClasses].[Select]>[tblFilterEntityTypes].[Select],[tblFilterEntityClasses].[Select],[tblFilterEntityTypes].[Select]))SELECT tblRegionalArchitecture.DestinationElementID, tblRegionalArchitecture.SourceElementID, Min(tblRegionalArchitecture.InRegionalArchitecture) AS MinOfInRegionalArchitecture, Min(tblRegionalArchitecture.LastBuild) AS MinOfLastBuild FROM tblRegionalArchitecture GROUP BY tblRegionalArchitecture.SourceElementID, tblRegionalArchitecture.DestinationElementIDE5 |^@  D  I f < m " 9 cAu5{1UkM/WJqryFilteredElements777 JqrySelectUniqueInterconnectsIII JqryFilteredMarketPackageInterconnectYYY JqryFilteredInteconnectTypesGGG J GJ GJ J GIqrySelectAllInterconnectstblElementMapping@{qeC IqrySelectAllInterconnectstblElementMapping_1@ {uiC ItblEntitiestblElementMapping_1j@ {YM' ItblEntities_1tblElementMappingj@ {YM+ ItblFilterInterconnectstblEntities_1@ {cW= ItblFilterInterconnectstblEntities@ {_S= IInterconnectShowB@{=11 oId@{ gIZ@{ gItblElementMappingtblElementMapping_1YY3 ItblElementMapping333 ItblEntitiestblEntities_1AA' ItblEntities''' ItblFilterInterconnects=== IqrySelectAllInterconnectsCCC I GI I GHtblRegionalArchitectureqryFilteredFlows@{k_? HtblElementstblRegionalArchitecturez@{aU' HtblFlowstblRegionalArchitecture\@{[O! HtblRegionalArchitecturetblElements_1@{eY? H ShowqryFilteredFlows.FlowShow@ oH B@{ gH !tblRegionalArchitecture.Comment> gH tblFlows.FlowDescription7 gH TouchedFalse2 oHFlowStatusDisplayX@{?33 oHD@y gHtblFlows.FlowKind0 gHtblFlows.FlowName0 gHDestinationElementtblElements_1.ElementName\55 oHSourceElementtblElements.ElementNameP++ oHInArch\@y) oHL@y gHqryFilteredFlows111 HtblElementstblElements_1AA' HtblRegionalArchitecture??? HtblFlows!!! HtblElements''' H H GGqryFilteredInteconnectTypestblRegionalArchitecture@yuG GqryFilteredInteconnectTypestblRegionalArchitecture@yuG GtblFlowstblRegionalArchitecturel@y[O! LVALf| " | v  h LHn8[qryFilteredMarketPackagesSupport2].[RegionalFlowID]qryFilteredMarketPackageInterconnectBasic.DestinationElementIDqryFilteredMarketPackageInterconnectBasic.SourceElementIDMin(qryFilteredMarketPackageInterconnectBasic.MPFilterShow)qryFilteredMarketPackageInterconnectBasic.DestinationElementIDqryFilteredMarketPackageInterconnectBasic.SourceElementIDqryFilteredInteconnectTypes.SourceElementID = qrySelectUniqueInterconnects.SourceElementIDqryFilteredInteconnectTypes.DestinationElementID = qrySelectUniqueInterconnects.DestinationElementIDqryFilteredMarketPackageInterconnect.DestinationElementID = qrySelectUniqueInterconnects.DestinationElementIDqryFilteredMarketPackageInterconnect.SourceElementID = qrySelectUniqueInterconnects.SourceElementIDqrySelectUniqueInterconnects.DestinationElementID = qryFilteredElements_1.ElementIDqrySelectUniqueInterconnects.SourceElementID = qryFilteredElements.ElementIDqryFilteredElements.ElementShow And qryFilteredElements_1.ElementShow And [minofMPFilterShow] And qryFilteredInteconnectTypes.InterconnectShow[qrySelectAllInterconnects].[SourceElementID]=[tblElementMapping].[ElementID][qrySelectAllInterconnects].[DestinationElementID]=tblElementMapping_1.ElementID[tblEntities].[EntityID]=tblElementMapping_1.EntityIDtblEntities_1.EntityID=[tblElementMapping].[EntityID][tblFilterInterconnects].[EntityClass]=tblEntities_1.EntityClass[tblFilterInterconnects].[EntityClass2]=[tblEntities].[EntityClass][tblFilterInterconnects].[Select][qrySelectAllInterconnects].[DestinationElementID][qrySelectAllInterconnects].[SourceElementID]tblRegionalArchitecture.RegionalFlowID=qryFilteredFlows.RegionalFlowIDtblElements.ElementID=tblRegionalArchitecture.SourceElementIDtblFlows.FlowID=tblRegionalArchitecture.FlowIDtblRegionalArchitecture.DestinationElementID=tblElements_1.ElementIDtblRegionalArchitecture.LastBuildIIf([InRegionalArchitecture],[FlowStatus],0)w @ @ @ @ @ @ @ @ @ @ @ @ @ @Du)DxDxDxD xD xD xDuExExEx Ex Ex ExFx FxFxFxFxFxFxFxFxFxFxFxF xF xF xFx GxGxGxGx Gx!Gx"Gx#Gx$Gx%G x&Gx'Gx(Gx)Gx*Gx+Gx,Gx-Gx.Gx/Gx0Gx1Gx2Gx3GzGzGzGxHzHzHzHzHzHz Hz Hz Hz Hz HzHzHzHzH zH zH zH zH zHzHzHzHzHzIzIzIzIzIz Iz!Iz"Iz#Iz$Iz%Iz&Iz'Iz(Iz)Iz*Iz+Iz,IzJz-Jz/Jz0Jz1Jz2Jz3Jz4J}J}J}J}J}J}J}J}J}Jz.K} K} K} K} K}K} L}L}L}L}L}L}L}L }L }L}M}M}M}M}M}M}N}N}!N}"N}#N}$N}%N}&N}'N}(N})N}*N}+N} O},O}.O}/O}0O}1O}2O}3O}4O}5O}6O}-P}7P}9P}:PPPPPPPPPP P P P P PPPPPPPP}8QQQQQQQQQQQ  Q !Q "Q #Q $QR%R'R(R)R*R+R&S,S-;Hv @ f H * r T 6  ` 6 xZ<fH^4 BvX:tJ b8PtblTmpSelectedMP111 P GP P GO,@ 'OtblMarketPackagestblMarketPackageFlows@i]3 OtblMarketPackageFlows.FlowID; gOR@ gOH@ gOtblMarketPackageFlows;;; OtblMarketPackages333 OtblTmpSelectedMP111 O GO O GNqryFilteredMarketPackagesSupport2qryFilteredMarketPackagesSupport1@S NqryFilteredMarketPackagesSupport2qryFilteredMarketPackagesSupport1@S NqryFilteredMarketPackagesSupport2qryFilteredMarketPackagesSupport1@~S NMPFilterShowl@~5)) oNX@~ gNt@~ gNj@~ gNh@{ gNqryFilteredMarketPackagesSupport1SSS NqryFilteredMarketPackagesSupport2SSS N GN N GMX7YZ_____2`@~1% 7MX7YZ_____1b@~1% 7M GM  GM M GL |@{ gL r@{ gLMinOfMPFilterShowv@{?33 oL|@{ gLr@{ gLqryFilteredMarketPackageInterconnectBasicccc L GL GL L GKX7YZ_____2@~1% 7KX7YZ_____1@~1% 7K GK  GK K GJqryFilteredInteconnectTypesqrySelectUniqueInterconnects@{G JqryFilteredInteconnectTypesqrySelectUniqueInterconnects@{G JqryFilteredMarketPackageInterconnectqrySelectUniqueInterconnects@{Y JqryFilteredMarketPackageInterconnectqrySelectUniqueInterconnects@{Y JqrySelectUniqueInterconnectsqryFilteredElements_1@{sI JqrySelectUniqueInterconnectsqryFilteredElements@{{oI JInterconnectShow@{=11 oJ qrySelectUniqueInterconnects.*= gJqryFilteredElementsqryFilteredElements_1aa7 LVAL z<x[qryFilteredMarketPackagesSupport2].[SourceElementID]=[qryFilteredMarketPackagesSupport1].[SourceElementID]IIf(IsNull([MPShowOverall]),[ShowAll],[MPShowOverall])[qryFilteredMarketPackagesSupport2].[FlowID][qryFilteredMarketPackagesSupport2].[DestinationElementID][qryFilteredMarketPackagesSupport2].[SourceElementID]SELECT DISTINCT qryFilteredMarketPackages.DestinationElementID, qryFilteredMarketPackages.SourceElementID,qryFilteredMarketPackages.MPFilterShow FROM qryFilteredMarketPackagesSELECT DISTINCT qryFilteredMarketPackages.SourceElementID, qryFilteredMarketPackages.DestinationElementID,qryFilteredMarketPackages.MPFilterShow FROM qryFilteredMarketPackages SELECT qryFilteredInterconnects.SourceElementID, qryFilteredInterconnects.DestinationElementID, qryFilteredInterconnects.InterconnectShow,Min(tblRegionalArchitecture.InRegionalArchitecture) AS InRegion, Min(tblRegionalArchitecture.LastBuild) AS LastBuild FROM qryFilteredInterconnects LEFT JOIN tblRegionalArchitecture ON (qryFilteredInterconnects.DestinationElementID = tblRegionalArchitecture.DestinationElementID) AND (qryFilteredInterconnects.SourceElementID = tblRegionalArchitecture.SourceElementID) GROUP BY qryFilteredInterconnects.SourceElementID, qryFilteredInterconnects.DestinationElementID, qryFilteredInterconnects.InterconnectShowSELECT qryFilteredInterconnects.SourceElementID, qryFilteredInterconnects.DestinationElementID, qryFilteredInterconnects.InterconnectShow,Min(tblRegionalArchitecture.InRegionalArchitecture) AS InRegion, Min(tblRegionalArchitecture.LastBuild) AS LastBuild FROM qryFilteredInterconnects LEFT JOIN tblRegionalArchitecture ON (qryFilteredInterconnects.DestinationElementID = tblRegionalArchitecture.SourceElementID) AND (qryFilteredInterconnects.SourceElementID = tblRegionalArchitecture.DestinationElementID) GROUP BY qryFilteredInterconnects.SourceElementID, qryFilteredInterconnects.DestinationElementID, qryFilteredInterconnects.InterconnectShow LVAL d D  > j @ XR`Th  (((tblEPArchRequirements.ArchitectureID)=[Arch]))tblEPElementsRequirements.EPElementReqID = tblEPArchRequirements.EPElementReqIDtblEPArchRequirements.ArchitectureIDtblEPElementsRequirements.RequirementIDtblEPElementsRequirements.ElementIDtblEPElementsRequirements.EquipmentPackageID(((tblEPArchRequirements.ArchitectureID)=[ArchID]))tblRegionalArchitecture.DestinationElementIDtblRegionalArchitecture.SourceElementIDtblRegionalArchitecture.RegionalFlowIDtblRegionalArchitecture.DestinationElementIDtblRegionalArchitecture.SourceElementIDtblRegionalArchitecture.RegionalFlowID((([tblMarketPackageElements].[Select])=Yes) And ((tblMarketPackageElements_1.[Select])=Yes))[tblTmpSelectedMP].[MarketPackageID]=[tblMarketPackages].[MarketPackageID][tblMarketPackages].[MarketPackageID]=[tblMarketPackageElements].[MarketPackageID][tblMarketPackageElements].[ElementID]=[tblElementMapping].[ElementID]tblMarketPackageElements_1.ElementID=tblElementMapping_1.ElementIDtblMarketPackageElements_1.MarketPackageID=[tblMarketPackages].[MarketPackageID][tblMarketPackages].[MarketPackage]=[tblMarketPackageFlows].[MarketPackage][tblMarketPackageFlows].[DestinationEntityID]=tblElementMapping_1.EntityID[tblMarketPackageFlows].[SourceEntityID]=[tblElementMapping].[EntityID]tblMarketPackageElements_1.[Select][tblMarketPackageElements].[Select]tblMarketPackageElements_1.ElementID[tblMarketPackageElements].[ElementID](((tblTmpSelectedMP.ShowAll)=True)) Or (((tblMarketPackages.MarketPackageID)=tblTmpSelectedMP.MarketPackageID) And ((tblTmpSelectedMP.ShowAll)=False))tblMarketPackages.MarketPackage=tblMarketPackageFlows.MarketPackagetblMarketPackageFlows.DestinationEntityIDtblMarketPackageFlows.SourceEntityID[qryFilteredMarketPackagesSupport2].[FlowID]=[qryFilteredMarketPackagesSupport1].[