Standard Jet DBnb` Ugr@?~1y0̝cǟFN7]D^(`T{6u߱wCϯ34ay[|*|OJl>`&_Љ$g'DeFx -r{N             "FlagsFormModuleNameReplicationVersionTypeTypeInfoVersioncDep y%\Index1%%%+P+p+ ++۱0@(~sq_cTechnique 4 - Runtime~sq_cPatientID+ (+@+ +H+Patients.[patientID](++`+8JU PatientIDpatients ++(+ PatientIDpatients ++ + +@+H+P+X+`++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ +++++ + p+ +``+ + `+ + |+ (++8+LU+ +P + + + + +  +0@ + +,L +X + +\ +h + +l + P + [given Name] +" " +  + [family Name] +H +p + + ++ +patientsX+h+PrimaryKey PatientID++v x+h+0+  VCS           2      ru  g          0  IdParentIdNameType DateCreate DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtraH r m0 Id ParentIdName        cs.........., s@@sej.@MSysIMEXSpecs.........., s@@count patients for Report1@@bc@ S_SSG;;;;;;9 `'`mm9@Xs@Example 04 query using criteria in different columns C@`@[ymmaUUUUUUS `$ym9@l5C@Example 01 query using the sort option and top valuesC@Ez@SznnbVVVVVVT `Bx@@Patients test controls@LWF000_@aUCC7777775 -n@A+@Example 22b Drugs not used in treatment (using in operator)[@@@ 2thh\\\\\\\Z @v@3@Example 22a Drugs not used in treatment (using exists operator)[@@ Sxll```````^ @ $2>@!u0@`Example 23 SQL create table@SH<<<<<<<<<: >-@-@Example 05a operator like using criteria in same column VCS     2  ObjectIdSIDACM FInheritableto rae ObjectIdy-One~sq_cSecond Subform*@iii]QQQ'О@eО@~sq_cSubform 2 - One-Many-One~sq_cSecond Subform*@iii]'О@eО@~sq_cSubform 2 - One-Many-One~sq_cSecond Subform*@iii'О@eО@~sq_cSubform 2 - One-Many-One~sq_cSecond Subform*@iii]QQQQQQO `'О@eО@~sq_cSubform 2 - One-Many-One~sq_cSecond Subform*@iii]QQQQ'О@eО@~sq_cSubform 2 - One-Many-One~sq_cSecond Subform*@iii]QQQQQQO `RR@PR@~sq_fCombo 1 - Storing an ID6 7*@UUUI======; ` ߤd@ ߤd@~sq_fCombo 4_(treatment subform)< a*@iYYYMAAAAAA? `w@@~sq_fSubform 1 - Aggregate*@izSSSG;;;;;;9 `u-j@Q@~sq_fSubform 1_(subform)1 *@AQQQE9999997 `>`m9@4]@Example 18a oldest and youngest@Y@ XLL@@@@@@@> @ML@6@Example 15a iif with null values@C@YMMAAAAAAA? @6` m9@xp@Example 11a another group criteria exampleC@ @cWWKKKKKKKI @LdX@z@Example 09a query using domain aggregate functions@f@z@{wkk_SSSSSSQ `*@m9@Qa@Example 03b operator between comparison C@_@{l``THHHHHHF `-O\m9@ʴr@Example 07 testing for unknown values@3@ ^RRFFFFFFFD @K !11@TtM6@AccessLayout*@z /E99-------+ @VC?S             ObjectId AttributeOrderName1Name2 ExpressionFlagilnzjtz ObjectIdAttribute  @".G@TreatmentL@666*******( @F U G@h.@Example 21a percent costA-@@]QQE9999997 `E`vCS G@BS@Example 21 total costE %C@`@@ZNNB6666664 `DN@c G@qNN@Example 21 percent cost*@ @@\PPD8888886 `C@+ƛF@O*@Example 21 each drugP C@{@@YMMA5555553 `~A`GzF@J@Example 20 nested queryC@@@PDD88888886 @@ *F@"@Example 19 Range of valuesC@@@SGG;;;;;;;9 @?@-m9@.@Example 17b more date functions (C@Qc@dXXL@@@@@@> ` =m9@ A\@Example 18 date calculation@C@ THH<<<<<<<: @<`m9@f-@Example 17a date functions C@ec@_SSG;;;;;;9 `~:@m9@%t1@Example 22 Drugs not used in Treatment (unmatched query)C@@@qeeYYYYYYYW @96m9@w@Example 16 group iif@4@MAA55555553 @l~5@ym9@Y @Example 11 setting criteria on aggregate queries@@[i]]QQQQQQQO @~3gVF@Ft@Example 14 character functionI@fc@ SbVVJ>>>>>>< `2m9@sf@Example 13 unique values@?@QEE99999997 @ ~0`m9@^X@Example 09 query using aggregate query functions@z@uii]QQQQQQO `VCS  N           szRelationshipgrbitccolumnicolumnszObjectszColumnszReferencedObjectszReferencedColumn   szObjectszReferencedObjectszRelationshipO@[@'9]QQE9999997 `Aq@WA רu@U<$@technique 4 form bristolO@[@'9]QQE9999997 `Aq@W רu@U<$@technique 4 form bristolO@[@'9]QQE9999997 `Aq רu@U<$@technique 4 form bristolO@[@'9]QQE9999997 ` רu@U<$@technique 4 form bristolO@[@'9]QQE999999 רu@U<$@technique 4 form bristolO@[@'9]QQE9999997 `j6 רu@U<$@technique 4 form bristolO@[@'9]QQE9999997 `j6 רu@U<$@technique 4 form bristolO@[@'9]QQE9999997 `j6 רu@U<$@technique 4 form bristolO@[@'9]QQE9999997 `j6n@Ll>@TEchnique 4 macro version-RuntimeBBBBBBBBBB@ ~kU@+}U@technique 3 drug unloadD@;D8888888886 dU@m@Technique 3_(drug form used by macro version)NNNNNNNNNNL xaU@Apm@Technique 3 macro version- not in listGGGGGGGGGGE GgF@6}0@Treatment Details (Extended form)3f@@fZZNBBBBBB@ ` {qg]SI?5LLLƔ|? I` @ @& % :.!"0;aL@o{\ufsruwv vbujswv v}vufm w`amfv1vt,gbroarYdmrrlxs d/1vt,gbroarYdmrrlxs oarWvwrujph`pjd/1vt,gbroarYdmrrlxs Wvwrujph`pjd/1vt,gbroarYdmrrlxs arWvwrujph`pjd/1vt,gbroarYdmrrlxs 1vt,gbroarWvwrujph`pjd/1vt,gbroarYdmrrlxs 1vt,gbroarWvwrujph`pjd/1vt,gbroarYdmrrlxs 1vt,gbroarWvwrujph`pjd/1vt,gbroarYdmrrlxs 1vt,gbroarWvwrujph`pjd/1vt,gbroarYdmrrlxs vt,gbroarWvwrujph`pjd/1vt,gbroarYdmrrlxs 1vt,gbroarWvwrujph`pjd/1vt,gbroarYdmrrlxs 1vt,gbroarWvwrujph`pjd/1vt,gbroarYdmrrlxs )1vt,gbroarWvwrujph`pjd/1vt,gbroarYdmrrlxs 1vt,gbroarWvwrujph`pjd/1vt,gbroarYdmrrlxs 1vt,gbroarWvwrujph`pjd/1vt,gbroarYdmrrlxs vt,gbroarWvwrujph`pjd/1vt,gbroarYdmrrlxs 1vt,gbroarWvwrujph`pjd/1vt,gbroarYdmrrlxs oarWvwrujph`pjd/1vt,gbroarYdmrrlxs vwrujph`pjd/1vt,gbroarYdmrrlxs vwrujph`pjd/1vt,gbroarYdmrrlxs oarWvwrujph`pjd/1vt,gbroarYdmrrlxs vwrujph`pjd/1vt,gbroarYdmrrlxs vwrujph`pjd/1vt,gbroarYdmrrlxs 1vt,gbroarWvwrujph`pjd/1vt,gbroarYdmrrlxs 1vt,gbroarWvwrujph`pjd/1vt,gbroarYdmrrlxs ph`pjd/1vt,gbroarYdmrrlxs jph`pjd/1vt,gbroarYdmrrlxso{N%%\             "FlagsFormModuleNameReplicationVersionTypeTypeInfoVersioncDep y%\Index1%%%+P+p+ ++۱0@(~sq_cTechnique 4 - Runtime~sq_cPatientID+ (+@+ +H+Patients.[patientID](++`+8JU PatientIDpatients ++(+ PatientIDpatients ++ + +@+H+P+X+`++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ ++ +++++ + p+ +``+ + `+ + |+ (++8+LU+ +P + + + + +  +0@ + +,L +X + +\ +h + +l + P + [given Name] +" " +  + [family Name] +H +p + + ++ +patientsX+h+PrimaryKey PatientID++v x+h+0++s+++++0 K3 wfbipjtxfXordxmfa`vjbzfuvjrpgjpdufbrudordxmfv 1vt,gs`wjfpwvwfvwbrpwurmv)f|`osmfV_`txfu}xvjphdro`jp`hhufh`wfgxpbwjrpv*ruobroarZ,s`wjfpw,vxagruobroarZ,wuf`wofpwvxagruoduxhsjfbi`uwgurpwpruo`ms`wjfpwvs`wjfpwvwfvwbrpwurmvvxagruoW`hhufh`wfvxagruoW,vxagruovxagruoXrpfo`p}rpfvxagruoX,duxhgruovxagruoX,vfbrpdvxagruowfbipjtxfWo`burzfuvjrpdj`mrhar|wfbipjtxfWordxmfa`vjbzfuvjrpdj`mrhar|wfbipjtxfW,wuf`wofpwgruoxvfda}o`burdj`mrhar|gruowfbipjtxfW,wuf`wofpwgruoxvfda}ordxmfdj`mrhar|gruowfbipjtxfXgjpdufbrudwfbipjtxfXo`burzfuvjrpgjpdufbrudwfbipjtxfXordxmfa`vjbzfuvjrpgjpdufbrudwfbipjtxfYo`burzfuvjrpprwjpmjvwwfbipjtxfYordxmfzfuvjrpprwjpmjvwwfbipjtxfY,duxhgruoxvfda}o`burzfuvjrp wfbipjtxfY,duxhgruoxvfda}ordxmfzfuvjrp wfbipjtxfZo`burzfuvjrpuxpwjof wfbipjtxfZordxmfzfuvjrpuxpwjof wfos,gruo,wr,`dd,wuf`wofpw,d`w` m`afmvs`wjfpwvs`wjfpwv,brs}gurogruos`wjfpwv,v`zf`vufsruwufsruwW`xwrf|fbgjpds`wjfpwgurpwbmrvfp`of,fpwfup`of,f|jwwfbipjtxfWb`pbfmaxwwrpwfbipjtxfWrlaxwwrpd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxw ov}vdao{pNеNEEUEULԘ`4pN*\еNeEUUujԘptpN\еNeeeuEVԘpN"еNuuuujԘpN!XеNee%ueeVԘ@fpNеNUEeEejԘ`tpN1еN5e5e5jԘ@ox98HText43Ds English_NameˮText48IsQuantity_Per_UnitText49Js FrequencyText50fsDRugIDText110Box121 Product_NameӋText123DoctorIDUText126Text129 FormFooter1Date start course%Date end coursez0DosageK| Doses per daymSelectProd_AfterUpdateSetFocus FindRecordxedrugID_NotInListNewDatax_Response Unit_Price NewCategorya TruncateNameG MsgDialogF DoMenuItem&e A_FORMBARjA_EDITŗ A_UNDOFIELD- A_MENU_VER20A_NORMAL3QA_ADD@FormsTechnique 3_(drug form) Drug name=BDATA_ERRCONTINUEButton23_ClickqDetail1- Drug_Name*Text11rText14rBox20=Button23Text24rtablets_per_packetcost_per_packetI SelectObjects^Technique 3 - Not in ListZRequeryoptionUS_AfterUpdateuCoptionUSEj Button132Text133 Button134Text135Text138Text139 SQLSourceʟ RowSource2utility1JClickCurrente AfterUpdate NotInList _B_str_ErrorR_B_var_Technique 3_(drug form)Itemz_B_var_D  @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @            ! " # $ %&'()*+,-./0123456789 : ; <=>?@ABCDEFGH*I*J*K*L*M*N*O*P*Q* R* S* T* U* V*W*X*Y*Z*[*\*]*^*_*`6a6b6c6d6 e6 f6 g6 h6i6j6klnopqrstv wxyz~PPPPPPP P PPPPPPPP ! 76;6>6@666 Xjtton42_ClickButton43_ClickButton44_ClickButton45_Click I%T4 `U(s%T4 `U(J%T4 `U(r%T4 `U(nameCountOfOrder_IDText4 Form_Unload P Technique 1 - Dialo {qg]SI?UUUUUUUUUUUUUUUUUUUUUUUU  ǯH"Phb!P}Y-MSysDb# MKFor}Y-MSysDb# MK@$@@ Q  Q9  4Ol q'D   '()*+,-./                !"#$%&'()*+      !"#$%&'()*  ! ! !!""""####$$$$%%%&%'%(&)&&&''''((( ( ) ) ) ))*****+++++,,,,,-- -!-"-#.$.%.&.'.(/)/*/+/,/-0.hhhii i!j"j#j$ !"#  $%&&y @=5&B%*'I(.+N,*-T.'/Y02_45o`38hUx::::::;;;;;;;;;;; ;!;";#;$;%;<&<(<)<*<+< ,<'=-=/=0=1=2=3=4=5=6=7=%=.>%>%>%>%>%>%>%>% >% >% >%?% ?%?%?%?%?%?%?%?% @%@%@%@%@%@%@%@%@%@%A%A%!A%"A%#A%$A%%A%&A%'A%(A% B%)B%+B%,B%-B%.B%/B%0B%**:+@ drbwruvdj`hprvjvs`wjfpwvdj`hprvjvufgfufpbfufgfufpbfWufgfufpbfXufgfufpbfY:jMSysDb#j~MSysDb#Form_TEchnique 4 macro version-Runtimej~MSysDb#Form_TEchnique 4 maj~MSysDb#Form_TEchnique 4 j~MSysDb#Form_TEchnique j~MSysDb#j~MSysDb#j~MSysDb#Form_TEchnique 4 macro version-Runtime[WKGCEForm_Technique 4 module version- Runtime]YMIE Form_Technique 3_(drug form used by macro version)$gcWSO LForm_Technique 3 macro version- not in listT`\PLHyiForm_Technique 3_(drug form used by module version)$hdXTP Form_Technique 3 module version- Not in ListTa]QMIJ*HForm_Technique 1_(treatment form used by module dialog box form)Kuqea]@ dj`hprvjvdj`hprvjvwuf`wofpwwuf`wofpwwuf`wofpwwuf`wofpwHLP[LS S6LLN0{54251E5E-0934-11D3-80A5-006008552884}:7$*\Rffff*21373acde8*\R1*#4c*\R1*#4a*\R1*#55*\R1*#53 @($^`(Dk`nxxp0 $8 $  $p`X(2 r(p@t @(d @T \z@D 00XME"  v 2 ,   :  F`    0ZpmSELECT DISTINCTROW patients.[patientID], [given Name] & ' ' & [family Name] AS Name FROM patients WHERE town 'n+ Set criteria to match option group choice.[Te @drbwruvdrbwruvdrbwruvduxhvs`wjfpwvs`wjfpwvForm_Technique 4 - Runtime"D Basb0{54251E5E-0934-11D3-80A5-0060085@52884} |CreatablCTrue ]Pre declaId"Expose!Fals @TemplateDeriv%CustomizD$P Sub optionUS_AfterUpd `() Dim SQLSource As rSng SELECT DISTINCTROW patients.[ID], [g\n  ] & '& [family AS FROM" WHERE `town D' Set cri bia match7 group choice2.C If?`1 ThenC>4& "= 'briUl'A Eg'AV<>nd` If ORDER BYL;DADthe RowDoproperty of Al2 box a!reryI[PCol.G=DŽ. C5E__SRP_10rU !## $Q$% 1 Y @4 a @8  ppp@ <  rrr@@  ttt@D !xxx@H1!Y|||@L Y!?Cx,dt! t Hd(T]/Dt5d\E lx*1xS lx*1x lx*1xlxt! t tt! t Dt8(SxtdD<[__SRP_11erU X$`p&Q]u=ED DC|xB?^ZA@nyM6yM6@qF@Ϟ@Subform 2_(second subform)@LWF000eYGG;;;;;;9 61iF@ў@Subform 2 - One-Many-One?@LWF000@cWEE9999997 6@hF@L2@Subform 1 - Aggregate@LWF000p@`TBB6666664 Bx@iu@Patients test controls@LWF000_aUCC7777775 `9wG@ `@Patients))))))))))' 6kn)@YH@front&&&&&&&&&&$  F@!.Ų@drug pie chartD@LWF000MYM;;//////- 6 jxG@J@Combo 4_(patient_subform)@LWF000@dXFF::::::8  "G@~.@Combo 4- link patients name to patient subform@LWF000@ym[[OOOOOOM 6YcF@Jdn @Combo 3 - DLookupx@LWF000@\P>>2222220 63@b@Combo 1 - Storing an ID!@LWF000@ gbVDD8888886 6+@+@SysRel''''''''''% 5+@5+@Scripts((((((((((& @+@@+@Reports((((((((((& +@+@Modules((((((((((& @+@@+@Forms&&&&&&&&&&$ MSysRelationships22222222220 MSysQueries,,,,,,,,,,* MSysACEs))))))))))' MSysObjects,,,,,,,,,,* mj=²@MSysDbE@333'''''''% @Relationships.........., Databases**********( Tables''''''''''% 3Mv,(Fs^ >:CB;e@q09yM6@9yM6@technique 2 afterup0L@:N@technique 2 afterupdate@D8888888886 .ɨP@E Q@technique 1 cancel button@F:::::::::8 - ʓG@!{Ų@name_exitl@6*********( ,@ G@!{Ų@name_enterj@7+++++++++) +@@frontclose@7+++++++++) *ە@EdX@findpatientt@8,,,,,,,,,* )G@!{Ų@autoexec|@5)))))))))' ' :\/@p]/@Patients_saveasreport66666666664 &쭻/@,/@Patients_copyfromform@LWF000/`TBB6666664 $c0@y,Ų@temp_form_to_add_treatment_data@LWF000@j^LL@@@@@@> #@OyF@En@Technique 4 module version- RuntimeDDDDDDDDDDB "j6n@Ll>@TEchnique 4 macro version-RuntimeBBBBBBBBBB@ !OxF@?LU@Technique 3_(drug form used by module version)OOOOOOOOOOM  dU@m@Technique 3_(drug form used by macro version)NNNNNNNNNNL @UwF@<;]U@Technique 3 module version- Not in ListHHHHHHHHHHF xaU@Apm@Technique 3 macro version- not in listGGGGGGGGGGE 'M@T1P@Technique 2 module basic version- Find RecordNNNNNNNNNNL wvF@Cw{@Technique 2 - Find Record::::::::::8 ŪeP@=MsP@Technique 1_(treatment form used by module dialog box form)\\\\\\\\\\Z 0OtF@ӌP@Technique 1_(Treatment form used by macro dialog box form)[[[[[[[[[[Y rF@FQ@Technique 1 module basic version- Dialog BoxMMMMMMMMMMK .6P@B Q@Technique 1 macro version- Dialog boxFFFFFFFFFFD N   @broarWvwrujph`pjdbroarX`xwrmrrlxsbroarYdmrrlxsbroarZmjplduxhvwrwuf`wofpwvxagruobroarZmjpls`wjfpwvp`ofwrs`wjfpwvxagruobroarZ,s`wjfpw,vxagruobroarZ,wuf`wofpwvxagruobroar[z`mxfvguro`broarar|duxhsjfbi`uwgurpwpruo`ms`wjfpwvs`wjfpwvwfvwbrpwurmvvxagruoW`hhufh`wfvxagruoW,vxagruovxagruoXrpfo`p}rpfvxagruoX,duxhgruovxagruoX,vfbrpdvxagruowfbipjtxfWo`burzfuvjrpdj`mrhar|wfbipjtxfWordxmfa`vjbzfuvjrpdj`mrhar|wfbipjtxfW,wuf`wofpwgruoxvfda}o`burdj`mrhar|gruowfbipjtxfW,wuf`wofpwgruoxvfda}ordxmfdj`mrhar|gruowfbipjtxfXgjpdufbrudwfbipjtxfXo`burzfuvjrpgjpdufbrudwfbipjtxfXordxmfa`vjbzfuvjrpgjpdufbrudwfbipjtxfYordxmfzfuvjrpprwjpmjvwwfbipjtxfY,duxhgruoxvfda}o`burzfuvjrp wfbipjtxfY,duxhgruoxvfda}ordxmfzfuvjrp wfbipjtxfZo`burzfuvjrpuxpwjof wfbipjtxfZordxmfzfuvjrpuxpwjof wfos,gruo,wr,`dd,wuf`wofpw,d`w` m`afmvs`wjfpwvs`wjfpwv,brs}gurogruos`wjfpwv,v`zf`vufsruwufsruwW`xwrf|fbgjpds`wjfpwgurpwbmrvfp`of,fpwfup`of,f|jwwfbipjtxfWb`pbfmaxwwrpwfbipjtxfWrlaxwwrpd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxw ov}vda) @  @ @@ @wfbipjtxfYo`burzfuvjrpprwjpmjvwwfbipjtxfYordxmfzfuvjrpprwjpmjvwwfbipjtxfY,duxhgruoxvfda}o`burzfuvjrp wfbipjtxfY,duxhgruoxvfda}ordxmfzfuvjrp wfbipjtxfZo`burzfuvjrpuxpwjof wfbipjtxfZordxmfzfuvjrpuxpwjof wfos,gruo,wr,`dd,wuf`wofpw,d`w` vsmjw`ddufvvvsmjwp`ofm`afmvs`wjfpwvs`wjfpwv,brs}gurogruos`wjfpwv,v`zf`vufsruwufsruwWufsruwX`xwrf|fbbroar[brpdjwjrp`mo`bur gjpds`wjfpwgurpwbmrvfp`of,fpwfup`of,f|jwwfbipjtxfWb`pbfmaxwwrpwfbipjtxfWrlaxwwrpwfbipjtxfX`gwfuxsd`wfwfbipjtxfXbxuufpwwfbipjtxfXvruwwfbipjtxfYbmrvfwfbipjtxfYduxhxpmr`dwfbipjtxfYprwjpmjvwwfbipjtxfZrswjrpwfbipjtxfZrswjrp{urph`dojpd`w`a`vfvgruovordxmfv `mm,jpgr brxpws`wjfpwvgruufsruwW drbwruv duxhv duxhv`xwrmrrlxsgruo f|`osmfVWtxfu}xvjphwifvruwrswjrp`pdwrsz`mxfvf|`osmfVXtxfu}xvjphoxmwjsmfw`amfvf|`osmfVYtxfu}xvjphvfmfbwjrpbujwfuj`f|`osmfVY`rsfu`wruhuf`wfubujwfuj`f|`osmfVYarsfu`wruafw{ffpbros`ujvrpf|`osmfVZtxfu}xvjphbujwfuj`jpdjggfufpwbrmxopvf|`osmfV[rsfu`wruruxvjphbujwfuj`jpv`ofbrmxopf|`osmfV[`rsfu`wrumjlfxvjphbujwfuj`jpv`ofbrmxopf|`osmfV\txfu}xvjphmjlff|`osmfV]wfvwjphgruxplpr{pz`mxfvov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxw ov}vda `c_G jEr E]YDx B51AVGGM6GG`m9@^X@Example 09 query using aggregate query functions@ @i]]QQQQQQQO @FPm9@-_y@Example 08 prompted query@ @RFF:::::::8 @ DLm9@>&ܧ-@Example 06 query using like@ @THH<<<<<<<: @C>-@-@Example 05a operator like using criteria in same column@@pddXXXXXXXV @B`Am9@tʏ@Example 05 operator or using criteria in same columnC@@maaUUUUUUUS @@@m9@Qa@Example 03b operator between comparisonC@@`TTHHHHHHHF @?am9@@Example 03a operator greater criteriaC@@^RRFFFFFFFD @>m9@NPs@Example 03 query using selection criteria@@bVVJJJJJJJH @=jm9@j`s@Example 02 query using multiple tablesC@@_SSGGGGGGGE @;@}F@FI\@Drugs (AutoLookup form)5@"@\PPD8888886 `!~+@L@Drugs@222&&&&&&&$ @:s@@count patients for Report1@@SGG;;;;;;;9 @9 F@࣭F@all_info)fC@@MAA5))))))' `8 | +@k83 @Admin@2&&&&&&&&&$ 7EF?@%+@technique 4 option wrong@E9999999997 6+s@cs @technique 4 optionl@?3333333331 5Gɴm@Gq@technique 3 notinlist@B6666666664 4~kU@+}U@technique 3 drug unloadD@D8888888886 2%RO@%RO@technique 2 sort(@=111111111/ 1v3Z@!m@technique 2 current@@4444444442 VC N     age_rangeage_minage_maxx  PrimaryKeywfbipjtxfYo`burzfuvjrpprwjpmjvwwfbipjtxfYordxmfzfuvjrpprwjpmjvwwfbipjtxfY,duxhgruoxvfda}o`burzfuvjrp wfbipjtxfY,duxhgruoxvfda}ordxmfzfuvjrp wfbipjtxfZo`burzfuvjrpuxpwjof wfbipjtxfZordxmfzfuvjrpuxpwjof wfos,gruo,wr,`dd,wuf`wofpw,d`w` m`afmvs`wjfpwvs`wjfpwv,brs}gurogruos`wjfpwv,v`zf`vufsruwufsruwW`xwrf|fbgjpds`wjfpwgurpwbmrvfp`of,fpwfup`of,f|jwwfbipjtxfWb`pbfmaxwwrpwfbipjtxfWrlaxwwrpwfbipjtxfX`gwfuxsd`wfwfbipjtxfXbxuufpwwfbipjtxfXvruwwfbipjtxfYbmrvfwfbipjtxfYduxhxpmr`dwfbipjtxfYprwjpmjvwwfbipjtxfZrswjrpwfbipjtxfZrswjrp{urphd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxw ov}vda a{q @ @ @ @ @ @ @ @            ! " # $ %&'()*+,-./01234567F *@ceAU@B7AU@~sq_fTechnique 3 module version- Not in ListF *@ceeeYMMMMMMK `ɨP@E Q@technique 1 cancel button@9F:::::::::8  P@&z,Q@technique 1 ok button@9B6666666664 ŪeP@=MsP@Technique 1_(treatment form used by module dialog box form)\\\\\\\\\\Z CP@P@technique 1 macro form N@0@@4[OOC7777775 `.6P@B Q@Technique 1 macro version- Dialog boxFFFFFFFFFFD %RO@%RO@technique 2 sort(@9=111111111/ 'M@T1P@Technique 2 module basic version- Find RecordNNNNNNNNNNL v3Z@!m@technique l  @ wfbipjtxfYo`burzfuvjrpprwjpmjvwwfbipjtxfYordxmfzfuvjrpprwjpmjvwwfbipjtxfY,duxhgruoxvfda}o`burzfuvjrp wfbipjtxfY,duxhgruoxvfda}ordxmfzfuvjrp wfbipjtxfZo`burzfuvjrpuxpwjof wfbipjtxfZordxmfzfuvjrpuxpwjof wfos,gruo,wr,`dd,wuf`wofpw,d`w` m`afmvs`wjfpwvs`wjfpwv,brs}gurogruos`wjfpwv,v`zf`vufsruwufsruwW`xwrf|fbgjpds`wjfpwgurpwbmrvfp`of,fpwfup`of,f|jwwfbipjtxfWb`pbfmaxwwrpwfbipjtxfWrlaxwwrpwfbipjtxfX`gwfuxsd`wfd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxw ov}vda ` :\/ =F61-70 3<51-60 )241-50 (31-40 21-30  11-20  1-10 0  VWWVWWXVXWYVYWZVZW[V[W\V\W]V]W%0  IdParentIdNameType DateCreate DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtraH r m0 Id ParentIdName        cs.........., s@@sej.@MSysIMEXSpecs.........., s@@count patients for Report1@@bc@ S_SSG;;;;;;9 `'`mm9@Xs@Example 04 query using criteria in different columns C@`@[ymmaUUUUUUS `$ym9@l5C@Example 01 query using the sort option and top valuesC@Ez@SznnbVVVVVVT `Bx@@Patients test controls@LWF000_@aUCC7777775 -n@A+@Example 22b Drugs not used in treatment (using in operator)[@@@ 2thh\\\\\\\Z @v@3@Example 22a Drugs not used in treatment (using exists operator)[@@ Sxll```````^ @ $2>@!u0@`Example 23 SQL create table@SH<<<<<<<<<: >-@-@Example 05a operator like using criteria in same column 8gK#z.P=*[%^'r_DcK=PatientsTreatment(@) =Drugs.[Drug name]) g=Treatment.Dosage( g=Patients.Gender' g=Drugs =Treatment =Patients = G= G= = < Patients.[Family name]. '< Patients.*" g<Patients < G< G< < ;drugstreatmentdrugs.DrugID = treatment.DrugIDE ;Patientstreatment(@) ;Patients.[Date of Birth]0 g;Patients.Gender' g;Patients.Initials) g;Patients.[Given name]- g;Patients.[Family name]. g;drugs.[Cost per packet]/ g;drugs.[Drug name]) g; treatment.*# g;Gtreatment ;GPatients ;Gdrugs ; G; G;G ;G :CountOfPatientIDCount(Patients.PatientID)A o:Patients : G: G: : 9DoctorsTreatment%@( 9DrugsTreatmentDrugs.DrugID = Treatment.DrugIDE 9PatientsTreatment(@) 9 Treatment.*# g9 Patients.*" g9Drugs.* g9 Doctors.*! g91-Treatment 91-Patients 91-Drugs 91-Doctors 9 G9 G91- 91- LVAL"c)p}\;['\-V3~oU7(}8; V Vx ?= DateDiff('m',[Date of Birth],Now())DateDiff('d',[Date of Birth],Now())/365.25Format([Date start course],'dddd')DatePart('w',[Date start course])Format([Date start course],'dddd')DatePart('w',[Date start course])Format([Date of Birth],"dddd mmmm d ")[Example 02 query using multiple tables].Gender[Example 02 query using multiple tables].[Drug name]Avg([Example 02 query using multiple tables].Dosage)Avg([Example 02 query using multiple tables].Dosage)[Example 02 query using multiple tables].Gender[Example 02 query using multiple tables].[Drug name]Patients.PatientID = Treatment.PatientIDAvg(IIf([Gender]='f',[dosage],Null))Avg(IIf([Gender]='m',[dosage],Null))IIf(IsNull([Town]),"unknown town",[town])IIf([Gender]='m','male','female')[Cost per packet]/[tablets per packet](((Count(Patients.PatientID))>2))(((Count(Patients.PatientID))>3))DAvg([tablets per packet],"drugs","[cost per packet]>.5")(((Patients.[Family name]) Like [first few letters of surname] & "*") AND ((Patients.Town)=[which town]))(((Patients.[Family name]) Like "m*") AND ((Patients.Postcode) Like "B[A-S]# *"))(((Patients.Town) In ("bristol","bath","keynsham")))((Patients.Town="bristol" Or Patients.Town="bath" Or Patients.Town="keynsham"))((Patients.Town="bristol")) OR ((Patients.Gender="f"))((Patients.[Family name] Between "b" And "l") AND (Patients.[Date of Birth] Between #01/1/60# And #12/31/69#) AND (Patients.PatientID Between 10 And 20))((Drugs.[Drug name]>"d") AND (Drugs.[Tablets per packet]>50))(((Patients.PatientID)<=10) AND ((Patients.Gender)="f") AND ((Patients.[Date of Birth])=#11/22/42#))Patients.PatientID = Treatment.PatientIDPatients.PatientID = treatment.PatientIDDoctors.DoctorID = Treatment.DoctorIDPatients.PatientID = Treatment.PatientIDVCY N    (        DoctorID Family name Given nameInitialsTitleInternal telephone j.rB.rC PrimaryKey@666*******( @F U G@h.@Example 21a percent costA-@@]QQE9999997 `E`vCS G@BS@Example 21 total costE %C@`@@ZNNB6666664 `DN@c G@qNN@Example 21 percent cost*@ @@\PPD8888886 `C@+ƛF@O*@Example 21 each drugP C@{@@YMMA5555553 `~A`GzF@J@Example 20 nested queryC@@@PDD88888886 @@ *F@"@Example 19 Range of valuesC@@@SGG;;;;;;;9 @?@-m9@.@Example 17b more date functions (C@Qc@dXXL@@@@@@> ` =m9@ A\@Example 18 date calculation@C@ THH<<<<<<<: @<`m9@f-@Example 17a date functions C@ec@_SSG;;;;;;9 `~:@m9@%t1@Example 22 Drugs not used in Treatment (unmatched query)C@@@qeeYYYYYYYW @96m9@w@Example 16 group iif@4@MAA55555553 @l~5@ym9@Y @Example 11 setting criteria on aggregate queries@@[i]]QQQQQQQO @~3gVF@Ft@Example 14 character functionI@fc@ SbVVJ>>>>>>< `2m9@sf@Example 13 unique values@?@QEE99999997 @ ~0`m9@^X@Example 09 query using aggregate query functions@z@uii]QQQQQQO `a{q @@ @ @@wfbipjtxfYo`burzfuvjrpprwjpmjvwwfbipjtxfYordxmfzfuvjrpprwjpmjvwwfbipjtxfY,duxhgruoxvfda}o`burzfuvjrp wfbipjtxfY,duxhgruoxvfda}ordxmfzfuvjrp wfbipjtxfZo`burzfuvjrpuxpwjof wfbipjtxfZordxmfzfuvjrpuxpwjof wfos,gruo,wr,`dd,wuf`wofpw,d`w` m`afmvs`wjfpwvs`wjfpwv,brs}gurogruos`wjfpwv,v`zf`vufsruwufsruwW`xwrf|fbgjpds`wjfpwgurpwbmrvfp`of,fpwfup`of,f|jwwfbipjtxfWb`pbfmaxwwrpwfbipjtxfWrlaxwwrpwfbipjtxfX`gwfuxsd`wfwfbipjtxfXbxuufpwwfbipjtxfXvruwwfbipjtxfYbmrvfwfbipjtxfYduxhxpmr`dwfbipjtxfYprwjpmjvwwfbipjtxfZrswjrpwfbipjtxfZrswjrp{urph`dojpd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfv`hf,u`phf`mm,jpgr ov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxw ov}vdar)9~zM6@ 9{M6@all_info''''''''''' \zM6@@zM6@age_range((((((((((( 8 \zM6@\zM6@Admin$$$$$$$$$$$ 7\zM6@\zM6@technique 4 option wrong77777777777 , xV:qP           ObjectId AttributeOrderName1Name2 ExpressionFlagilnzjtz ObjectIdAttribute  @".G@TreatmentL@666*******( @F U G@h.@Example 21a percent costA-@@]QQE9999997 `E`vCS G@BS@Example 21 total costE %C@`@@ZNNB6666664 `DN@c G@qNN@Example 21 percent cost*@ @@\PPD8888886 `C@+ƛF@O*@Example 21 each drugP C@{@@YMMA5555553 `~A`GzF@J@Example 20 nested queryC@@@PDD88888886 @@ *F@"@Example 19 Range of valuesC@@@SGG;;;;;;;9 @?@-m9@.@Example 17b more date functions (C@Qc@dXXL@@@@@@> ` =m9@ A\@Example 18 date calculation@C@ THH<<<<<<<: @<`m9@f-@Example 17a date functions 1|M6@1|M6@Doctors&&&&&&&&&&& :w{M6@w{M6@count patients for Report199999999999 9~zM6@ 9{M6@all_info''''''''''' \zM6@@zM6@age_range((((((((((( 8 \zM6@\zM6@Admin$$$$$$$$$$$ 7\zM6@\zM6@tech SparrowSimonSJDr3863 ? SprattLancelotLGHSir3865 ? TennantPaulPKMr2467 ? HudsonSarahSWDr2356 ? TurnerGrahamGADr2368 ?MortimerJamesJRDr2240 ?RajahRajeshARHDr3745 ?ReidLizEADr2365 ?DeVriesAdrianAFMr3874 ?DochertyErnestETMr3872 ?SmedleyCyrilJCMr2367 ?CollinAndrewALDr2235 ?MaitlandClaireCJDr2234 ? @          6*******( @F U G@h.@Example 21a percent costA-@@]QQE9999997 `E`vCS G@BS@Example 21 total costE %C@`@@ZNNB6666664 `DN@c G@qNN@Example 21 percent cost*@ @@\PPD8888886 `C@+ƛF@O*@Example 21 each drugP C@{@@YMMA5555553 `~A`GzF@J@Example 20 nested queryC@@@PDD88888886 @@ *F@"@Example 19 Range of valuesC@@@SGG;;;;;;;9 @?@-m9@.@Example 17b more date functions (C@Qc@dXXL@@@@@@> ` =m9@ A\@Example 18 date calculation@C@ THH<<<<<<<: @<`m9@f-@Example 17a date functions C@ec@_SSG;;;;;;9 `~:@m9@%t1@Example 22 Drugs not used in Treatment (unmatched query)C@@@qeeYYYYYYYW @96m9@w@Example 16 group iif@4@MAA55555553 @l~5@ym9@Y @Example 11 setting criteria on aggregate queries@@[i]]QQQQQQQO @~3gVF@Ft@Example 14 character functionI@fcVC N""    (  DrugID Drug nameTablets per packetCost per packet"$ .rB PrimaryKey       0  IdParentIdNameType DateCreate DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtraH r m0 Id ParentIdName        cs.........., s@@sej.@MSysIMEXSpecs.........., s@@count patients for Report1@@bc@ S_SSG;;;;;;9 `'`mm9@Xs@Example 04 query using criteria in different columns C@`@[ymmaUUUUUUS `$ym9@l5C@Example 01 query using the sort option and top valuesC@Ez@SznnbVVVVVVT `Bx@@Patients test controls@LWF000_@aUCC7777775 -n@A+@Example 22b Drugs not used in treatment (using in operator)[@@@ 2thh\\\\\\\Z @v@3@Example 22a Drugs not used in treatment (using exists operator)[@@ Sxll```````^ @ $2>@!u0@`Example 23 SQL create table@SH<<<<<<<<<: >-@-@Example 05a operator like using criteria in same column a{q @ @999999999 9 9 9 9 99:Z! eG,~ @@ @ @wfbipjtxfYo`burzfuvjrpprwjpmjvwwfbipjtxfYordxmfzfuvjrpprwjpmjvwwfbipjtxfY,duxhgruoxvfda}o`burzfuvjrp wfbipjtxfY,duxhgruoxvfda}ordxmfzfuvjrp wfbipjtxfZo`burzfuvjrpuxpwjof wfbipjtxfZordxmfzfuvjrpuxpwjof wfos,gruo,wr,`dd,wuf`wofpw,d`w` m`afmvs`wjfpwvs`wjfpwv,brs}gurogruos`wjfpwv,v`zf`vufsruwufsruwW`xwrf|fbgjpds`wjfpwgurpwbmrvfp`of,fpwfup`of,f|jwwfbipjtxfWb`pbfmaxwwrpwfbipjtxfWrlaxwwrpwfbipjtxfX`gwfuxsd`wfwfbipjtxfXbxuufpwwfbipjtxfXvruwwfbipjtxfYbmrvfwfbipjtxfYduxhxpmr`dwfbipjtxfYprwjpmjvwwfbipjtxfZrswjrpwfbipjtxfZrswjrp{urph`dojpd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfv`hf,u`phf`mm,jpgr brxpws`wjfpwvgruufsruwW drbwruv ov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxw ov}vda#{Gz?DG9Liquorice allsorts   333333?DG8Gobstoppers ?DG7Starballs 2(\?DG6M&Ms )\(?DG5Spangles q= ףp?DG4Polo mints 2333333?DG3Smarties ףp= ?DG2Jelly beans  Gz?DG14Mars bars Q?DG12Opal fruits HzG?DG11Marshmallows  ffffff?DG10Creme eggs d\(\?DG1Dolly mixtures !  @dhW#dhWV#dhWW#dhWX#dhWZ#dhX#dhY#dhZ#dh[#dh\# dh]# dh^# dh_# ParentIdNameType DateCreate DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtraH r m0 Id ParentIdName        cs.........., s@@sej.@MSysIMEXSpecs.........., s@@count patients for Report1@@bc@ S_SSG;;;;;;9 `'`mm9@Xs@Example 04 query using criteria in different columns C@`@[ymmaUUUUUUS `$ym9@l5C@Example 01 query using the sort option and top valuesC@Ez@SznnbVVVVVVT `Bx@@Patients test controls@LWF000_@aUCC7777775 -n@A+@Example 22b Drugs not used in treatment (using in operator)[@@@ 2thh\\\\\\\Z @v@3@Example 22a Drugs not used in treatment (using exists operator)[@@ Sxll```````^ @ $2>@!u0@`Example 23 SQL create table@SH<<<<<<<<<: >-@-@Example 05a operator like using criteria in same column 9{hMU6#i3}HuZ&xeR?,|]J7$ CPatients.[Family name]. gCPatients.[Given name]- gCPatients C GC GC C BO@ 'B Patients.Town% gBPatients.[Family name]. gBPatients.[Given name]- gBPatients B GB GB B A6@ 'APatients.Gender' gA Patients.Town% gAPatients.[Family name]. gAPatients.[Given name]- gAPatients A GA GA A @@ '@Patients.PatientID* g@Patients.[Date of Birth]0 g@Patients.[Family name]. g@Patients.Initials) g@Patients @ G@ G@ @ ?=@ '?Drugs.[Cost per packet]/ g?Drugs.[Tablets per packet]2 g?Drugs.[Drug name]) g?Drugs ? G? G? ? >d@ '>Patients.[Date of Birth]0 g>Patients.Gender' g>Patients.[Family name]. g>Patients.Title& g>Patients.PatientID* g>Patients > G> G> > =DrugsTreatmentDrugs.DrugID = Treatment.DrugIDE ' @ @ @ @ @ @ @999999999 9 9 9 9 99::::::;;;;;;;;;;; ;!;";#;$;%;<&<(<)<*<+< ,<'=-=/=0=1=2=3=4=5=6=7=%=.>%>%>%>%>%>%>%>% >% >% >%?% ?%?%?%?%?%?%?%?% @%@%@%@%@%@%@%@%@%@%A%A%!A%"A%#A%$A%%A%&A%'A%(A% B%)B%+B%,B%-B%.B%/B%0B%**:+&+ @ @ @ @ @ @ @=6=7=%=.>%>%>%>%>%>%>%>% >% >% >%?% ?%?%?%?%?%?%?%?% @%@%@%@%@%@%@%@%@%@%A%A%!A%"A%#A%$A%%A%&A%'A%(A% B%)B%+B%,B%-B%.B%/B%0B%1B%*C%2C%4C%5C%6C%7C%8C(C(C%3D(D(D(D(D(D(D( D( D(E( E( E(E(E(E(E(E(E( F(F(F(F(F(F(F(F(F(F(G(G( G(!G("G(#G($G(H(%H('H((H()H(&I(*I(,I(+9|iNtaN3gTA.g; k%xeR?$pD  @J GJ GJ J I DCount(Patients.Town)- /I DCount(Patients.PatientID)2 /I  Patients.Town% gICountOfTownCount(Patients.Town)7 oINumber of patientsCount(Patients.PatientID)C oI Patients.Town% gIPatients I GI GI I Haverage no when packet costs more than 50p9@ B66 oHDrugs H GH H Gmost in packetMax([Tablets per packet])? oGaverage no of tabletsAvg([tablets per packet])F!! oGDrugs G GG GG G Fi@  'F Patients.Town% gFPatients.[Family name]. gFPatients.[Given name]- gFPatients.Initials) gFPatients F GF GF F E(((Patients.Town) Is Null))3 'E Patients.Town% gEPatients.[Family name]. gEPatients.PatientID* gEPatients E GE GE E DQ@  'DPatients.Postcode) gDPatients.[Family name]. gDPatients.Initials) gDPatients D GD GD D C4@  'C Patients.Town% g<@ @ @@ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfv1vt,bbroarWvwrujph`pjd1vt,bduxhjdP 1vt,bbroarX`xwrmrrlxs1vt,bduxhjd1vt,bbroarYdmrrlxs1vt,bdrbwrujd1vt,bbroarZmjplduxhvwrwuf`wofpwvxagruo1vt,bduxhjd1vt,bbroarZmjplduxhvwrwuf`wofpwvxagruo1vt,bfoafddfdW1vt,bbroar[z`mxfvguro`broarar|1vt,bduxhjd1vt,bbroar[z`mxfvguro`broarar|1vt,bs`wjfpwjd1vt,bduxhsjfbi`uw1vt,bfoafddfdV1vt,bs`wjfpwvwfvwbrpwurmv1vt,bwjwmf1vt,bvxagruoXrpfo`p}rpf1vt,bduxhgruo1vt,bvxagruoXrpfo`p}rpf1vt,bvfbrpdvxagruo1vt,bwfbipjtxfXgjpdufbrud1vt,bdrbwrujdP1vt,bwfbipjtxfXgjpdufbrud1vt,bduxhjdP1vt,bwfbipjtxfXgjpdufbrud1vt,bvfmfbws`wjfpwP1vt,bwfbipjtxfXo`burzfuvjrpgjpdufbrud1vt,bdrbwrujdP1vt,bwfbipjtxfXo`burzfuvjrpgjpdufbrud1vt,bduxhjdP1vt,bwfbipjtxfXo`burzfuvjrpgjpdufbrud1vt,bpr,wuf`wofpwP1vt,bwfbipjtxfXo`burzfuvjrpgjpdufbrud1vt,bvfmfbws`wjfpwP1vt,bwfbipjtxfXordxmfa`vjbzfuvjrpgjpdufbrud1vt,bdrbwrujdP1vt,bwfbipjtxfXordxmfa`vjbzfuvjrpgjpdufbrud1vt,bduxhjdP1vt,gbroarWvwrujph`pjdP1vt,gbroarYdmrrlxs1vt,gbroarZ,wuf`wofpwvxagruoP1vt,gbroar[z`mxfvguro`broarar|P 1vt,gs`wjfpwv1vt,gs`wjfpwvwfvwbrpwurmvmjlfxvjphbujwfuj`jpv`ofbrmxopf|`osmfV\txfu}xvjphmjlff|`osmfV]wfvwjphgruxplpr{pz`mxfvf|`osmfV^suroswfdtxfu}f|`osmfV_txfu}xvjph`hhufh`wftxfu}gxpbwjrpvf|`osmfV_`txfu}xvjphdro`jp`hhufh`wfgxpbwjrpv*ov}vda current22222222222 _F4mE?;Dp CEA%!A __i_iM6@M6@Example 22a Drugs not used in treatment (u_v@3@Example 22a Drugs not used in treatment (using exists operator)[@@xll```````^ @] U G@h.@Example 21a percent cost@@QEE99999997 @\`vCS G@BS@Example 21 total costC@@@NBB66666664 @Z@+ƛF@O*@Example 21 each drugC@@@MAA55555553 @Y`GzF@J@Example 20 nested queryC@@@PDD88888886 @X *F@"@Example 19 Range of valuesC@@@SGG;;;;;;;9 @ Vm9@ A\@Example 18 date calculation@ @THH<<<<<<<: @U@-m9@.@Example 17b more date functionsC@ @XLL@@@@@@@> @T`m9@f-@Example 17a date functionsC@ @SGG;;;;;;;9 @ Rm9@"j@Example 16a Crosstab alternative to group iifg@@fZZNNNNNNNL @Q6m9@w@Example 16 group iif@@MAA55555553 @ Oo m9@@Example 15 iifC@@G;;///////- @NgVF@Ft@Example 14 character function@@VJJ>>>>>>>< @Mm9@sf@Example 13 unique values@@QEE99999997 @L`y}m9@:@Example 12 query using arithmetic@@ZNNBBBBBBB@ @ J@ym9@Y @Example 11 setting criteria on aggregate queries@@i]]QQQQQQQO @I ?4m9@o{3@Example 10 calculation on a group@@ZNNBBBBBBB@ @HdX@z@Example 09a query using domain aggregate functionsf@ @k__SSSSSSSQ @'- @ @ @ @ @ @ @C%2C%4C%5C%6C%7C%8C(C(C%3D(D(D(D(D(D(D( D( D(E( E( E(E(E(E(E(E(E( F(F(F(F(F(F(F(F(F(F(G(G( G(!G("G(#G($G(H(%H('H((H()H(&I(*I(,I(-I(.I(/I(0I(1I (2I (3I (4I(+J(5J(7J(8J,J,J,J,J ,J ,J ,J ,J ,J(6K, K, K, K, K,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,%'8|@dQ>+^2wGkXE2q@g9 @ @PPatients P GP GP P OPatients.PatientID* gOPatients.Gender' gOgendername!@" oOPatients O GO GO O Nfirst letter capitalisedStrConv([addr1],3)B$$ oNtowns UCase([Town])* oNPatients N GN GN N M Patients.Town% gMPatients M GM GM M L ((Drugs.[Tablets per packet]>0))8 'Lcost_per_tablet&@' oLDrugs.[Cost per packet]/ gLDrugs.[Tablets per packet]2 gLDrugs.[Drug name]) gLDrugs L GL GL L K Count(Patients.PatientID)1 'K !@ 'K  Patients.Town% gK((Patients.Gender="f"))/ 'KcountCount(Patients.PatientID)6 oK Patients.Town% gKPatients K GK GK K J  Patients.Town% 'J DCount(Patients.PatientID)2 /J !@  'J  Patients.Town% gJ  Patients.Town% gJ(((Patients.Town) Like "B*"))5 'JcountCount(Patients.PatientID)6 oJ Patients.Town% gJPatients +/ @ @ @ @ @ @ @I(/I(0I(1I (2I (3I (4I(+J(5J(7J(8J,J,J,J,J ,J ,J ,J ,J ,J(6K, K, K, K, K,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,%O,+O,-O,.O,/O,0O,1O,2O,,P,3P,5P,6P,7P.P.P.P,4Q.Q.Q.Q.Q.Q. Q. Q. Q. Q. Q.Q .Q.R.R.R.R.R.R.R.R.R .R .R.S.S.S.S.S. S.!S."S.#S.T.$T.%8iVC0wN|iVnO<)|Op:|`< V U "@ gU !@ gUCountOfPatientIDCount(Treatment.PatientID)B oUday"@ oUdayno!@ oUTreatment U GU GU U TyearYear([Date of Birth])1 oTmonthMonth([Date of Birth])3 oTdayDay([date of birth])/ oTPatients.[Date of Birth]0 gTPatients T GT GT T SYearFormat([date of birth],"yyyy"): oSformatted date'@& oSPatients.[Date of Birth]0 gSPatients.[Family name]. gSPatients S GS GS S R /@ gR 4@ gRRow Summary4@# oRThe Value4@! oR/@ gR4@ gRExample 02 query using multiple tables222 R GR GR R Q Drugs.[Drug name]) gQDrugsTreatmentDrugs.DrugID = Treatment.DrugIDE QPatientsTreatment(@) Qfemaledose$@" oQmaledose$@  oQDrugs.[Drug name]) gQDrugs QTreatment QPatients Q GQ GQ Q Pusing nznz([town],"unknown town")9 oPusing isnull)@$ oP Patients.Town% g-2 @ @ @ @ @ @ @N,%O,+O,-O,.O,/O,0O,1O,2O,,P,3P,5P,6P,7P.P.P.P,4Q.Q.Q.Q.Q.Q. Q. Q. Q. Q. Q.Q .Q.R.R.R.R.R.R.R.R.R .R .R.S.S.S.S.S. S.!S."S.#S.T.$T.&T.'T.(T.)T.*T.+T.,T.%U.-U./U.0U.1U.2U.3U.4U .5U .6U..V.7V0V0V0V0V0V0V0V0V0W0 W0 W0 W0 W0W0W0 X0X0X0X0X0X0X0X0X 0X0Y0Y0Y0Y0Y0Y0 Y0!Y0"Y0<w@oH#n&qU%xeR?# g7$}>111h_t112i\Treatment \ G\ G\ \ [percent[drug_cost]/[total cost]7 o[ [Example 21 each drug].drug_cost8 g["@1 g[Example 21 total cost!!! [Example 21 each drug [ G[ G[ [ Z Drugs.[Drug name]) gZDrugsTreatmentDrugs.DrugID = Treatment.DrugIDE Zdrug_cost/@1! oZDrugs.[Drug name]) gZDrugs ZTreatment Z GZ GZ Z Y:@1 'YDrugsTreatmentDrugs.DrugID = Treatment.DrugIDE YTreatment.Dosage( gYDrugs.[Drug name]) gYTreatment YDrugs Y GY GY Y X age_range.age_range+ gXL@1 'XCountOfPatientIDCount(Patients.PatientID)A oXage_range.age_range+ gXage_range XPatients X GX GX X Woldest/@1 oWyoungest/@1  oWPatients W GW GW W Vagey&@1 oVmonths#@! oVage*@  oVPatients.[Date of Birth]0 gVPatients.[Family name]. gVPatients V GV GV LVAL |0vR 2oooooooooV|Op:|`< @ @U "@ gU !@ gUCountOfPatientIDCount(TreatmeSELECT Patients.PatientID, [Patients].[Given name] & " " & [Patients].[Family name] AS patient, [Doctors].[Title] & " " & [Doctors].[Family name] AS doctor, Diagnosis.[Date seen] as date_happening, Diagnosis.diagnosis FROM Patients INNER JOIN (Doctors INNER JOIN Diagnosis ON Doctors.DoctorID = Diagnosis.DoctorID) ON Patients.PatientID = Diagnosis.PatientID (([__patientid] = patientid)) AND ([__DrugID] = DrugID)Doctors.DoctorID = Treatment.DoctorID[given Name] & " " & [family Name](((Treatment.[Date start course]) Between [Forms]![Technique 1 module basic version- Dialog Box]![begin Date] And [Forms]![Technique 1 module basic version- Dialog Box]![end Date]))Patients.PatientID = Treatment.PatientID[given Name] & " " & [family Name][given Name] & " " & [family Name](((Treatment.[Date start course]) Between [Forms]![Technique 1 macro version- Dialog Box]![begin Date] And [Forms]![Technique 1 macro version- Dialog Box]![end Date]))Patients.PatientID = Treatment.PatientID[given Name] & " " & [family Name]DateDiff('d',[date start course],[date end course])create table Drugssql( DrugID text(6) constraint drugtableconstraint primary key, Drugname text(40) not null, Tablets_per_packet integer, Cost_per_packet currency);drugid not in (select drugid from Treatment )not exists(select * from Treatment where Drugs.DrugID = Treatment.DrugID)[Example 21 total cost].[total cost]Sum([Dosage]*[cost per packet]*[doses per day])[Example 21 each drug].[Drug name]Sum([Dosage]*[cost per packet]*[doses per day])((Treatment.Dosage=(select max([dosage]) from treatment)))(((DateDiff('m',[DATE OF BIRTH],Now())/12) Between [AGE_MIN] And [AGE_MAX]))Max(DateDiff('d',[Date of Birth],Now())/365.25)Min(DateDiff('d',[Date of Birth],Now())/365.25)DateDiff('yyyy',[Date of Birth],Now())/5 @ @ @ @ @ @ @T.(T.)T.*T.+T.,T.%U.-U./U.0U.1U.2U.3U.4U .5U .6U..V.7V0V0V0V0V0V0V0V0V0W0 W0 W0 W0 W0W0W0 X0X0X0X0X0X0X0X0X 0X0Y0Y0Y0Y0Y0Y0 Y0!Y0"Y0#Y0Z0$Z0&Z0'Z0(Z0)Z0*Z0+Z0,Z 0-Z0%[0.[00[01[02[03[04[05[06[0/\07\09\0:\0;\4\4\4\08]4]4]4]4]4]4 ]4 ]4 ]4 ]4 ] 4] 4]4^4^4^4^4^4^4^4^4^4^4_4_4 HH08@ @@@    @@@@f|`osmfWVb`mbxm`wjrprp`hurxs*f|`osmfWWvfwwjphbujwfuj`rp`hhufh`wftxfujfv*f|`osmfWW``prwifuhurxsbujwfuj`f|`osmf*f|`osmfWXtxfu}xvjph`ujwiofwjb*f|`osmfWYxpjtxfz`mxfv*f|`osmfWZbi`u`bwfugxpbwjrp*f|`osmfW[jjg*f|`osmfW[`jjg{jwipxmmz`mxfv*f|`osmfW\hurxsjjg* f|`osmfW\`burvvw`a`mwfup`wjzfwrhurxsjjg* f|`osmfW]d`wfgruo`w* f|`osmfW]`d`wfgxpbwjrpv* f|`osmfW]aorufd`wfgxpbwjrpv* f|`osmfW^d`wfb`mbxm`wjrp*f|`osmfW^`rmdfvw`pd}rxphfvw*f|`osmfW_u`phfrgz`mxfv*f|`osmfXVpfvwfdtxfu}*f|`osmfXWf`biduxh*f|`osmfXWsfubfpwbrvw*f|`osmfXWwrw`mbrvw*f|`osmfXW`sfubfpwbrvw*f|`osmfXXduxhvprwxvfdjpwuf`wofpwxpo`wbifdtxfu}*f|`osmfXX`duxhvprwxvfdjpwuf`wofpwxvjphf|jvwvrsfu`wru*f|`osmfXXaduxhvprwxvfdjpwuf`wofpwxvjphjprsfu`wru6ov}v`bfvov}vjof|brmxopv6ov}vjof|vsfbv6ov}vordxmfv6ov}vordxmfvX6ov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsvs`wjfpwv6vtmbuf`wfw`amf6wfbipjtxfWo`burgruo6wfbipjtxfWordxmfgruo6 wfbipjtxfZgruoaujvwrm6 wfbipjtxfZgruoprpaujvwrm6 wfvwvsmjw`ddufvvPwfvwvsmjwp`ofwuf`wofpw6 wuf`wofpwdfw`jmvf|wfpdfdgruo6 wuf`wofpwv`pddj`hprvjvxvjphgjfmdf|sufvvjrpvjpgjfmdf|sufvvjrpv6`bbfvvm`}rxw ov}vdadrbwruvdj`hprvjvs`wjfpwvdj`hprvjvufgfufpbf6ufgfufpbfW6ufgfufpbfX6ufgfufpbfYa query using domain aggregate functionsQQQQQQQQQQQ 8s`M:'Y r_L9!^#wXE2zgH5"`: c c bDrugsTreatmentDrugs.DrugID = Treatment.DrugIDE bday_times_dose[no_days]*[doses per day]? obno_days3@ 1 obTreatment.[Doses per day]1 gbDrugs.[Drug name]) gbDrugs bTreatment b Gb Gb b a@ 1 ga a `-@ 1 '`Drugs.[Drug name]) g` Drugs.DrugID$ g`Drugs ` G` ` _I@ 1 '_Drugs.[Drug name]) g_ Drugs.DrugID$ g_Drugs _ G_ _ ^((Treatment.DrugID Is Null))4 '^DrugsTreatmentDrugs.DrugID = Treatment.DrugIDE ^Drugs.[Drug name]) g^ Drugs.DrugID$ g^Treatment ^Drugs ^ G^ G^ ^ ] $@1 g] Drugs.[Drug name]) g]DrugsTreatmentDrugs.DrugID = Treatment.DrugIDE ]percent[cost]/[total cost]2 o]costSum([dosage]*[cost per packet]); o]Drugs.[Drug name]) g]Treatment ]Drugs ]Example 21 total cost!!! ] G] G] ] \DrugsTreatmentDrugs.DrugID = Treatment.DrugIDE \total cost/@1" o\Drugs 2 @ @ @ @ @ @ @Z0$Z0&Z0'Z0(Z0)Z0*Z0+Z0,Z 0-Z0%[0.[00[01[02[03[04[05[06[0/\07\09\0:\0;\4\4\4\08]4]4]4]4]4]4 ]4 ]4 ]4 ]4 ] 4] 4]4^4^4^4^4^4^4^4^4^4^4_4_4_4_4_4_4 _4`4!`4#`4$`4%`4&`4'`4"a4(a4*a4)b4+b4-b4.b4/b40b41b42b43b44b45b4,c46cccccccc c c47d d d d dddddd d d eeee5|/+Gq40Dk$M߀o^#NlF@Ϟ@NlF@Ϟ@Subform 2_(drug form)o@LWF000@`TBB6666664 @ojF@=@Subform 1_(subform)r@LWF000@^R@@4444442 qgF@2k@Normal1@LWF000@QE33''''''%  `VeF@y{`@Combo 4_(treatment subform)m@LWF000l@fZHH<<<<<<:  dF@(c@Combo 4- Link drugs to treatment Subform@LWF000\@sgUUIIIIIIG #aF@^2k@Combo 2 - AutoLookup}@LWF000Y_SAA5555553  !11@W۱ @AccessLayout*@z E99-------+ @j".G@".G@Reference2++++++++++) i ߰0@ ߰0@Reference1++++++++++) h@O0@@O0@Reference**********( ggF@6}0@Treatment Details (Extended form)f@@ZNNBBBBBBB@ @1;+@/z1 @Treatment e666*******( @e רu@U<$@technique 4 form bristolO@ @QEE99999997 @dhF@TP@technique 1 module form@ @@PDD88888886 @cCP@P@technique 1 macro form@ @@OCC77777775 @䷳+@ĔH23 @Patients@555)))))))' @@[?²@[@²@MSysModules2----------+ >[@²@~A²@MSysModules,,,,,,,,,,* ;sej.@MSysIMEXSpecs.........., 7?j.@?j.@MSysIMEXColumns0000000000. a $2>@Ur; 3 @`SQL create table@=111111111/ `-n@A+@Example 22b Drugs not used in treatment (using in operator)[@@@thh\\\\\\\Z @VCN88 25  =  s @      AttributesDataType FieldName IndexType SkipColumnSpecIDStartWidth89N8: Index1 PrimaryKey  ! " # $ %&'()*+,-./0123456789 : ; <=>?@ABCDEFGH*I*J*K*L*M*N*O*P*Q* R* S* T* U* V*W*X*Y*Z*[*\*]*^*_*`6a6 ! ov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxw ov}vdaDrugs ^ G^ G^ ^ ] $@1 g] Drugs.[Drug name]) g]DrugsTreatmentDrugs.DrugID = Treatment.DrugIDE ]percent[cost]/[total cost]2 o]costSum([dosage]*[cost per packet]); o]Drugs.[Drug name])   FlagMSysQueriesFlag00,!!  ExpressionMSysQueriesExpression<<2''  Name2MSysQueriesName222-""  Name1MSysQueriesName122-""  AttributeMSysQueriesAttribute::1&&{qM:'Y r_L9!^#wXE2zgH5"`: @ @ @bday_times_dose[no_days]*[doses per day]? obno_days3@ 1 obTreatment.[Doses per day]1 gbDrugs.[Drug name]) gbDrugs bTreatment b Gb Gb b a@ 1 ga a `-@ 1 '`Drugs.[Drug name]) g` Drugs.DrugID$ g`Drugs ` G` ` _I@ 1 '_Drugs.[Drug name]) g_ Drugs.DrugID$ g_Drugs _ G_ _ ^((Treatment.DrugID Is Null))4 '^DrugsTreatmentDrugs.DrugID = Treatment.DrugIDE ^Drugs.[Drug name]) g^ Drugs.DrugID$ g^Treatment ^Drugs ^ G^ G^ ^ ] $@1 g] Drugs.[Drug name]) g]DrugsTreatme7            ! " # $ %&'()*+,-./0123456789 : ; <=>?@ABCDEFGH*I*J*K*L*M*N*O*P*Q* R* S* T* U* V*W*X*Y*Z*[*\*]*^*_*`6a6b6 ! @Patients test controls@LWF000_@aUCC7777775 -n@A+@Example 22b Drugs not used in treatment (using in operator)[@@@ 2thh\\\\\\\Z @v@3@Example 22a Drugs not used in treatment (using exists operator)[@@ Sxll```````^ @ $2>@!u0@`Example 23 SQL create table@SH<<<<<<<<<: >-@-@Example 05a operator like using criteria in same column 7Z0$Z0&Z0'Z0(Z0)Z0*Z0+Z0,Z 0-Z0%[0.[00[01[02[03[04[05[06[0/\07\09\0:\0;\4\4\4\08]4]4]4]4]4]4 ]4 ]4 ]4 ]4 ] 4] 4]4^4^4^4^4^4^4^4^4^4^4_4_4_4_4_4_4 _4`4!`4#`4$`4%`4&`4'`4"a4(a4*a4)b4+ operator)[@@@ 2thh\\\\\\\Z @v@3@Example 22a Drugs not used in treatment (using exists operator)[@@ Sxll```````^ @ $2>@!u0@`Example 23 SQL create table@SH<<<<<<<<<: >-@-@Example 05a operator like using criteria in same column VCN <<            @      eD DateDelimDateFourDigitYearDateLeadingZeros DateOrder DecimalPointFieldSeparatorFileTypeSpecIDSpecNameSpecTypeStartRow TextDelim TimeDelimp/@<=  PrimaryKeyiBI:H;:m; < =  @4 9 rrr@ 8Q ;xxx@ <Q ;vvv@ @Q y?tttq@D a @H  ppp3?0 0  0 x  K9/'h%x"$ `x ,x5h<'4'D'Td xx ,>dFh x6hTD4 6H$ y $dxhTD40   @8C__SRP_3rU T$`$)`$i` $` pa{qJ<1 msM?@      !         (  doctors.family NamedoctorsFamily namedoctors.doctorIDDoctorID      |AU@   0P  0P doctors x    x-G@9~sq_cTechnique 3 module version- Not in List~sq_cDoctorID  H X  ` p  [family Name]H [doctorID]`  0PG 0P GDoctorID Family namedoctors      ` DoctorIDH Family name     @ H P X `                                    p  @ `|     P  P   P 0   P  doctors0 PrimaryKeyH  v c0@y,Ų@Formstemp_form_to_add_treatment_dataI*% @OyF@En@Fo ;            ! " # $ %&'()*+,-./0123456789 : ; <=>?@ABCDEFGH*I*J*K*L*M*N*O*P*Q* R* S* T* U* V*W*X*Y*Z*[*\*]*^*_*`6a6b6 ! 76Treatment 7 7 7( 7 70 7 78 7 7@ 7 "7H 7 :7P 7 R7X 777777707H7 777 `7@7`7777` 7 7` 7 7` 7 7` 7 7` 7 7` 7 7` 7 7` 7 7` 7 7` 7 7` 7 7` 7 7` 7 7` 7 7` 7 7` 7 7` 7 7` 7 7` 7 7` 7 7` 7 7` 7 7` 7 7` 7 7` 7 7` 7 7` 7 7` 7 7` 7 7` 77`777@7 7 p7 7 @7 7 @7 7 @7 7 @7 7 @VCEN?? __A__ @ @ @ @ @ @ @ @ ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  ۇ  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  ۇ  ۇ O8V#jK ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  ۇ  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  ۇ  ۇ O8V#jK ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  ۇ  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  ۇ  ۇ O8V#jK ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  ۇ  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  ۇ  ۇ O8V#jK ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Vx ?=  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o   Vx ?=  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o   Vx ?=  Yb;  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o  {<2 ^n sXM?^^^^J   ^^^^^^^^  patients.patientIDpatients PatientIDName^^^^ ^=@^^ ^P ^P patients^`^^ ^^۱0@9~sq_cTEchnique 4 macro version-Runtime~sq_cbristolPatient^ 8^P^ ^X^Patients.[patientID]8^^p^P PatientIDpatients ^^8^ PatientIDpatients ^ ^ ^ ^@^H^P^X^`^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^^^^ ^ @^ ^`p^ ^ p^ ^ |^ 8^^H^P^0 ^` ^ ^ ^ ^0 ^ ^0P ^0 ^,\ ^h ^ ^l ^x ^ ^| ^ ` ^ [given Name] ^" " ^  ^ [family Name]^X ^ ^ ^ ^^ ^patientsh^x^PrimaryKey PatientID^^v ^x^ 0J VCe NAA              "FlagsFormModuleNameReplicationVersionTypeTypeInfoVersioncDep yAIndex1AAAfd     PatientPatients Patients   GPatients  Patients   GPatients   PatientPatientPatients Patients   GPatients  Patients   GPatients   PatientPatientPatientPatients PatientPatientPatientPatients PatientPatientPatientPatients PatientPatientPatientPatients {qg<8 t sXM?J     patients.patientIDpatients PatientIDName s=@ P P patients` ۱0@<~sq_cTEchnique 4 macro version-Runtime~sq_cnonbristolpatient 8P XPatients.[patientID]8pP PatientIDpatients 8 PatientIDpatients    @HPX`                               @ `p  p  |!! <8gx@@`CLVAL C<;I's@M? ;I;Ix ;I;I  y;I;I;I;I;I;I ;I!;I1;IA;IQ;Ia;Iy;I;Ip;I;I;I;I;I;I;I;I(;I8;IH;IX;Ip;I;I;I;I;I;aI;I;I;I;I;I;I;I;I;I;Iy;I;I;I;I;I;I ;I!;I1;IA;IQ;Ia;Iy;I;I   (                                        Patients.PatientIDPatientsPatients.Family namePatients.Given namePatients.InitialsPatients.Title&Patients.GenderPatients.Date of BirthPatients.Addr1Patients.Addr2 Patients.Town!Patients.CountyPatients.PostcodePatients.CountryPatients.TelephoneH;I@;Ih;I0;I ;IxV@X;Ih;I y;IxP ;IxP ;IxP ;IxP ;IxP ;IxP  ;IxP !;IxP 1;IxP A;IxP Q;IxP a;IxP y;IxP ;IxP Patients ;I ;I ;IX;I;I۱0@ ~sq_fPatientsh;I p;Ix ;I ;I ;I ;I ;I ;I ;I ;I ;I ;I ;I ;I ;I ;I ;I (;I ;I  8;I ;I  H;I ;I  X;I ;I  p;I ;I  ;I ;Ip;I;I;I;I;I;I;I;I(;I8;IH;IX;Ip;I;Iy;IxP ;IxP ;IxP ;IxP;IxPLv;IxP  ;IxP !;IxP 1;IxP A;IxP Q;IxP a;IxP y;IxP ;IxP Patients y;I ;I ;I ;I ;I ;I ;I ;I ;I( ;I ;I0 ;I ;I8 ;I !;I@ ;I 1;IH ;I A;IP ;I Q;IX ;I a;I` ;I y;Ih ;I ;Ip ;Ip;I;ILVAL D;I;I;I;I;I;I(;I8;IH;IX;Ip;I;I ;I;IH;I ;I@;Ix;I;I;I ;Ix ;I ;Ix ;I ;Ix ;I ;Ix ;I ;Ix ;I ;Ix ;I ;Ix ;I ;Ix ;I ;Ix ;I ;Ix ;I ;Ix ;I ;Ix ;I ;Ix ;I ;Ix ;I ;Ix ;I ;Ix ;I ;Ix ;I ;Ix ;I ;Ix ;I ;Ix ;I ;Ix ;I ;Ix ;I ;Ix ;I ;Ix ;I ;Ix ;I ;Ix ;I ;Ix ;I ;Ix ;I ;Ix ;I ;Ix ;I;I8;I;I;I@;IX;I`p;IX;I p;IX;I p;IX;I p;IX;I p;IX;I @;IX;I p;IX;I p;IX;I p;IX;I  p;IX;I  p;IX;I  p;IX;I  p;IX;I  |;I ;I;I;IxPh;I;I;Ih;I;Ix;IH;I;Ix;I;I;I;I;I;I;I;I8;I;Ih;I;I;I;I;I;I;I;I(;I(;I;I ;I ;I H;I x;I ;I;I ;I 8;I h;I ;I ;I ;I (;I`8X;I`;Ih;Ip;Ix;I;I;I;I;I;I;I;I;I;I;I;I;IH;Ix;I;I;I;I8;Ih;I;I;I;I(;IX;IPatients;I;IPrimaryKey PatientID(;I;Iv 0;I;I ;I;I;Is;I;I;I;I;I;I;I;I;I;I;I;I;I;I;I;I;I;I;I;I;I;I;I;I;I;I;I;I;I;I x ;I;Ip;I;I;IPatients PrimaryKey@;I;I0;I8;I0LVAL;I@;I;I;I`;I;I;IX;ILVAL i_VBA_MODULE x'}ECO ( ``@@ I  `@  AI user ` @  reI @\ `H$h(@l .\ @L @< P@, @   ( @ hl \ @L P< @, $ $p@ @ )5e g3h hl 666&L @< men, R@  NeLVAL G< w+< slM?w+w+P w+w+! w+w+w+w+w+"w+:w+Rw+w+w+w+w+w+w+0w+Hw+w+w+w+w+w+w+w+w+w+w+w+w+w+"w+:w+Rw+                treatment.PatientID treatmenttreatment.DrugIDtreatment.DoctorIDtreatment.Date start coursetreatment.Date end coursetreatment.Dosagetreatment.Frequencytreatment.Doses per dayw+w+ (w+w+ `w+jo@w+w+ w+0!O w+0!O w+0!O w+0!O w+0!O "w+0!O :w+0!O Rw+0!O treatmentw+@w+w+w+`w+".G@ ~sq_fCombo 4_(treatment subform)w+ w+w+ w+w+ w+w+ w+w+ w+ w+ w+(w+ 0w+0w+ Hw+8w+w+w+w+w+w+w+0w+Hw+w+0!O w+0!O w+0!O w+0!O w+0!O "w+0!O :w+0!O Rw+0!O treatment w+ w+ w+ w+ w+ w+ w+( w+ w+0 w+ "w+8 w+ :w+@ w+ Rw+H w+w+w+w+w+w+w+0w+Hw+ w+w+w+ `w+@w+`w+w+w+w+P w+ w+P w+ w+P w+ w+P w+ w+P w+ w+P w+ w+P w+ w+P w+ w+P w+ w+P w+ w+P w+ w+P w+ w+P w+ w+P w+ w+P w+ w+P w+ w+P w+ w+P w+ w+P w+ w+P w+ w+P w+ w+P w+ w+P w+ w+P w+ w+P w+ w+P w+ w+P w+ w+P w+ w+P w+ w+P w+w+`w+w+w+@w+w+ pw+w+ @w+w+ @w+w+ @w+w+ @w+w+ @w+w+ @w+w+ |w+LVALN ?_ @ @ @@ B w+xw+w+H#Ow+ w+ w+ w+ w+0w+ w+@w+Pw+Pw+w+`w+w+pw+w+w+ w+  w+ w+ w+Pw+w+w+w+H Pw+Xw+`w+hw+pw+xw+w+w+ w+ w+ w+ w+Pw+w+w+w+w+ treatmentw+ w+w+Reference2 Reference1 Referencew+w+v w+w+w+w+w+sw+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+hw+ P w+xw+Xw+w+w+treatment Reference2@w+w+w+w+w+@w+w+xw+Hw+xw+w+w+LVAL U@L<Y@Qs@M? Q QpQ8 QQ(Q  QQ Expr1000QQXQPQ QP@xQQ Q0AT treatmentQQQQ".G@<~sq_cTechnique 2 macro version- Find record~sq_cno_treatmentQ QQQ treatment(QPQ0Q[selectpatient](Q QQHQ$Q@QHQPQXQ`QpQ QpQ QpQ QpQ QpQ QpQ QpQ QpQ QpQ QpQ QpQ QpQ QpQ QpQ QpQ QpQ QpQ QpQ QpQ QpQ QpQ QpQ QpQ QpQ QpQ QpQ QpQ QpQ QpQ QpQQxQ QQv  Q Q0Q Q@ ` Qh QQQ Q0QzQ QQ` Q  Q Q QQQ treatment@Q8 Q Q`QQ8 Q`Q pQxQQ ReferenceQQ (Q[selectpatient]QQQ QQ  QQQQQ Q8 QQ@Q Q@Q QQQQQ|H Q0Q0Q0Q0Q0Q0Q0Q0Q0Q0Q0Q0Q0Q0Q0Q0Q0Q0Q0Q0Q0Q0Q0Q0Q0Q0Q0Q0Q0Q0QQ}H QQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQ@tM? L LpL8 LL(L L@U Dhx<nn<< @tMSysDb #tMSysDb #split address*&&" Esplit name'##Form_TEchnique 4 macro version-Runtime[WKGCForm_Technique 4 module version- Runtime]YMIEj Form_Technique 3_(drug form used by macro version)$gcWSO Form_Technique 3 macro version- not in listT`\PLHyiForm_Technique 3_(drug form used by module version)$hdXTP Form_Technique 3 module version- Not in ListTa]QMI*Form_Technique 1_(treatment form used by module dialog box form)uqea]'Form_Technique 1_(Treatment form used by macro dialog box form)tpd`\wForm_Technique 1 module basic version- Dialog BoxfbVRN~${Form_Technique 1 macro version- Dialog boxz_[OKG xH"sForm_Technique 2 module basic version- Find RecordrgcWSO plForm_Technique 2 macro version- Find recordk`\PLHDXUReport_Patients_saveasreportTQMA=9YS@PForm_frontOg?;/+'F MF KForm_Technique 2 - Find RecordJSOC?;]P!\Form_Patientsa B>2.*hLVALt8u1Lu1Lu1Lu1Lw^w^w^w^}H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H }H ~H~H~H~HHHHHHHHHH HͬO%T4 `U(FormHeader0d Text131Detail0eBox103eBox102eBox101eBox100eBox99e Box98m PatientIDd Text43m English_NameEnglish Named Text48mQuantity_Per_UnitQuantity Per Unitd Text49mFrequencyd Text50oDRugIDd Text110eBox121mProduct_NameProduct Named Text123oDoctorIDd Text126d Text129FormFooter1Date start courseDate end courseDosageDoses per dayoselectPatientLVAL Li_VBA_MODULE! _K`U(O%T4 `U(xmE2FW [LS S<$<(<<<<< <,<0<4<8<<<N0{54251E4F-0934-11D3-80A5-006008552884}y7($`h@  x0 $H0p $2  $P $ $ $ $2 $ $   $2P $ $D`4@$ 2X`h X (e 00( pME "  JX ` " Bh @(  hUx  0LVALEޖ4 M<Mޖ<8 MMUޖ8 MM%ޖpt8 M8M%%UޖH5 MMEuU%ޖ7 MMeeeeeeuuޖ ME4M%eUUߖP/ MFMߖP/ MGMߖP/ M10MWߖP/ MMޖP/ MMUޖ M,Mߖ MMDWhen user changes records, set the combo box in the header to match. X'l;When user selects a product in the combo box, set the focus:to the Patient ID field and then find the selected record. XB@!  LB@l:to the Patient ID field and then find the selected record. XB@  LB@ƱAttribute VB_Name = "Form_Technique 2 - Find Rec@ord" Basj0{54251E4F-0934-11D3-80A5-006008552884} |CreatablCTrue ]Predecl2aId"ExposeFals @TemplateDeriv%CustomizcD$ P Sub Current()  'When user changes rs, set the combo box inheadto @match.%selectPati2w[ID] EÀE O_AfterUpd^UPs a prod8uct$F(-foxcus8*1&ID field a$nC<0ZA@62.SetFDoCmd~.ØA:>LVAL N03abcgh ijkLĪ{@ treatment Treatments[Event Procedure]Helv8 hApple LaserWriter II NTX TD[ od,Xe`!)@Apple LaserWriter II NTXpscriptLPT2: dbce3f1jk3l3m5o3p` FormHeader0o5U`cde "";"";"";"";"10";"40" selectPatient Table/QueryRSELECT DISTINCTROW [patientID],[family Name] FROM patients ORDER BY [family Name];0[Event Procedure]"SELECT DISTINCTROW [patientID],[family Name] FROM patients ORDER BY [family Name];";"patients";"";"patientID";"family Name";"PatientID"d5U`abUceText131Select Patient:`Detail0e35]`4a cBox103e35]`4aCbccBox102e35]`4ab cBox101e35]`4abcBox100e35]`4ab cBox99e35]`4a,bcBox98m57;`abe8 PatientID PatientID:Don't enter a number here. Number filled in automatically.d25U`zabceText43 Patient ID:m57`ab eo k English NameDate end courseName of product in English English_Named25U`wabceText48 End course:m57`abceTkQuantity Per UnitDosage1Contents of one "unit" of product (minimum order)Quantity_Per_Unitd25U`wab6ceText49dosage:m57`ao bek frequency FrequencyGeneral NumberPrice for one unitd25U`wao bceText50 Frequency:o359`abPcdXe hWn"";"";"";"";"10";"40"drugIDDrugID Table/QueryISELECT DISTINCTROW [drug Name], [drugID] FROM drugs ORDER BY [DRug Name];3240;0&Click the arrow and select a supplier.x"SELECT DISTINCTROW [drug Name], [drugID] FROM drugs ORDLVALXU(   (QQy a !& >7Y@> rD<e treatmentForm_Combo 1 - Storing an IDForm_Combo 3 - AutoLookupForm_Combo 4 - DLookup -Form_Combo 5- Link drugs to treatment Subform "Form_Combo 5- link to patient info  Form_Combo 5_(treatment subform)Form_combo5_patient_subformForm_drug pie chart Form_front Form_Normal Form_PatientsForm_Subform 1 - AggregateForm_Subform 1_(subform)VBAForm_Subform 2 - One-Many-ManyForm_Subform 2_(first subform)Form_Subform 2_(second subform)Form_Technique 1 - Dialog Box !Form_Technique 1_(Treatment form)Form_Technique 2 - Find RecordForm_Technique 3 - Not in ListForm_Technique 3_(drug fER BY [DRug Name];";"drugs";"";"drugID";"drug Name";"PrimaryKey"d25U`zaXbceText110Drug:e35]`%adb cBox121m57`a(b eo k Product NameDate start course Product name Product_Named25U`ha(bUceText123 Start course:o359`cdehn"";"";"";"";"10";"40"DoctorIDDoctorID Table/QueryQSELECT DISTINCTROW [family Name], [doctorID] FROM doctors ORDER BY [family Name];1080;0&Click the arrow and select a category."SELECT DISTINCTROW [family Name], [doctorID] FROM doctors ORDER BY [family Name];";"doctors";"";"doctorID";"family Name";"PrimaryKey"d5U`abtceText126Doctor:d5U7`a| b6ceText129hNOTE: Combo box in header has an associated AfterUpdate event procedure that finds a record in the form.` FormFooter1cLVALoText24tablets_per_packetcost_per_packetDetail1Button23_Click Technique 3 - Not in List DRugIDRequery{%T4 `U(^%T4 `U(z%T4 `U(HC7?optionUS[C7? Button132 Button134KC7?Text139optionUS_AfterUpdate X8 mSELECT DISTINCTROW patients.[patientID], [given Name] & ' ' & [family Name] AS Name FROM patients WHERE town V;|? = 'bristol'  <> 'bristol'  ,ORDER BY [given Name] & ' ' & [family Name];Z;|?H`U(H`U(H`U(H`U(H`U(Text3 T&H`U(%H`U(Command5Command5_Clielm7U`Eabdedk Frequency FrequencyNDefault = 1 (= daily; 3 = every third day), must be greater than or equal to 1d5U`9abcFrequency Label FrequencyFrequency_Labelm7U`Ea] bdedk Doses per day Doses per dayXDefault = 1 (= once each day that tablets are taken), must be greater than or equal to 1 Doses_per_dayd5U`9a] bcDoses per day Label Doses per dayDoses_per_day_Labelo5U`b cEdehdn"";"";"";"";"10";"40"DrugIDDrugID Table/Query%select drugid,[drug name] from drugs;0;2835Links to Drugs tableT"select drugid,[drug name] from drugs;";"drugs";"";"drugid";"drug name";"PrimaryKey"d5U`9abc DrugID LabelDrugID DrugID_Labelo5U`b cEdehn"";"";"";"";"10";"40"DoctorIDDoctorID Table/Query*select doctorid,[family name] from doctors0;2835Links to Doctor table_"select doctorid,[family name] from doctors";"doctors";"";"doctorid";"family name";"PrimaryKey"d5U`9abcDoctorID LabelDoctorIDDoctorID_Labeld5U` a bcLabel22ͬhI`U(Detail0d Text0h Commandformexith Commandexitmacroh Commandexitform2LVAL Qi_VBA_MODULE}PpI`U(hI`U(oI`U(x, TEoI`U(pI`U( $$Jr4x8v<t@DpH(SLS S6LLL<,<0<4<8<<<N0{0F49BA68-D7DA-11D3-80CA-006008552884}e>8$*\Rffff*1738983e7c*\R1*#8f*\R1*#8e*\R1*#1c*\R0*#10*\R0*#16*\R0*#11  ($>x`J0 $ $ $ $@ $p $ $ $ $0 $ $ $|FH `  0 $ $ `4k0 $ $ $8@ $`| -0x `LVAL Rhp DDpLJ@x @h @d @T @D @4 0T8ME;2 " 8@ H+H /   -  "    ( 0"@H  /P `h p<x "  .    ()Use database order for string comparisons0H8>you pressed the closed door button to see some useful examplesA@J LB@BNXuPHH A@JN0l( x LB@Bu !A@JC:l  0 LB@Bu  !A@Jl LB@Bku !A@Jl$press to see really usefull examplesA@JX/Attribute VB_Name = "Form_front1" Bas0{0F49BA68-D7DA-11D3-80CA-006008552884} |Creatabl!True LVAL4<6KsLM? 66x 66  y66Pr@edeclaId"ExposBeFals @TemplateDeriv%Cus`tomiz$Option Codmp@ DTv ( 'Uzdorder for Bsng cisons P=A Sub Button1_Click() On ErrGoTo_  MsgBox "you presxthe crl~do ڀ- to see souseful exaes&DoCmd.CC/Exit::< A- rr&0$ Resu EndFZmande#G '6 7 8.DescriBI:H;:m; < =  @4 9 rrr@ 8Q ;xxx@ <Q ;vvv@ @Q y?tttq@D a @H  ppp3?0 0  0 x  K9/'h%x"$ `x ,x5h<'4'D'Td xx ,>dFh x6hTD4 6H$ y $dxhTD40   @8C__SRP_3rU T$`$)`$i` $` pLVAL8 @ @ @ @ @ @ @ @ @ @ @Am#Am$Am%Am&AmBm'Bm)Bm*Bm+Bm,Bm-Bm.Bm/Bm0Bm1Bm(Cm2Cm4Cm5Cm6Cm7Cm8Cm9CpC pCm3DpD|D}D~DDDD0DpEp Ep EpEpEpEpEpEp FpF0 F0 F0 F0 F0 F0F0F0F0F 0F 00c!ghxij$kFŲ@Helv8 hApple LaserWriter II NTX TD[ od,Xe`!)@Apple LaserWriter II NTXpscriptLPT1: dbcd ee3f1h5k3l3m5b@ i nj o3bl pe`f`@ Detail0d5]`abcpText0"Demonstration of Forms and queriesh1`abcCommandformexit&Close Form using form operation wizard[Event Procedure]h1`aFb ciCommandexitmacroClose form using macro frontcloseh1`5a}b ciCommandexitform2Close Form using modified code[Event Procedure]0LVAL<76 6p 6p66666666(686H6X6p66 66H6 6@6x666 6x 6 6x 6 6x 6 6x 6 6x 6 6x 6 6x 6 6x 6 6x 6 6x 6 6x 6 6x 6 6x 6 6x 6 6x 6 6x 6 6x 6 6x 6 6x 6 6x 6 6x 6 6x 6 6x 6 6x 6 6x 6 6x 6 6x 6 6x 6 6x 6 6x 668666@6X6`p6X6 p6X6 p6X6 p6X6 p6X6 @6X6 p6X6 p6X6 p6X6  p6X6  p6X6  p6X6  p6X6  |6 666?Ph666h66x6H66x66666666866h66666666(6(66 6 6 H6 x6 66 6 86 h6 6 6ͬ%wbM`U(FormHeader1dText12dText13Detail0mPatientIDdText15mFamily_nameFamily namedText17mGiven_nameGiven named Text19m Initialsd Text21m Titled Text23mGenderdText25mDate_of_BirthDate of BirthdText27mAddr1dText29mAddr2mTowndText33mCountydText35mPostcodedText37mCountrydText39mTelephonedText41hButton42h Button43h!Button44h"Button45h#Commandfind$FormFooter2LVAL Vi_VBA_MODULE⿄i`U(x Ey  (SLS S<N0{62A677E0-E84D-11D3-80CC-006008552884}($Pp`(@h`(@llate`(@p but`(@t/80A50pb $" $.. $0p0 $"` $ $( @H K@8 P @( JXDJx 0@h @X @H @8 K@( Jx @h @X @H @8 @( ,LVAL W`Jx @h @X @H @8 @( 08hxhMEL2 "8@ 7H `h p -x  " 7   -  " 7  ( 0 -8H P "X` 7h   -  "     0)Use database order for string comparisons08  LB@u A@JxplhpX  LB@8u0( A@Jl  LB@u A@J@Cl  LB@xuph A@JPlH@    LB@.ux !A@J`lXPBAttributLVALEHh`aXb@c@iButton43Button43[Event Procedure](       Hh` aXb@c@iButton44Button44[Event Procedure](       Hh` aXb@c@iButton45Button45[Event Proceduree VB_Name = "Report_Patients_saveasrT"  Basf0{62A677E0-E84D-11D3-80CC-006008552884} |Cre atablCTrue ]PredeclaId"@ExposeFals @TemplateDeriv%Custom izD$Option Comp@ DTv 'Uzdorder@ for sng cisons P=A Sub Button42_Click() O n ErrGo4To_  DoCmd.Rec: ,A_FIRSTExit : ?rrMsg(Box#$ Resu End939&9NEXN9[9 c9 c94`9^9PREVIOUS ][: c:d?5V5?4d>LAVd }mandfindmDoMenuItem acFormBar,@vs, 2wacVer70?"> !'".Descri˜C z#LVAL Y0cMg/h$ij k,a@PatientsPatients d7ee1h5i14bcgfj14bcgfm49cgfn25hfo27fjf`5 FormHeader1d27`abcdText12Patientsd27`axbcdText13Patients`Detail0m`Paxbe PatientID PatientIDMust be uniqued`axbcText15 PatientID:m`PaXb etk Family name Family name name_enter name_exit Family_named`aXbcText17 Family name:m`Pa8beVk Given name Given name Given_named`@a8bcText19 Given name:m`a8bekInitialsInitialsd` a8bcText21 Initials:m`0a8b ekTitleTitled``a8b@cText23Title:m`PabekGenderGender m or f onlyd``ab`cText25Gender:m`abHe)k Date of Birth Date of Birthd/m/yy.Must be less than or equal to the current date Date_of_Birthd`pabcText27Date of Birth:m`PabekAddr1Addr1d`ab9cText29Address:m`Pa bekAddr2Addr2m`Pa bek TownTownd`a bcText33Town:m`Pa bek CountyCountyd`a bcText35County:m`Pa bFek PostcodePostcode>LL09\ 0LL;0;" "d`a bcText37 Postcode:m`Pa bek CountryCountryIn case of visitorsd``a b`cText39Country:m`Pabeek Telephone TelephoneOnly digits and spaces allowed999999999999999;0;" "d`@abcText41 Telephone:h` aXb@c@iButton42Button42[Event Procedure]({ wx { {LVAL ZHh`aXb@c@iButton43Button43[Event Procedure](       Hh` aXb@c@iButton44Button44[Event Procedure](       Hh` aXb@c@iButton45Button45[Event Procedure](   HLVALȀǀǀǡơ66\\:jMSysDb#j~MSysDb#Form_TEchnique 4 macro version-Runtimej~MSysDb#Form_TEchnique 4 maj~MSysDb#Form_TEchnique 4 j~MSysDb#Form_TEchnique j~MSysDb#j~MSysDb#j~MSysDb#Form_TEchnique 4 macro version-Runtime[WKGCEForm_Technique 4 module version- Runtime]YMIE Form_Technique 3_(drug form used by macro version)$gcWSO LForm_Technique 3 macro version- not in listT`\PLHyiForm_Technique 3_(drug form used by module version)$hdXTP Form_Technique 3 module version- Not in ListTa]QMIJ*Hh`%ab(ci Commandfind Find patient findpatient` FormFooter2LVAL#Slicit 0 PFJ Sub Butto n23_Ck() DoC md.Clm 8EndAfterUpFe1Sav#SelectObj@ A_FORM, "} moduaDy - Not in Listls![W ]![DRugI D].Reryg6uMeDUnload(Cancel As IntegerV!' D the:, r* BIDArbo Pbox,acs@et val@of |^bbb@-1a1LVAL bi_VBA_MODULEHĒ`U('%T4 `U(GĒ`U(x EJFGĒ`U(HĒ`U( 48<@DHLPTX\`dhvlptx|prtx|(SLS S6LL<,<0<4<8<<<N0{54251E27-0934-11D3-80A5-006008552884}^8"*\Rffff*738b69788*\R0*#11*\R0*#d*\R1*#1c*\R1*#8e*\R1*#8f*\R1*#0 `($Pp`(Jh`(kllate`(Jp but`(Jt/80A50pb $" $.. $0p0 $"` $ $` x> K $"0 $` $0pLVAL ^0cMg/h$ij42kT!,a@PatientsPatientsconditional macro d7ee1h5i14bcgfj14bcgfm49cgfn25hfo27fjf`5 FormHeader1d25]7`abcdText12Patientsd257`axbcdText13Patients`Detail0m7U`Paxbe PatientID PatientIDMust be uniqued5U`axbcText15 PatientID:m7U`PaXb etk Family name Family name name_enter name_exit Family_named5U`aXbcText17 Family name:m7U`Pa8beVk Given name Given name Given_named5U`@a8bcText19 Given name:m7U`a8bekInitialsInitialsd5U` a8bcText21 Initials:m7U`0a8b ekTitleTitled5U``a8b@cText23Title:m7U`PabekGenderGender m or f onlyd5U``ab`cText25Gender:m7U`abHe)k Date of Birth Date of Birthd/m/yy.Must be less than or equal to the current date Date_of_Birthd5U`pabcText27Date of Birth:m7]`PabekAddr1Addr1d5U`ab9cText29Address:m7`Pa bekAddr2Addr2m7`Pa bek TownTownd5]`a bcText33Town:m7`Pa bek CountyCountyd5_`a bcText35County:m7`Pa bFek PostcodePostcode>LL09\ 0LL;0;" "d5_`a bcText37 Postcode:m7`Pa bek CountryCountryIn case of visitorsd5W``a b`cText39Country:m7U`Pabeek Telephone TelephoneOnly digits and spaces allowed999999999999999;0;" "d5U`@abcText41 Telephone:h1U` aXb@c@iButton42Button42[Event Procedure]({ wx LVAL _{ {Hh1U`aXb@c@iButton43Button43[Event Procedure](       Hh1U` aXb@c@iButton44Button44[Event Procedure](       Hh1U` aXb@c@iButton45Button45[Event Procedure](   +LVAL7Hh1U`%ab(ci Commandfind Find patient findpatient` FormFooter2.TǬǬǬǬǬǬǬǬǬǬǬǬǬǬǬǬǬǬǙdždždždždždždždždždždždždžs`ClYF3 JYF3sL                             doctors  [family name]% gdoctorid g   GPatients [Patients].[Family name]0 g[Patients].[PatientID]. g  atientid]=[selectpatient]3 'treatment Count([patientid])* g  address_line3get_address([address],3)= oaddress_line2get_address([address],2)= oaddress_line1get_address([address],1)= obad_design.address* gbad_design  G G  ~bad_design.name' g~surnameget_surname([name])2 o~titleget_title([name]). o~initialsget_initials([name])4 o~bad_design ~ G~ G~ ~ wPatients w  Gw w 0LVAL<ͬ%'%T4 `U(FormHeader1d Text12d Text13Detail0mPatientIDd Text15mFamily_nameFamily named Text17mGiven_nameGiven named Text19m Initialsd Text21m Titled Text23mGenderd Text25mDate_of_BirthDate of Birthd Text27mAddr1d Text29mAddr2mTownd Text33mCountyd Text35mPostcoded Text37mCountryd Text39mTelephoned Text41h Button42h Button43h !Button44h "Button45#FormFooter2h $CommandfindLVAL c $" $ $LJ@x @h @X @0H @H8 @( X @H @8 @( ,`Jx @h @X @H @8 @( 0|hhMEL2 " 8@ 7H `h p -x  " 7   -  "  7  ( 0 -8H P " X` 7h   -  "      0)Use database order for stringLVAL d comparisons08  LB@u A@JxplhpX  LB@8u0( A@Jl  LB@u A@J@Cl  LB@xuph A@JPlH@    LB@.ux !A@J`lXP2Attribute VB_Name = "Form_Patien ts" Bas0{54251E27-0934-11D3-80A5-006008552884} |CreatablTrue ]PredeclaId"ExposeFals @Templat@eDeriv%Customiz$Option Comp@ DTv 'Uzdorder for sng cisons  P=A Sub Button42_Click() On ErrGoToF_ D oCmd.Rec: ,A_FIRSTExizt : ?rrMsgBox#$ Resu End}939&9NEXN9[9 c9 c94`9^9PREVIOUS ]_[: c: c:5?4d>LAVdmd }mandfindmDoMenuIt em acBa,r,@vs, 2wacVer70"> !'".Descri˜C z#__SRP_4 rU  1 cAcb@41@81@<1@@1@D1 @H11@L1I@P1aLVAL e@T1y@X1@\1@ `Q `@d1@h a @l  vvv@ pQ @ tQ  q@ xQ )@| I@ Q 1@  ppp@ )rrr@ Attt@1Yxxx@1y|||?0 0  xKA7'X%'h%x"$ `x Lx6hX-'('8'H'h FX 6 hXH8( >Tx$ r $xhXH8(0   0  `LVALl 0   ptx`;__SRP_5rU $`h $)`l $i`p $`t $`x pLVAL &<Y)pC8#)spC(M?58#hC8#`8#58#! <@8#p8#8#8#8#8# 8#F8#V8#v8#8#8#8#8#88#Y8#i8#8#8#8#8#8#8#8# 8#8 8#X 8# 8# 8# 8# 8# 8#@8#p8#8#8#8#8# 8#@8#P8#p8#8#8#8#8#88#P8#`8#x8#8#8#8#8#8#8# 8#8 8#X 8# 8# 8# 8# 8# 8#X8#X8#X8#X8#X8#X8#08#08#08#08#8#8#8#8#8#8#8#8#8#8#8#8#8#8# 8# 8# 8# 8# 8# 8# 8# 8#`8#8#8#8#8#8#88#F8#V8#v8#8#8#8#(8#H8#Y8#i8#8#8#8#8#8#8#8#( 8#P 8#p 8# 8# 8# 8# 8# 8#   (                (        (                                                        Doctors.DoctorIDDoctorsDoctorIDDoctors.Family name Family nameDoctors.Given name Given nameDoctors.InitialsInitials Doctors.TitleTitleDoctors.Internal telephone Drugs.DrugIDDrugsDrugID(Drugs.Drug nameDrugs.Tablets per packetDrugs.Cost per packetPatients.PatientIDPatients PatientIDPatients.Family name Family namePatients.Given name Given namePatients.InitialsInitialsPatients.TitleTitle&Patients.GenderPatients.Date of BirthPatients.Addr1Patients.Addr2 Patients.Town!Patients.CountyPatients.PostcodePatients.CountryPatients.TelephoneTreatment.PatientID Treatment PatientIDTreatment.DrugIDDrugIDTreatment.DoctorIDDoctorIDTreatment.Date start courseTreatment.Date end courseTreatment.DosageTreatment.FrequencyTreatment.Doses per dayp8#  `8# 8#P8# 8#࣭F@ LVALKKDValidationRuleValidationText ColumnWidth ColumnOrder ColumnHidden DescriptionFormat DecimalPlaces InputMaskCaption DefaultValueRequiredAllowZeroLengthn. &[Date end course]>=[Date start course]4 ,Date end course must be >= Date start coursevDate start course '   Default = today d/m/yy now$()  Date end course   e ]Must be greater than or equal to Date start course (validated when rcord is saved or updated) d/m/yy   Dosage   G ?Number of tablets per dose, default = 1, must be greater than 0   1    >0> 6Dosage must be > 0; does not have to be a whole number Frequency   V NDefault = 1 (= daily; 3 = every third day), must be greater than or equal to 1   1    >=1P HFrequency of treatment; must be >= 1 (where 1=daily, 3=every 3 days etc) Doses per day   ` XDefault = 1 (= once each day that tablets are taken), must be greater than or equal to 1   1    >=1E =Number of doses on days when treatment is given; must be >= 1c PatientID    Links to Patients table   ] DrugID    Links to Drugs table    iDoctorID f   Links to Doctor table   0  LVAL i< *= sO?8* ****A  * * * *0 *$ * 0 *4 *P * T *` * *d * /`   get_address * * * * X * [address] * * *H> * * * *0 * *$* 0*4*P* T*`**d* /`   get_address *** * X * [address]** *H>* *** 0** * baLVALU(`U(Q%T4 `U(V%T4 `U([%T4 `U(`%T4 `U(ze Access as=DimDElseGEndSFalse`If|MenameSubThenTrue VBAWin16~Win32Mac DAO treatmentForm_Combo 1 - Storing an ID] _EvaluateForm_Combo 3 - AutoLookupForm_Combo 4 - DLookupe-Form_Combo 5- Link drugs to treatment Subform"Form_Combo 5- link to patient info Form_Combo 5_(treatment subform)yForm_combo5_patient_subformwForm_drug pie chart Form_frontM  Form_NormalC Form_Patients|Form_Subform 1 - AggregateForm_Subform 1_(subform)Form_Subform 2 - One-Many-ManyForm_Subform 2_(first subform)UForm_Subform 2_(second subform)Form_Technique 1 - Dialog Box!Form_Technique 1_(Treatment form) Form_Technique 2 - Find RecordForm_Technique 3 - Not in ListHForm_Technique 3_(drug form)hForm_Technique 4 - Runtimeٵ$Form_temp_form_to_add_treatment_datalReport_Report1" Button1_ClickFormDetail0,Text0~Button1]Err_Button1_ClickTMsgBoxRDoCmdƧExit_Button1_Click Button42_Click+ FormHeader1Text12rText13r PatientID!Text15rd_design@**%v 8*(***s****************************** **x***bad_design@**8**8*@***h*** *kLVALw 023c g&hij&kxitechnique 3 drug unloadGŲ@Drugs Add Categorytechnique 3 drug unload Solution.hlp8 hApple LaserWriter II NTX WD[ od,XZZe?`!)@Apple LaserWriter II NTXpscriptLPT1:d27ee1h5i14bcgXj14bcgXm59gX`(Detail1m57U`abp drug Name drug Name drug name. drug_Named5U`abcText11 drug Name:m57U`apbcJkDRugIDDrugIDdrugid (prefix by DG)d5U`avbcText14drugid:e15U`abpcBox20h1U`PabiButton23Donetechnique 3 closed5U7`aXbcText24ݏNOTE: When you close this form, an event procedure requeries the drug list in the main form and sets the drug value to the one you've entered.m57U`a8bgcJktablets per packetTablets per packettablets per packettablets_per_packetd5U`a8bcText35tablets per packet:m57U`abgcJkcost per packetCost per packet#,##0.00;-#,##0.00cost per packetcost_per_packetd5U`abcText37cost per packet:LVALU(AK`U(EK`U(DK`U(HK`U(GK`U( Command10JK`U(IK`U(Command10_ClickLK`U(KK`U(RK`U(QK`U(TK`U(SK`U(XK`U(ZK`U(YK`U(1K`U(\K`U([K`U(_K`U(^K`U( selectPatientselectPatient_AfterUpdate Form_Combo 2- #Form_Combo 2- Adding <> $Form_Combo 2 - Adding <>yK`U(xK`U(drugstodisplay2K`U(K`U(K`U( Drug name3K`U(K`U(K`U(K`U(K`U(Form_AfterUpdateC&*I`U(G&*I`U(F&*I`U(e&*I`U(g&*IͬWf`U(Detail0FormHeaderFormFootermPatientIDd PatientID_LabelPatientID Labeld DrugID_LabelDrugID Labeld DoctorID_LabelDoctorID Labelm Date_start_courseDate start coursed Date_start_course_LabelDate start course Labelm Date_end_courseDate end coursed Date_end_course_LabelDate end course Labelm Dosaged Dosage_LabelDosage LabelmFrequencyd Frequency_LabelFrequency LabelmDoses_per_dayDoses per dayd Doses_per_day_LabelDoses per day Labeld Label17oselectpatientd Label19nno_treatmentoDRugIDoDoctorIDd Label22LVAL mi_VBA_MODULEf`U(xG Ec; (SLS S<N0{66D5DF57-DFC6-11D3-80CB-006008552884} (e $D`@# y$ $* $ $D`h@ $$p*$$DH `4@ 10H*P0$$*$H$$$$$Z$$Dj0`h@an ePZX`Dlp`h@8ape0arePateDv0`h@ an eLVAL n(apeare ateDx` `h@pan eapeareate$aep$$ $$$$ZXS`hZpH$x$Z$$ $Z8 $h $ $Z $ $( $ZX $ $ $Z $ $ D`DP ` $$Z(X $D`X8 00p 0 $` $ $ LVAL o$ $ $P$h  x @h (d @T @D 4    (t ME5 "  "   " (80 "  "  "  "   "  " ($QP P $` X0 8 8 H " H$Qh xp0lll0 X'   LB@H  LB@el patientid LB@\ patientid LB@\l X'l X'pl X'0lh X'X  LB@u( selectpatient LB@\T not found selecting patient treatmentA@JP l l X'` lzAttribute VB_Name = "Form_Technique 2 macro - Find record" Basv0{66D5DF57-DFC6-11D3-80CB-0060LVAL08552884} |CreatabBlCTrue ]Predecla Id"ExposeFals @Template Deriv%CustomizD$Option Comp@ DTv  J fEx$itv m rri MsgBox "not found", ac, "# ] {tmn c#xEvResu@;_g<0_-P-fLVAL q0=c"ghhij(k0HTreatment.PatientIDjus@ Treatment Treatmenttechnique 2 currentHelv8 hApple LaserWriter II NTX TD[ od,Xe`!)@Apple LaserWriter II NTXpscriptLPT1:d1bceAriale12f5g1237bchbcgAriali1ghj16ghk12l2m4b@ Arialn2Arialo2bArialp5e`fr34cd zbciArial{5bcJ eArial` FormHeadero5U`b@ c d^elf"";"";"";"";"4";"4" selectpatient Table/QueryTSELECT DISTINCTROW [Patients].[PatientID], [Patients].[Family name] FROM [Patients];284;1442technique 2 afterupdated5U`a^bcLabel17Select PatientIDn3Uab^cd l no_treatment Table/QueryJselect Count([patientid]) from treatment where [patientid]=[selectpatient]d5U`]a^bcLabel19 no_treatments`5Detail0 m07U`Ea^be PatientID PatientIDFixedLinks to Patients tabled5U`9a^bcPatientID Label PatientIDPatientID_Labelm7U`Ea9bekDate start courseDate start coursed/m/yyDefault = todayDate_start_coursed5U`9a9bcDate start course LabelDate start courseDate_start_course_Labelm7U`EabekDate end courseDate end coursed/m/yy]Must be greater than or equal to Date start course (validated when rcord is saved or updated)Date_end_coursed5U`9abcDate end course LabelDate end courseDate_end_course_Labelm7U`EabekDosageDosage?Number of tablets per dose, default = 1, must be greater than 0d5U`9abc Dosage LabelDosage Dosage_LabOLVAL[elm7U`Eabdedk Frequency FrequencyNDefault = 1 (= daily; 3 = every third day), must be greater than or equal to 1d5U`9abcFrequency Label FrequencyFrequency_Labelm7U`Ea] bdedk Doses per day Doses per dayXDefault = 1 (= once each day that tablets are taken), must be greater than or equal to 1 Doses_per_dayd5U`9a] bcDoses per day Label Doses per dayDoses_per_day_Labelo5U`b cEdehdn"";"";"";"";"10";"40"DrugIDDrugID Table/Query%select drugid,[drug name] from drugs;0;2835Links to Drugs tableT"select drugid,[drug name] from drugs;";"drugs";"";"drugid";"drug name";"PrimaryKey"d5U`9abc DrugID LabelDrugID DrugID_Labelo5U`b cEdehn"";"";"";"";"10";"40"DoctorIDDoctorID Table/Query*select doctorid,[family name] from doctors0;2835Links to Doctor table_"select doctorid,[family name] from doctors";"doctors";"";"doctorid";"family name";"PrimaryKey"d5U`9abcDoctorID LabelDoctorIDDoctorID_Labeld5U` a bcLabel22wNOTE: Combo box in header has an associated AfterUpdate event procedure that finds a record in the form (macro version)` FormFooterLVALͬf`U(FormHeaderoselectpatientd Label17d Label19Detail0mPatientIDd PatientID_LabelPatientID Labeld DrugID_LabelDrugID Labeld DoctorID_LabelDoctorID Labelm Date_start_courseDate start coursed Date_start_course_LabelDate start course LabelmDate_end_courseDate end coursed Date_end_course_LabelDate end course LabelmDosaged Dosage_LabelDosage LabelmFrequencyd Frequency_LabelFrequency LabelmDoses_per_dayDoses per dayd Doses_per_day_LabelDoses per day LabelFormFooternno_treatmentsoDoctorIDoDrugIDd Label22LVAL ti_VBA_MODULE#"f`U(x?E [s (SLS S<N0{66D5DFBF-DFC6-11D3-80CB-006008552884}P (e $D`@ " y$ $* $ $D`h@$$p*$$DH`@ .0H*P0$$*$H$$$$$Z$$Dj0`h@an ePZX`Dlp`h@8 ape0arePateDv0`h@ an eLVAL u(apeare ateDx` `h@pan eapeareate$ $ $ $ $$$ $$$$ZXS`hZpH$x$Z$$ $Z8 $h $ $Z $ $( $ZX $ $ $Z $ $ 0 ` p0 $D`h@  $ $Z(X $D`h@ $ $ $ 0  $`  $  $ LVAL v $     $8 $h $ $ ppH(x @h pXXx @h (d @T @D @@4 (0($ @ @ h @ (x @h  @ (x @h  @ (x @h @ X x @h LVAL w (d @T @D @4 X($ @ hx   X`(x @h x  @ptME9 "  "(80 "  "  "   " (  "   "$ N P E8 $PHF9 ` " H$ Nx h E $xF0 0  xp0lll0 X'  B@\ Lh B@\ La patientid LB@\ patientid LB@\l X'l X'pl X'0lh X'X X'h X a selectpatient LB@\T LB@ l X'` l B@\und B@\sele B@\ent tr X      LB@no treatments found   finding patient treatmentsA@J     LB@ selectpatient LB@\ LB@p(no treatments found   finding patient treatmentsA@JAttribute VB_Name = "Form_TechnihLVALtque 2 module basic - Find Record" Bas0{66D5DFBF-DFC6-11D3-80CB-006008552884} |Creatabk@= True ]Predecla Id"ExposeFals @Template Deriv%CustomizD$Option Comp@ DTv  I ] [DoCmd.GoToControl "D`ic [ ], acEntirPbrSearchAll,'Add If nap Then  @EMsgBo@x "no g@ found", vbOKOnly +@Inf@@on, "fm^ Ń` CancelEvKJIfK_?0222Ec22)r2As22#32 LVAL y0=c"ghhij,kH [patientid]jus@ Treatment Treatment[Event Procedure]Helv8 hApple LaserWriter II NTX TD[ od,Xe`!)@Apple LaserWriter II NTXpscriptLPT1:d1bceAriale12f5g1237bchbcgAriali1ghj16ghk12l2m4b@ Arialn2Arialo2bArialp5e`fr34cd zbciArial{5bcJ eArial` FormHeadero5U`b@ c d^elf"";"";"";"";"10";"40" selectpatient Table/QueryTSELECT DISTINCTROW [Patients].[PatientID], [Patients].[Family name] FROM [Patients];0;1443[Event Procedure]"SELECT DISTINCTROW [Patients].[PatientID], [Patients].[Family name] FROM [Patients];";"Patients";"";"PatientID";"Family name";"PatientID"d5U`a^bcLabel17Select PatientIDn3Uab^cd l no_treatments Table/Query@select Count(*) from treatment where [patientid]=[selectpatient]d5U`]a^bcLabel19 no_treatments` Detail0 m7U`Ea^be PatientID PatientIDLinks to Patients table[Event Procedure]d5U`9a^bcPatientID Label PatientIDPatientID_Labelm7U`Ea9bekDate start courseDate start coursed/m/yyDefault = todayDate_start_coursed5U`9a9bcDate start course LabelDate start courseDate_start_course_Labelm7U`EabekDate end courseDate end coursed/m/yy]Must be greater than or equal to Date start course (validated when rcord is saved or updated)Date_end_coursed5U`9abcDate end course LabelDate end courseDate_end_course_Labelm7U`EabekDosagLVALeDosage?Number of tablets per dose, default = 1, must be greater than 0d5U`9abc Dosage LabelDosage Dosage_Labelm7U`Eabdedk Frequency FrequencyNDefault = 1 (= daily; 3 = every third day), must be greater than or equal to 1d5U`9abcFrequency Label FrequencyFrequency_Labelm7U`Ea] bdedk Doses per day Doses per dayXDefault = 1 (= once each day that tablets are taken), must be greater than or equal to 1 Doses_per_dayd5U`9a] bcDoses per day Label Doses per dayDoses_per_day_Labelo5U`cEdehn"";"";"";"";"10";"40"DoctorIDDoctorID Table/Query+select doctorid,[family name] from doctors;0;2268Links to Doctor table`"select doctorid,[family name] from doctors;";"doctors";"";"doctorid";"family name";"PrimaryKey"d5U`9abcDoctorID LabelDoctorIDDoctorID_Labelo5U`cDde,hdn"";"";"";"";"10";"40"DrugIDDrugID Table/Query%select drugid,[drug name] from drugs;0;2268Links to Drugs tableT"select drugid,[drug name] from drugs;";"drugs";"";"drugid";"drug name";"PrimaryKey"d5U`8abc DrugID LabelDrugID DrugID_Labeld5U`4a b cXLabel22~NOTE: Combo box in header has an associated AfterUpdate event procedure that finds a record in the form (Access Basic version)` FormFooterLVAL'ͬ f`U(Detail0eBox6mBegin_DateBegin Dated Text1mEnd_DateEnd Dated Text3h Button4h Button5d Text7d Text8LVAL |i_VBA_MODULEf`U(f`U(xo E   (SLS S<N0{66D5DFF0-DFC6-11D3-80CB-006008552884}  ($p`8@$ `h@(  H0p $. . $P6 $ $. $ $ $ $  $.P $ $ $. $ $ $ $P $ $ $ $Hp $ $ $0p.( $0p $p $. $ $ $.0 $` $.X`hLVAL }.@. $ $h $ $ $.  .`0p $.@ $p $0p $ $  $ Lx @h JX @H @8 @@ p0 , @ @ " 0 0pME" H @x P @LH ` " h (p /  X0AHide the dialog but leave it open for the other Treatment form to (el8p"Close this dialog if user cancels. LB@Bl(ZZ4Technique 1_(Treatment form used by dialog box form)'LVALu !A@JIl (    LB@Z datasheet'0ZZ4Technique 1_(Treatment form used by dialog box form)'u !A@Jl (    LB@x:access. Me refers to the form in which the code is running9Then open the Treatment form in datasheet view (acformds):Technique 1_(Treatment form used by macro dialog box form)  LB@ss8Attribute VB_Name = "Form_Technique 1 macro version- Dialog box"D Bas0{66D5DFF0-DFC6-11D3-80CB-0060085@52884} |CreatablCTrue ]Pre declaId"Expose!Fals @TemplateDeriv%CustomizD$P Sub Button4_Click()  'Hide@ the dut leave it open (foror BTwment m to#access. Me rCreatabq= True ]PredeclaId"@ExposeFals @TemplateDerivCustomlizD$P Sub Button4_Click() 'Hide t0he d leave it open for5orqwment m to#access. Me ref m in whichco9is running Me.Visi_PThADRT[d_sheet vi@ew (acAds8DoCmdL.O2A "_(LuabyEDox:)", acADSOEndAVZ5ZCl@yG?>if @r cancels.B,B LjLVALv0239c g hx itj"kWAGŲ@!Application Technique: Dialog Boxh5` Detail0e1345]`abcBox6m7`V a Begin Date Short Date Begin_Dated5`abceText1Enter beginning date:m7`Y akEnd Date Short DateEnd_Dated5`abceText3Enter ending date:h1`1aiButton4OK[Event Procedure]h1` aiButton5Cancel[Event Procedure]d5`1a(bz cText7+Enter a date between 1-jan-96 and 31-dec-96d5U`aP bceText8ANOTE: This dialog box opens the Treatment form with the OK button\LVALhͬJ%T4 `U(Detail0mnamed Text0mCountOfOrder_IDCountOfOrder IDd Text1d Text4LVAL i_VBA_MODULE;f`U(xEc (SLS S<N0{54251E4A-0934-11D3-80A5-006008552884}h(($`h@pi eh $0 $( $X $0 $ $  $(@ $X $000PME 2 " 8 *@*.p  )Use database order for string comparisons#0#Close the dialog box when finished. Technique 1 - Dialog Box LB@BlXPAttribute VB_Name = "Form_Technique 1_(Treatment fl used by macro dialog box:)" " Bas0{54251E4A-0934-11D3-80A5-006008552884} >C{ablCTrue ]Predecl2aId"Expo= Fals @TemplateDerivkCustomizD$Optio@n Comp@ Databv 'Uzdord$er sng cisons` P=A Sub Unload(Cancel As In@teger) 'Cli thewhen fiLVALnished. DoCmd.A_FORM, " - DCpBox_ E ndA"kLVALw0cghlij"k`[Event Procedure]P@technique 1 macro formpatient treatmentsHelv8 hApple LaserWriter II NTX TD[ od,Xe`!)@Apple LaserWriter II NTXpscriptLPT1: dbcd ee3f1k3l3m5b@ i nj o3bl pe`f` Detail0m7U` aXeNameNamed5U`aXbacText0 Patient Name:m7;` abekCountOfOrder IDCountOfOrder IDCountOfOrder_IDd5]`ab3 cText1Number of treatments:d5U`abcXText4VNOTE: Form is based on a query that uses criteria from the now hidden dialog box form.\LVALhͬf`U(Detail0mnamed Text0mCountOfOrder_IDCountOfOrder IDd Text1d Text4LVAL i_VBA_MODULE;f`U(xEc2c (SLS S<N0{66D5E001-DFC6-11D3-80CB-006008552884}h(($`h@pi eh $0 $( $X $0 $ $  $(@ $X $000PME 2 " 8 *@*.p  )Use database order for string comparisons#0#Close the dialog box when finished. Technique 1 - Dialog Box LB@BlXPAttribute VB_Name = "Form_Tecnique 1_(treatment fh used by module dialog!4)" Bas0{66D5E001-DFC6-11D3-80CB-006008552884J} >Cxabd= True ]Pr@edeclaId"Expo@= Fals @TemplateD0erivjCustomizD$Option Comp@ Databv 'Uzdorder sng cisons P=A Sub Unload(Cancel As Integ(er) 'C"li thbox when fiLVALnished. DoCmd.A_FORM(, "h -D DCoBox_ 0 EndA"jLVALv0cghlij"k`[Event Procedure]:.^P@technique 1 module formpatient treatmentsHelv8 hApple LaserWriter II NTX TD[ od,Xe`!)@Apple LaserWriter II NTXpscriptLPT1: dbcd ee3f1k3l3m5b@ i nj o3bl pe`f` Detail0m7U` aXeNameNamed5U`aXbacText0 Patient Name:m7;` abekCountOfOrder IDCountOfOrder IDCountOfOrder_IDd5]`ab3 cText1Number of treatments:d5U`abcXText4VNOTE: Form is based on a query that uses criteria from the now hidden dialog box form.LVALͬT%T4 `U(Detail0eBox103eBox102eBox101eBox100eBox99eBox98mPatientIDd Text43m English_NameEnglish Named Text48m Quantity_Per_UnitQuantity Per Unitd Text49m Unit_PriceUnit Priced Text50oDoctorIDd Text110eBox121mProduct_NameProduct Named Text123oDRugIDd Text126d Text129Date start courseDate end courseDosageFrequencyDoses per dayLVAL i_VBA_MODULEC|\`U(T%T4 `U([`U(xtE7F[`U(\`U(  48p<r@tDvHxLzP|TX~\`dhlpt(SLS S6<4<<<<< <$LL<8<<<N0{54251E54-0934-11D3-80A5-006008552884}d%8"*\Rffff*738a82674*\R1*#1c*\R1*#8e p($ `|Jpi" i$`(z`*x`ht`,r0H $4x $ $0 $4 $@ $p $4 $ $0 $8 $h $( H 0pLVAL @ y_Pe@ cexText49do@ k@ eque@ #0.0h00@ME"    B(D7p"  0 : * =P @pH8  :   0Z< Display message box asking if user wants to add a new drug.Do you want to add a new drug?$drug Not In List$J'( (  User chose Yes.* Remove new name from drug ID combo box so4 control can be requeried when user returns to form. 0 2 4 6 LB@.9 Open Add Category form and set the Category Name value. " <")@4 Continue without displaying default error message. B'$hl LB@3`4a@.Technique 3_(drug form used by module version) 8 : LB@XUAttribute VB_Name = "Form_Technique 3 module version- Not in List" Bas0{54251E54-0934-11D3-80A5-006008552884} |Creatabl= True ]PredeclaId"ExposeFals @Templat@eDeriv%CustomizD $P Sub drugID_ In(NewD\ As Sng, Resp on Integer) PDim C&gXory,znc Ƈ it/MsgDia8log/' Disvy message box asking if user wants to add a hnew6. )= Box("D`o youO?", 36, "HBID?If>= 6 Then!E ' U%chp Yes!$A'@Vmove+Bnfrom- ID combo :so control can be reri wACretu4rnCfHDoCmd.Sav DoMenuItem A_FORMBAR,!EDITUNDOFIELD, MENU_V@ER20 I' tOp@AaF and set 0the F†va8lue( "9_(c:d b)GLVALS6A_NALAADDc'a s![ )P]![De 4]uId '' C4inwithout dWUdefault errorYfm= DATA_ERRCONTINUE,E )If!SubA__SRP_4rU  ZZYZ@4 !@8 a @<  ppp@@ rrr@D yttt@H vvv@L xxx@P zzz@T |||@X1@\1Y~~~@`1 @d11@h9@l @p1@t9x0 0  h[__SRP_5wrU ,`Yq0&pLVAL 03abcXghipjk8@ treatment TreatmentHelv8 hApple LaserWriter II NTX TD[ od,Xe`!)@Apple LaserWriter II NTXpscriptLPT2: dbce3f1jk3l3m5o3p`Detail0e35]`4a cBox103e35]`4aCbccBox102e35]`4ab cBox101e35]`4abcBox100e35]`4ab cBox99e35]`4a,bcBox98m57;`abe8 PatientID PatientID:Don't enter a number here. Number filled in automatically.d25U`zabceText43 Patient ID:m57`ab eo k English NameDate end courseName of product in English English_Named25U`wabceText48 end course:m57`abceTkQuantity Per UnitDosage1Contents of one "unit" of product (minimum order)Quantity_Per_Unitd25U`wab6ceText49dose:m57`ao bek Unit Price Frequency$#,##0.00;($#,##0.00)Price for one unit Unit_Priced25U`wao bceText50 frequency:o359`abPcdXe hWn"";"";"";"";"10";"40"DoctorIDDoctorID Table/QueryQSELECT DISTINCTROW [family Name], [doctorID] FROM doctors ORDER BY [family Name];3240;0&Click the arrow and select a supplier."SELECT DISTINCTROW [family Name], [doctorID] FROM doctors ORDER BY [family Name];";"doctors";"";"doctorID";"family Name";"PrimaryKey"d25U`zaXbceText110doctor:e35]`%adb cBox121m57`a(b eo k Product NameDate start course Product name Product_Named25U`ha(bUceText123 start course:o359`cdehn"";"";"";"";"10";"40"drugIDDrugID Table/+LVAL7QueryISELECT DISTINCTROW [drug Name], [drugID] FROM drugs ORDER BY [drug Name];1080;0&Click the arrow and select a category.[Event Procedure]x"SELECT DISTINCTROW [drug Name], [drugID] FROM drugs ORDER BY [drug Name];";"drugs";"";"drugID";"drug Name";"PrimaryKey"d5U`abtceText126drug:d5U7`@a btceText129hNOTE: If you enter a drug that isn't in the list, an event procedure responds by letting you add a drug.LVALͬ Y%T4 `U(Detail1mDrug_NameDrug named Text11mDRugIDd Text14eBox20h Button23d Text24mtablets_per_packetTablets per packetd Text35m cost_per_packetCost per packetd Text37LVAL i_VBA_MODULE\Y`U(Y%T4 `U(X`U(xJ E8FX`U(Y`U( BBB r4z8|<~@vDHLPpT0[LS S6LLLLL<4<8<<<N0{54251E59-0934-11D3-80A5-006008552884}d%8"*\Rffff*638a825c4*\R1*#2e*\R1*#85*\R1*#87*\R1*#88*\R1*#0*\R1*#8f*\R1*#1c*\R1*#8e (UF$D`@hk<^F`$kD i (p0 $6@ $p $ $ $ $6 $ $@ $6p $ $Dp`($k@p0x6x $p0  $  $ $LVAL L@x @h L<(<@(x @h @XX @@T @pP @@ @< @8 @( @$ pL<(<@x @h @X P@T @(P @X@ @@< @p8 @( @$ 00p`H<ME28 "@ /HX "( *8:0TH|`0 " ` 8h , *:0T|  *Use database order for string comparisons.@0 LB@Bl p2 Select the main form, requery drug ID combo box,% and set value of drug ID combo box. <""B@\ " <")l LB@(lH LB@ <""B@\ " <") LVAL (Technique 3 module version - Not in List LB@X 'Technique 3 module version- Not in List LB@X<Attribute VB_Name = "Form_Technique 3_(d rug fX used by module version)" " Bas0{54251E59-0934-11D3-80A5-00600855 2884} >Cr eatab`= True ]Pre declaIdC"Expo= Fals @TemplateDerivhCus`tomizD$Optx Comp@ DTv ' Uzdorder sng cisons. #Slicit PFJ Sub Button23_C@k() DoCmd.Clm EndހAfterUpFeSav#SelectObj@ A_FOR0M, "~Ly - Not in pListls ![W ]![DRugID].Rrery6uMeDUnload(Cancel As IntegerV!' D the ma:, r* IDArbo box,acset valof |^bbb@-1a1__SRP_2rU   XYAi XXyX@411rrr@8 Qzzz@ <Q i|||@@ ~~~@D1vvv@H1@L a 1q@P1@T pppH?l4/'h%x"$ `x ,x5h4$ xh|0*'h%x"$ `x x5h0'h%:X%x"$ `x WLVALcx5hT<:@%PT:X%x"$ Tx $T P $ < )xTP<|$:(%8 8 $ Q$oh%<:@%PT:X%x"$ Tx $T P $ <,) xTP8<5hX0$ (xTP<8$h|0*'h%x"$ `x x5h0'h%:X%x"$ `x x5hT<:@%PT:X%x"$ Tx $T P $ < )xTP<|$:(%8 8 $ Q$oh%<:@%PT:X%x"$ Tx $T P $ <,) xTP8<5hX0$ (xTP<8$h<LLK__SRP_3rU `$`< $)`@ (i`D8!&pwLVAL 023c g&hi0j&ki[Event Procedure]GŲ@Drugs Add Category[Event Procedure] Solution.hlp8 hApple LaserWriter II NTX WD[ od,XZZe?`!)@Apple LaserWriter II NTXpscriptLPT1:d27ee1h5i14bcgXj14bcgXm59gX`(Detail1m57U`abp drug Name drug Name drug name. drug_Named5U`abcText11 drug Name:m57U`apbcJkDRugIDDrugIDdrugid (prefix by DG)d5U`avbcText14drugid:e15U`abpcBox20h1U`PabiButton23Done[Event Procedure]d5U7`aXbcText24ݏNOTE: When you close this form, an event procedure requeries the drug list in the main form and sets the drug value to the one you've entered.m57U`a8bgcJktablets per packetTablets per packettablets per packettablets_per_packetd5U`a8bcText35tablets per packet:m57U`abgcJkcost per packetCost per packet#,##0.00;-#,##0.00cost per packetcost_per_packetd5U`abcText37cost per packet:LVALͬe`U(Detail0eBox103eBox102eBox101eBox100eBox99eBox98mPatientIDd Text43m English_NameEnglish Named Text48m Quantity_Per_UnitQuantity Per Unitd Text49m Unit_PriceUnit Priced Text50oDoctorIDd Text110eBox121mProduct_NameProduct Named Text123oDRugIDd Text126d Text129Date start courseDate end courseDosageFrequencyDoses per dayLVAL i_VBA_MODULE\`U(xgERk (SLS S<N0{85889565-E2F6-11D3-80CB-006008552884}p($ `|@pi" i$`(z`*x`ht`,r0H $4x $ $0 $4 $@ $p $4 $ $0 $8 $h $( H 0p@ y_Pe@ cexText49do@ k@ eque@ #0.0h00@ME" LVAL   B(D7p"  0 : * =P @pH8  :   0Z< Display message box asking if user wants to add a new drug.Do you want to add a new drug?$drug Not In List$J'( (  User chose Yes.* Remove new name from drug ID combo box so4 control can be requeried when user returns to form. 0 2 4 6 LB@.9 Open Add Category form and set the Category Name value. " <")@4 Continue without displaying default error message. B'$hl LB@3`4a@.Technique 3_(drug form used by module version) 8 : LB@X`Attribute VB_Name = "Form_Technique 3 macro version- not in list" Bas0{85889565-E2F6-11D3-80CB-006008552884} |Creatabl!CTrue ]Pr@edeclaId"ExposBeFals @TemplateDeriv%Cus`tomizD$P Sub drugID_NotInL(NewD\ As Sng, Respon Integer) Dim C&0gory, yinc Ň it/MsgDialog/ ' Disvy message box asking if user wants to add a new6. )= Box("Do youO?", 36, "H H InJ H"?If>= 6 ThenE ' U%chp Yes!$AB'@Vmove+n!from- ID combo:so control can be reriwACreturnCfHDoCmd.Sav DoMenuItem A_FORMBAR,EDITUNDOFIELD, MENU_VE R20 I' O:p@AaF and set the F†value( "_(c:d bodu)6A_NALAADD'a s![C ]![De }4]uId ''H C4inwithout dWUdefault errorYfm= DATA_ERRCONTPINUE,E )IFf!SubALVAL 03abcXghipjk,@ treatment TreatmentHelv8 hApple LaserWriter II NTX TD[ od,Xe`!)@Apple LaserWriter II NTXpscriptLPT2: dbce3f1jk3l3m5o3p`Detail0e35]`4a cBox103e35]`4aCbccBox102e35]`4ab cBox101e35]`4abcBox100e35]`4ab cBox99e35]`4a,bcBox98m57;`abe8 PatientID PatientID:Don't enter a number here. Number filled in automatically.d25U`zabceText43 Patient ID:m57`ab eo k English NameDate end courseName of product in English English_Named25U`wabceText48 end course:m57`abceTkQuantity Per UnitDosage1Contents of one "unit" of product (minimum order)Quantity_Per_Unitd25U`wab6ceText49dose:m57`ao bek Unit Price Frequency$#,##0.00;($#,##0.00)Price for one unit Unit_Priced25U`wao bceText50 frequency:o359`abPcdXe hWn"";"";"";"";"10";"40"DoctorIDDoctorID Table/QueryQSELECT DISTINCTROW [family Name], [doctorID] FROM doctors ORDER BY [family Name];3240;0&Click the arrow and select a supplier."SELECT DISTINCTROW [family Name], [doctorID] FROM doctors ORDER BY [family Name];";"doctors";"";"doctorID";"family Name";"PrimaryKey"d25U`zaXbceText110doctor:e35]`%adb cBox121m57`a(b eo k Product NameDate start course Product name Product_Named25U`ha(bUceText123 start course:o359`cdehn"";"";"";"";"10";"40"drugIDDrugID Table/'LVAL3QueryISELECT DISTINCTROW [drug Name], [drugID] FROM drugs ORDER BY [drug Name];1080;0&Click the arrow and select a category.technique 3 notinlistx"SELECT DISTINCTROW [drug Name], [drugID] FROM drugs ORDER BY [drug Name];";"drugs";"";"drugID";"drug Name";"PrimaryKey"d5U`abtceText126drug:d5U7`@a btceText129hNOTE: If you enter a drug that isn't in the list, an event procedure responds by letting you add a drug.LVALͬ m`U(Detail1mDrug_NameDrug named Text11mDRugIDd Text14eBox20h Button23d Text24mtablets_per_packetTablets per packetd Text35m cost_per_packetCost per packetd Text37LVAL i_VBA_MODULEY`U(x Ej#  (SLS S<N0{8588956D-E2F6-11D3-80CB-006008552884}#'8(UF$D`h@<^F`$@D i (p0 $6@ $p $ $ $ $6 $ $@ $6p $ $Dp`$@@p0x6x $p0  $  $ $Xp0x@(x @h LVAL [<(<x @h @X p(T @P @@ (< @8 @( $ p`<(<Hx @h @X PT @P @@ p(< @8 @( $ 00p@ME28 "@ /HX "( *8:0TH|`0 " ` 8h , *:0T|  *Use database order for string comparisons.@0 LB@Bl p2 Select the main form, requery drug ID combo box,% and set value of drug ID combo box. <""B@\ " <")l LB@(lH LB@ <""B@\ " <") (Technique 3 module version - Not in List LB@X 'Technique 3 module version- Not in List LB@X@Attribute VB_Name = "Form_Technique 3_(d rug fX used by macro version)"  Bas0{8588956D-E2F6-11D3-80CB-006008552884} >Cre atablCTrue ]PredeclaId"Expo= Fals @TemplateDerivgCustomizD$OptAx Comp@ DTv 'Uzdorder sng cisons. 0LVAL<ͬ ^%T4 `U(Detail0koptionUSiButton132d Text133iButton134d Text135nPatientIDd Text138d Text139LVAL i_VBA_MODULE! T{%T4 `U(^%T4 `U(z%T4 `U(x6E=Fz%T4 `U({%T4 `U(..4p8r<t@xD|HLP[LS S6LLN0{54251E5E-0934-11D3-80A5-006008552884}:7$*\Rffff*21373acde8*\R1*#4c*\R1*#4a*\R1*#55*\R1*#53 @($^`(Dk`nxxp0 $8 $  $p`X(2 r(p@t @(d @T \z@D 00XME"  v 2 ,   :  F`    0ZpmSELECT DISTINCTROW patients.[patientID], [given Name] & ' ' & [family Name] AS Name FROM patients WHERE town 'n+ Set criteria to match option group choice.[TeLVAL chn ` for n = 'bristol' 'n a n <> 'bristol' 'nh n,ORDER BY [given Name] & ' ' & [family Name];'n@Set the RowSource property of the list box and requery the list. n X(p XB@\l0(7Attribute VB_Name = "Form_Technique 4 - Runtime"D Basb0{54251E5E-0934-11D3-80A5-0060085@52884} |CreatablCTrue ]Pre declaId"Expose!Fals @TemplateDeriv%CustomizD$P Sub optionUS_AfterUpd `() Dim SQLSource As rSng SELECT DISTINCTROW patients.[ID], [g\n  ] & '& [family AS FROM" WHERE `town D' Set cri bia match7 group choice2.C If?`1 ThenC>4& "= 'briUl'A Eg'AV<>nd` If ORDER BYL;DADthe RowDoproperty of Al2 box a!reryI[PCol.G=DŽ. C5E__SRP_10rU !## $Q$% 1 Y @4 a @8  ppp@ <  rrr@@  ttt@D !xxx@H1!Y|||@L Y!?Cx,dt! t Hd(T]/Dt5d\E lx*1xS lx*1x lx*1xlxt! t tt! t Dt8(SxtdD<[__SRP_11erU X$`pLVALqLVAL} 03abcgh iajkSelect PatientHelv hApple LaserWriter II NTX TD[ od,Xe`!)@Apple LaserWriter II NTXpscriptLPT2: dbce3f1jk3l3m5o3p`Detail0k35U` abcoptionUS[Event Procedure]1i2W` aL Button132d25W` a+bVcText133Bristol Patientsi2W` a Button134d25W` aubcText135Non-Bristol patientsn3U`a bcd4l PatientID Table/QueryߥSELECT DISTINCTROW Patients.[patientID], [given Name] & " " & [family Name] AS Name FROM patients WHERE town = "bristol" ORDER BY [given Name] & " " & [family Name];0d5U` abceText138Patient:d5U`a| bceText139ݦNOTE: When you select an option at the right, the AfterUpdate event procedure for the option group sets the RowSource property of the list box and requeries the list.LVALͬ R[`U(Detail0d Text133d Text135d Text138d Text139ibristoloptioninonbristoloptionkoptionpatientnbristolPatientd Label141n nonbristolpatientLVAL i_VBA_MODULE Xտi`U(R[`U(Կi`U(x@&EԿi`U(տi`U(B88b |48p<@DtHxLrPP[LS S6<<<<N0{5B88527F-E394-11D3-80CB-006008552884}518"*\Rffff*438ad3e87 ($^`DJ<`nxxp0 $8 $  $0`BT $$ $#I $ $  $P $`0 $ $ $00\@<`ME"  v 2 ,   :  F`    0ZpmSELECT DISTINCTROW patients.[patientID], [givLVAL en Name] & ' ' & [family Name] AS Name FROM patients WHERE town 'n+ Set criteria to match option group choice.[Techn ` for n = 'bristol' 'n a n <> 'bristol' 'nh n,ORDER BY [given Name] & ' ' & [family Name];'n@Set the RowSource property of the list box and requery the list. n X(p XB@\l0(BAttribute VB_Name = "Form_TEchnique 4 macro version-Runt@ime" Basz0{5B88527F-E394-11D3-80CB-006008552884} |CreatablCTrue ]Predecl2aId"ExposeFals @TemplateDeriv%CustomizD$P Su b optUS_AfterUpd () Dim SQLSource As Sng SELECT DISTINCTROW pati@ents.[I@D], [g\n ] & '& [family AS FROM" WHERE town D' Set cdri@1ia@ytch7 group choice2.C If?`1 ThenC>4& "= 'briUl'A Eg'AV<>nd` If ORDER BYL;DADthe RowDoproperty of Al2 box a!reryI[PCol.G=DŽ. C5E__SRP_2rU _Q^_q_@41!S|||@81! `@<  ppp@@ a @D Y!@H ^ttt@L ^xxx@ P I_rrrH0 0  [__SRP_3erU \$`<LVALpILVALU03abcghijd2k "bristol" ORDER BY [family Name];0;2835d25U`'a/bceLabel141non Bristol Patient:)@ @@ gruo,gurpwIgruo,s`wjfpwvIgruo,wfbipjtxfWo`burzfuvjrpdj`mrhar|KIgruo,wfbipjtxfWordxmfa`vjbzfuvjrpdj`mrhar|GIgruo,wfbipjtxfW,wuf`wofpwgruoxvfda}o`burdj`mrhar|gruo:I gruo,wfbipjtxfW,wuf`wofpwgruoxvfda}ordxmfdj`mrhar|gruo5I gruo,wfbipjtxfXgjpdufbrudIgruo,wfbipjtxfXo`burzfuvjrpgjpdufbrudSIgruo,wfbipjtxfXordxmfa`vjbzfuvjrpgjpdufbrudOIgruo,wfbipjtxfYo`burzfuvjrpprwjpmjvw#I gruo,wfbipjtxfYordxmfzfuvjrpprwjpmjvw-I gruo,wfbipjtxfY,duxhgruoxvfda}o`burzfuvjrp Igruo,wfbipjtxfY,duxhgruoxvfda}ordxmfzfuvjrp)I gruo,wfbipjtxfZo`burzfuvjrpuxpwjofIgruo,wfbipjtxfZordxmfzfuvjrpuxpwjofIov}vdaIufsruw,s`wjfpwv,v`zf`vufsruwIvsmjw`ddufvvIvsmjwp`ofIjwp`ofIPatients   GPatients  Patients   GPatients   PatientPatientPatientPatients PatientPatientPatientPatients PatientPatientPatientPatients PatientPatientPatientPatients VClN    (    0                    PatientID Family name Given nameInitialsTitleGender Date of BirthAddr1Addr2TownCountyPostcodeCountry TelephoneSSSS j.rC.rD PatientID PrimaryKey{q@ Q~4h$aq_.@@     @   f|`osmfWVb`mbxm`wjrprp`hurxs*f|`osmfWWvfwwjphbujwfuj`rp`hhufh`wftxfujfv*f|`osmfWW``prwifuhurxsbujwfuj`f|`osmf*f|`osmfWXtxfu}xvjph`ujwiofwjb*f|`osmfWYxpjtxfz`mxfv*f|`osmfWZbi`u`bwfugxpbwjrp*f|`osmfW[jjg*f|`osmfW[`o@ChurchillFrankFCWMrm!!!!!!!!  k@HurstFannyAHMsf N@PhillipsFrederickFGMrm3a Somerset RoadBath7777733#"  U@de BourghCatherineCALadyf14 Rosings LaneBristol<<<<<55&%! @CollinsCharlotteCMMrsfThe Old VicarageHunsfordSomersetCCCC;33#" @WickamGeorgeGAMrm @DarcyFitzwilliamFRJMrm6 Pemberley RoadNailsea:::::33#"  @>@BennetLizaEGMsf K@BingleyJaneJWMrsfNetherfieldHigh StreetBackwell<<<<<4) j@DavisDavidDJDrm @JenningsJaneJEMrsf  V@MiddletonJohnJRFSirmBathBA4 5GG---%%!!!    @SladeLucyMLMsf  u@FerrarsEdwardEMrm301 Burton WayKeynsham44444,,  @@DashwoodHenryHLMrm21 Norland ParkBath22222..  @WestonAnneALMrsf @GoddardSusanSMrsf @V@KnightleyJohnJHMrm )@MartinRobertJRMrm81 North RoadBristolBS2 2DD:::22++ :@WoodhouseEmmaEJMissf48 South StreetBristol7777700!  @AllenSarahSVMrsf @ThorpeIsabellaIGMsfFlat 331 Worth CloseBristolBS78 5TG0117 9342761OCC;;4&  +@TilneyHenryHFJMrm5 Northanger StreetBathBANESBA5 7XY01225 124567NBB:511 .@MorlandCEMissf24 The MewsBristolBS1 9NA0117 9123456A55--&& *0 @ @ @       .rC PatientID PrimaryKey0 @ @ @      RmtInfoLongLvLvPropLvModuleLvExtraH r m0 Id ParentIdName        cs.........., s@@sej.@MSysIMEXSpecs.........., s@@count patients for Report1@@bc@ S_SSG;;;;;;9 `'`mm9@Xs@Example 04 query using criteria in different columns C@`@[ymmaUUUUUUS `$ym9@l5C@Example 01 query using the sort option and top valuesC@Ez@SznnbVVVVVVT `Bx@@Patients test controls@LWF000_@aUCC7777775 -n@A+@Example 22b Drugs not used in treatment (using in operator)[@@@ 2thh\\\\\\\Z @v@3@Example 22a Drugs not used in treatment (using exists operator)[@@ Sxll```````^ @ $2>@!u0@`Example 23 SQL create table@SH<<<<<<<<<: >-@-@Example 05a operator like using criteria in same column 5Np]B&oP\/ rD1 {K{@ @k gDoctorsTreatment%@1( gDrugsTreatmentDrugs.DrugID = Treatment.DrugIDE gDoctors.DoctorID( ggDR nameDoctors.[Family name]4 ogcost[Dosage]*[COST PER PACKET]6 ogTreatment.Frequency+ ggTreatment.Dosage( ggTreatment.PatientID+ ggDrugs.[Drug name]) ggTreatment.DrugID( ggDoctors gDrugs gTreatment g Gg Gg g ftown<>"Bristol"' 'fname[given name]&" "&[family name]: of patientid! gfpatients f Gf f etown="Bristol"& 'ename[given name]&" "&[family name]: oe patientid! gepatients e Ge e d DCount(Treatment.DrugID)0 /d "@1 gd@1 'dPatientsTreatment(@1) dCountOfOrder IDCount(Treatment.DrugID)> odName"@1 odTreatment dPatients d Gd Gd d c dCount(Treatment.DrugID)0 /c "@1 gc@1 'cPatientsTreatment(@1) cCountOfOrder IDCount(Treatment.DrugID)> ocName"@ 1 ocTreatment cPatients c GVCN          " PatientIDDrugIDDoctorIDDate start courseDate end courseDosage Frequency Doses per day%V! Reference Reference1 Reference204[05[06[0/\07\09\0:\0;\4\4\4\08]4]4]4]4]4]4 ]4 ]4 ]4 ]4 ]fname[given name]&" "&[family name]: of patientid! gfpatients f Gf f etown="Bristol"& 'ename[given name]&" "&[family name]: oefCM6@CM6@technique 4 form nonbristol::::::::::: e MM6@ MM6@technique 4 form bristol77777777777 dM6@ВM6@technique 1 module form66666666666 cTM6@M6@technique 1 macro form55555555555 \M6@oM6@Patients''''''''''' @M6@\M6@MSysModules2+++++++++++ >M6@M6@MSysModules*********** ;nއM6@nއM6@MSysIMEXSpecs,,,,,,,,,,, 7$M6@KM6@MSysIMEXColumns........... bM6@$M6@Example 23 using field expressions in field expressionsVVVVVVVVVVV aM6@M6@`Example 23 SQL create table::::::::::: `M6@M6@Example 22b Drugs not used in treatment (using in operator)ZZZZZZZZZZZ S{qg @ @ @ @ @ @ @ @_4_4_4 _4`4!`4#`4$`4%`4&`4'`4"a4(a4*a4)b4+b4-b4.b4/b40b41b42b43b44b45b4,c46cccccccc c c47d d d d dddddd d d eeeeeeeffff f!f`4&`4'`4"a4(a4*a@ {O#{5l @ @ @ @ @ @_4_4_4 _4`4!`4#`4$`4%`4&`4'`4"a4(a4*a4)b4+b4-b4.b4/b40b41b42b43b44b45b4,c46cccccccc c c47d d d d dddddd d d eeeefɓM6@M6@Treatment((((((((((( fCM6@CM6@technique 4 form nonbristol::::::::::: e MM6@ MM6@technique 4 form bristol77777777777 dM6@ВM6@technique 1 module form66666666666 cTM6@M6@technique 1 macro form55555555555 \M6@oM6@Patients''''''''''' @M6@\M6@MSysModules2+++++++++++ >M6@M6@MSysModules*********** ;nއM6@nއM6@MSysIMEXSpecs,,,,, &PF@G@@DG10)% @ @@ @?DG10)% @-@/@?DG9(% -@.@@DG1(%[[?1@?DG4(% +@@-@@DG12)%`+@@,@ @DG6(%+@+@?DG4(%dGz @ @ @ @ @ @ @ @_4_4_4 _4`4!`4#`4$`4%`4&`4'`4"a4(a4*a4)b4+b4-b4.b4/b40b41b42b43b44b45b4,c46cccccccc c c47d d d d dddddd d d eeeeeeeffff f!f"fg#DoctorsDiagnosisDiagnosisDoctorIDDoctorsDoctorID=5.& PatientsDiagnosisDiagnosisPatientIDPatientsPatientIDA80' Reference3TreatmentDoctorIDDoctorsDoctorID7/(  Reference2TreatmentDoctorIDDoctorsDoctorID7/(  Reference1TreatmentDrugIDDrugsDrugID1+&  ReferenceTreatmentPatientIDPatientsPatientID90(  @  dhWdhWVdhWVdhWXdhZdhZdh\dh_amily name Given nameInitialsTitleGender Date of BirthAddr1Addr2TownCountyPostcodeCountry Telephone  PatientID PrimaryKeytID PrimaryKey @    r unknown valuesDDDDDDDDDDD DeYM6@eYM6@Example 06 query using like::::::::::: CAM6@eYM6@Example 05a operator like using criteria in same columnVVVVVVVVVVV B`~M6@~M6@Example 05 operator or using criteria in same columnSSSSSSSSSSS A"~M6@`~M6@Example 04 query using criteria in different columnsSSSSSSSSSSS @}M6@"~M6@Example 03b operator between comparisonFFFFFFFFFFF ?}M6@}M6@Example 03a operator greater criteriaDDDDDDDDDDD >n}M6@}M6@Example 03 query using selection criteriaHHHHHHHHHHH ='*}M6@n}M6@Example 02 query using multiple tablesEEEEEEEEEEE <|M6@'*}M6@Example 01 query using the sort option and top valuesTTTTTTTTTTT ;|M6@|M6@Drugs (AutoLookup form)66666666666 !o|M6@|M6@Drugs$$$$$$$$$$$ 1|M6@1|M6@Doctors&&&&&&&&&&& :w{M6@w{M6@count patients for Report199999999999 9~zM6@ 9{M6@all_info''''''''''' \zM6@@zM6@age_range((((((((((( 8 \zM6@\zM6@Admin$$$$$$$$$$$ 7\zM6@\zM6@technique 4 option wrong77777777777 6\zM6@\zM6@technique 4 option11111111111 5\zM6@\zM6@technique 3 notinlist44444444444 4\zM6@\zM6@technique 3 drug unload66666666666 3\zM6@\zM6@technique 3 close00000000000 2\zM6@\zM6@technique 2 sort/////////// 1\zM6@\zM6@technique 2 current22222222222 c0o`Q3$y[L=9*{l]C%vg:+|       ObjectId AttributeOrderNa  Vx ?=  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o   Vx ?=  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    Yb;  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o     ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o   Vx ?=  Yb;   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o   Vx ?=   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    Vx ?=  Yb;   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o   Vx ?=   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o   LVAL <8Rs8M?x R8RRR   RRRRRRRR   ( Patients.PatientIDPatientsPatients.Family nameRRRR Rq|@ RR R0AT R0AT PatientsRRR RR۱0@=~sq_cTechnique 2 macro version- Find record~sq_cselectpatientR 8RPR XRxR[Patients].[PatientID]8R[Patients].[Family name]XR R0ATyR0ATr daPatients RR RR8RXR RR R R@RHRPRXR`RR RR RR RR RR RR RR RR RR RR RR RR RR RR RR RR RR RR RR RR RR RR RR RR RR RR RR RR RR RRRRHR R @R R`pR R |R ( RR8 RCTR0 R` R R0 R ` R0 R R0 R` R RPatientsX Rh RPrimaryKey PatientID RRv RhRxRRRsRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR RRR0RRPatients PrimaryKey@RRR RR@RRRRLVAL @ @ @ @ @ @ @ @ @ @ppppppqq%q#q!q"q $q r&r*r+r(r)r,r's-s/s0s.t1t3t4t2w`w`w`w`{`{` {`{`{`{ ` {`|` |`|`|` |`|`| `|` }`}`}`}`~`~`'~`(~`)~`*~`+~`,~`-~``.`0`1`2`3`4`5`6`/`B`E`D`FRR R\LVALxtKKDValidationRuleValidationText ColumnWidth ColumnOrdeKKDValidationRuleValidationText ColumnWidth ColumnOrder ColumnHidden DescriptionFormatCaption InputMask DefaultValueRequiredAllowZeroLength DecimalPlacesFilterOrderBy OrderByOnH Drug name       Tablets per packet   > 6Integer = number of tablets in each packet when bought    Cost per packet   3 +Currency = cost of each packet to hostpital #,##0.00;-#,##0.00    Q DrugID     "DG"     KKDValidationRuleValidationText ColumnWidth ColumnOrder ColumnHidden DescriptionFormatCaption InputMask DefaultValueRequiredAllowZeroLengthF Family name t      E Given name V      CInitials       @ Title       xInternal telephone r       All are 4-digit numbers  00001DoctorID   KKDW RecordLocks ODBCTimeout MaxRecords RecordsetTypeFilterOrderBy OrderByOn1  <  KKDValidationRuleValidationText ColumnWidth ColumnOrder ColumnHidden DescriptionFormat InputMaskCaption DefaultValueRequiredAllowZeroLength DecimalPlacesD age_range       K age_min       0  K age_max       0  KKD AccessVersionBuild%  07.53 KKD KeepLocal TLVALȄ`{{          2 22( [Family name].[BackColor]6553522([Family name].[BackColor]25522 2front0 "6press to see useful examples-14informative message22([family name] Like [what surname] & "*"22 front0100cghijXk treatmentHelv8 hApple LaserWriter II NTX TD[ od,Xe`!)@Apple LaserWriter II NTXpscriptLPT1: 22( [Family name].[BackColor]6553522([Family name].[BackColor]25522 2front0 "6press to see useful examples-14informative message22([family name] Like [what surname] & "*"22 front010LVALȈ @ @ @ @ @ @0cghixj|k,/@Drugs (AutoLookup form)Helv8 hͬ%T4 `U(Detail0mPatient_IDPatient IDd Text0mGiven_nameGiven named Text7mInitialsd Text8mTitled Text9m Genderd Text10m Family_nameFamily named Text11m Date_of_BirthDate of Birthd Text12PatientIDAddr1ͬ%T4 `U(Detail0mPatient_IDPatient IDd Text0mGiven_nameGiven named Text7mInitialsd Text8mTitled Text9m Genderd Text10m Family_nameFamily named Text11m Date_of_BirthDaͬ%T4 `U(Detail0mPatient_IDPatient IDd Text0mGiven_nameGiven named Text7mInitialsd Text8mTitled Text9m Genderd Text10m Family_nameFamily named Text11m Date_of_BirthDate of Birthd Text12PatientIDAddr1Addr2TownCountyPostcodeCountryTelephoneͬ&*I`U(Detail0oPatientIDd Text2pEmbedded1d Text3d Text4ͬs&*I`U(Detail0oDrugIDd Text2pEmbedded1d Text3d Text4ͬ%T4 `U(Detail0mPatientIDd Text0mDrugIDd Text1mPhoned Text4d Text6d Text7m named Text9 Date start courseDate end courseDosageFrequencyDoses per dayoDoctorIDd Label11mDrug_NameDrug nameLVALN <<            @      eD DateDelimDateFourDigitYearDateLeadingZeros DateOrder DecimalPointFieldSeparatorFileTypeSpecIDSpecNameSpecTypeStartRow TextDelim TimeDelimp/@<=  PrimaryKXME&2 B 8  @ H P%X ?p%#  B  B B %@ ?Xx  B  (/  )Use database order for string comparisons' ''  }    } $'hh  } _  $' $' 'f`   } $'   } $'  } _   } $' 'fpZ '  } ʐ   }$'hfAttribute VB_Name = "split nh" Option Compare Database P 'Udorder for sng cbisons Funcget_initial@s(fulll)$ rests & >$If InStr(-, " ") > 2 Then FMidc#/+ 1AE nd IfDo@ While.0 F& Lef.t8.C3:Loop' ' LDžsur ߁& },hL@reducf Ia@J ?E CCK/ @titleI@Dim~ A@I rG K hl,~`Q/ qSD"sdF7fW9*{  Vx ?=  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o   Vx ?=  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o   Vx ?=  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o   Vx ?=  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o   Vx ?=  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    Vx ?=    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o     Vx ?=    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o     Vx ?=    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o     Vx ?=    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o     Vx ?=    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    Vx ?=  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o 58 @ @ @ @ @ @ @ @ @ @ @ @ @_4_4_4 _4`4!`4#`4$`4%`4&`4'`4"a4(a4*a4)b4+b4-b4.b4/b40b41b42b43b44b45b4,c46cccccccc c c47d d d d dddddd d d eeeeeeeffff f!f"fg#g%g&g'g(g)g*g+g,g-g.g/g0g1g2g3g$k4kkkllllnnnnnn nooooooooooonLVALR`Q7ͬc%T4 `U(FormHeader1d Text12d Text13Detail0mDate_start_courseDate start coursed Text31oDoctord Text33oDrugd Text35m Date_end_courseDate end coursed Text37m Dosaged Text38mFrequencyd Text39mDoses_per_dayd Text40oPatientd Text42FormFooter2PatientIDDRugIDDoctorIDDoses per dayͬ@%T4 `U(FormHeader0Detail1eBox15mDoctorIDd Text0m Unit_PriceUnit Priced Text1m Quantityd Text2m DR_NameDR Named Text5mcostd Text7FormFooter2mOrder_SubtotalOrder Subtotald Text25Drug NameDosageFrequencymPatientIDd Label33mDRugIDd Label34ͬ;%T4 `U(FormHeader1Detail0mOrder_IDOrder IDd Text7mOrder_DateOrder Dated Text9mRequired_DateRequired Dated Text11mShipped_DateShipped Dated Text13 FormFooter2 DRugID Drug Name Tablets per packetCost per packetͬK`U(Detail0mFamily_nameFamily named Text2mCountryd Text4d Text6f Line7m DRugIDp Second_SubformSecond Subformd Text14d Text19TitleDate of BirthAddr1Addr2TownCountyPostcodeTelephonepdrug_formdrug formmGiven_nameGiven named Label20mInitialsd Label21mGenderd Label22m PatientIDd !Label23d "Label25LVALcM%`Q3$yWH.eGGGGGGGGGGGGGGG8888888888)ÉÉÉÉÉ5H&vPatients(0Patients22022Technique 3_(drug form used by macro version)02222([selectpatient][patientid] no_treatment22(:@[Forms]![Technique 1 macro version- dialog box].[Visible]False;=@BTechnique 1_(Treatment form used by macro dialog box form)3-1022=?2Technique 1_(Treatment form used by macro dialog box form)0 0c{ ghij$k7Drugsd7ei14bcgXj14bcgXm9gX` FormHeader1`Detail0m7U;`axb eOrder IDDrugIDGeneral Number!Unique order number from invoice.Order_IDd5U``axbcText7Drug ID:m7U;`abe&k Order Date Drug name Medium Date Order_Dated5U`abvcText9 drugname:m07U;`aHbepk Required DateTablets per packetGeneral Number Required_Dated5U`iaHbcText11Tablets per packet:m7U;`abeRk Shipped DateCost per packet#,##0.00;-#,##0.00 Shipped_Dated5U`wabcText13cost per packet:` FormFooter2LVAL @ @ @ @ @ @ @ @ @ @ @ @ @03abcX g#hij()kh0@!Treatment Details (Extended form)Helv8 hApple LaserWriter II NTX TD[ od,Xe`!)@Apple LaserWriter II NTXpscriptLPT1: dbcHelve3f1k3l3m5HelvnHelvo3Helvp` FormHeader0`Detail1e35]`abcBox15m57U;`3 abeuDoctorIDDoctorIDGeneral NumberOrders.Get Unit Price MS Sans Serifd25U`(ab9c,eText0 DoctorID: MS Sans Serifm57U`8abe)k Unit PriceDosage>=00You must enter a price for each product ordered.0.00 MS Sans Serif Unit_Priced25U`KabceText1Dosage: MS Sans Serifm57` abekQuantity FrequencyGeneral Number>03You must enter a value for number of units ordered.1 MS Sans Serifd25]`%abceText2 frequency: MS Sans Serifm 57U`Fabe kDR NameDR name MS Sans SerifDR_Named25U`abceText5Doctor: MS Sans Serifm 57`Dabkcostcost$#,##0.00;($#,##0.00) MS Sans Serifd25U`PabXceText7cost: MS Sans Serifm7U`namb\ek PatientID PatientIDLinks to Patients tabled5UambcLabel33 PatientID:m7U`jabekDrugIDDrugIDLinks to Drugs tabled5U`abXcLabel34DrugID:` FormFooter2m7U`aOrder Subtotal =Sum([cost])$#,##0.00;($#,##0.00) MS Sans SerifOrder_Subtotald5U`ab8cText25Order Subtotal: MS Sans SerifO?݆=5J׃nGƁQdU7($ukkiҲu@ڲu@~sq_cPatients test controls~sq_cTitle*@^^^RFFFFFFD `fɉu@.9u@technique 4 form nonbristol[@ @THH<<<<<<<: @bO G@tG3 @using field expressions in field expressions@ @@eYYMMMMMMMK @^@m9@%t1@Example 22 Drugs not used in Treatment (unmatched query)C@@@qeeYYYYYYYW @[N@c G@qNN@Example 21 percent cost@@@PDD88888886 @W`m9@4]@Example 18a oldest and youngest@ @XLL@@@@@@@> @S4m9@~>@Example 17 date format@@OCC77777775 @PL@6@Example 15a iif with null values@@YMMAAAAAAA? @K` m9@xp@Example 11a another group criteria exampleC@@cWWKKKKKKKI @EO\m9@ʴr@Example 07 testing for unknown values@ @^RRFFFFFFFD @A`mm9@Xs@Example 04 query using criteria in different columnsC@@maaUUUUUUUS @<ym9@l5C@Example 01 query using the sort option and top valuesC@@nbbVVVVVVVT @W+@623 @Doctors[@444(((((((& @`OF@@TOF@age_range@666*******( @3{ym@$ q@technique 3 close~@>2222222220 / P@&z,Q@technique 1 ok button@B6666666664 (Hk@F@!'Ų@Report1@LWF000RF44((((((& %3@V4@Labels Patients@LWF000m@ZN<<000000. r@" m@Technique 2 macro version- Find recordGGGGGGGGGGE h*~`QB qbD5dU7($u& % Vx ?= % %ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o % j jۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o j i iۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o i h hۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o h $ Vx ?= $ $ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o $ # Vx ?= # #ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o # " Vx ?= " "ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o " ! Vx ?= ! !ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o !   Vx ?=    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    Vx ?=  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    Vx ?=  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o LVAL H&gDrugsn&rPatients 0abcg+hiSj1k~ Treatmenttemp d7ee1bRcRi14bcgj14bcgm49bcgn25cdho27efj`. FormHeader1d25]7`ab cdText12tempd257`aqb cdText13temp`Detail0m7U`E abHe'kDate start courseDate start coursed/m/yyDefault = todayDate_start_coursed5U`5abcText31Date start course:o5U`b c9 dqeDoctorDoctorID Table/Query>$Form_Combo 2 - Adding <>eK`U(jK`U(dK`U(iK`U(Label0 drugtodisplayLabel5Button6 Button6_Click Combo 2- Adding <>mK`U(lK`U(Commandformexit_Click Combo 2 - Adding <>I`U(I`U(I`U(XI`U(WI`U( CommandexitZI`U(YI`U(Commandexit_ClicLVAL ak^I`U(]I`U( Commandexit3 Form_front1gI`U(jI`U(hI`U(iI`U(CommandformexitnI`U(mI`U(pI`U(oI`U(Commandexitform2_Click $press to see really usefull examplesq=`U(u=`U(t=`U( Form_Form1x=`U(=`U(y=`U(=`U(Command4end_date begin_dateCommand4_Click testForm_Formtech14f`U(7f`U(6f`U(9f`U(;f`U(:f`U( 3Technique1_(Treatment form used by dialog box form)Cf`U(Ef`U(Df`U(Form_TreatmentVf`U(kf`U(Wf`U(jf`U(Date_end_courseDrugID Doses_per_day selectpatient FormHeader FormFooterDosageDate_start_courseselectpatient_AfterUpdate pnf`U(mf`U(selectpatient_Changepf`U(of`U(Form_t1f`U(f`U(f`U(f`U(f`U( patientidf`U(f`U(PatientID_Changef`U(f`U(Form_MouseDownForm_MouseMove Form_MouseUpf`U(f`U( selectpatientf`U( PatientIDEnabled selecting patient treatment not foundf`U(f`U(Text18 tf`U(f`U(f`U(f`U(count2 xf`U(f`U(f`U(f`U(f`U(f`VCNYY  2  2  2  2nameaddresshobby1hobby2 2nameinitialstitlesurnameaddresshobby1hobby2!NNUe#dNXNeE%eu!`xNNu%eu!mNN5eEeeU#ptNTN5Ee#NNuee$NN%u5$PeNPNeueE$NNueU5$@iTNNeue5$`fNLNe(`aNNuueE #NNeeUee$`vNHNeUeeEeee# NNee$mPNN%ueeeU$mAddr1d Addr1_LabelAddr1 LabelmAddr2d Addr2_LabelAddr2 LabelmTownd Town_LabelTown LabelmCountyd County_LabelCounty LabelmPostcoded Postcode_LabelPostcode LabelmCountryd Country_LabelCountry LabelmTelephoned Telephone_LabelTelephone LabeloTitled Title_LabelTitle LabelrOLEUnbound28 FormFooter{lQQQQQQQQ>+xeR?,xD1xeR?ubJ7$Rr F wwwwwDrugwwDruwDrugs.[Drug name]) gwwDrugs.[Drug name]) gw Drugs.[Drug name]) gww Drugs.[Drug name]) gw tPatienttPatienttPatients tPatients t tPatients t  tPatients t  tPatienttPatients t  Gt t sDrugs s  Gs s r7@1 'r__DrugID Or__patientid OrTreatment Details (Extended form)Subform 2 - One-Many-OneEE- r  Gr r q Gq  [Drug Name]# 'qDRugs q [DRug Name]# gq[drugID] gq q p([__DRugID] = DRugID)- 'p__DRugID OptreatmentCombo 4- Link drugs to treatment Subform== p  Gp p oTreatment o  Go o n Gn Doctors.[Family Name]- 'nDOCTORS nDoctors.[Family Name]- !X}B3zk\M:+ |mZK<- zk\M)@SW@@k@course mark3V@   |ge/:Ljo7{{e0,wFHV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    |ge/:Ljo7{{e0,wFHV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o       |ge/:Ljo7{{e0,wFHV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o        |ge/:Ljo7{{e0,wFHV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o     |ge/:Ljo7{{e0,wFHV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    |ge/:Ljo7{{e0,wFHV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    |ge/:Ljo7{{e0,wFHV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o     3V#jKiljpj{{e0,wFHV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    |ge/:Ljo7{{e0,wFHV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    |ge/:Ljo7{{e0,wFHV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o  ۇ O8V#jKuE*Ć($_AV#jKV#J SmithA B C GriggBuckingham Palaceswimmingmotor racing1% qProf X Y Z BloggsChez Nous Westoncycling**#1A B Smith1 High St The Hollow Clifton Bristolmotor racingswimmingE=1 qLVALC=======ĿĕĕĕĕĕĕĕĕĕkkAAÙoEs  @ @OPS$CCMJS_DU ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o KKD ColumnWidth ColumnOrder ColumnHiddenRequiredAllowZeroLengthFilterOrderByValidationRuleValidationText OrderByOn DescriptionKKD KeepLocal TKKD KeepLocal TKKD KeepLocal TKKD KeKKD KeepLocal TKKD KeepLocal TKKD KeepLocal TKKD KeepLocal TKKD KeepLocal TKKD KeepLocal TKKD KeepLocal TKKD KeepLocal TKKD KeepLocal TKKD KeepLocal TKKD KeepLocal TKKD KeepLocal TKKD KeepLocal TKKD KeepLocal TKKD KeepLocal TKKD KeepLocal TKKD KeepLocal TKKDW RecordLocks ODBCTimeout MaxRecords RecordsetTypeFilterOrderBy OrderByOn1  <  KKD ColumnWidth ColumnOrder ColumnHiddenRequiredAllowZeroLengthFilterOrderByValidationRuleValidationText OrderByOn DescriptionFormat InputMaskCaption DefaultValueDisplayControl RowHeightM name      m!   hP address d     mO hobby1      mO hobby2      mLVAL ]<BsM? BBB B  BBBBBBBB   ( doctors.doctoriddoctorsDoctorIDdoctors.family name Family nameBBBB B2@BB B!W B!W doctorsBhBB` BBx-G@D~sq_cTechnique 2 module basic version- Find Record~sq_cDoctorIDB BHB PB`BB [family name]PBB!W B!W DoctorID Family namedoctors BB BBBPB Family name B B B B@BHBPBXB`BB BB BB BB BB BB BB BB BB BB BB BB BB BB BB BB BB BB BB BB BB BB BB BB BB BB BB BB BB BBBBB B @B` B`pB` B |B  BB B#WB B0 Bp B B 0 B0 B B B0 B` Bdoctors BPrimaryKey( BBv (BBBB Bs B B B B B B B B B B B B B B B B B B B B B B B B B B B B BxB BBhBB BdoctorsPrimaryKey@B B(B B(B@B BBXBBB` LVALȱ~gd_Click Description ?A l@dirLH0* pHdpeople97,@ Z= n  9 EJ< DAO>BDA@O *\G{000@25E04-0C  0046}#3.5#0#C:\Program Files\Common Microsoft Shared\w\dao2535.tlb# 2.5/+ !patibility Lib0raryNut >tilty| 7*\CN7Office\UTILITY.MDA8w5   FForm_ P_VBA_MODULE2@_VBc_MdDU@LE@HB1t$,B,B^"B(B+BŽusername< !@9Main switchboHard?Q>9w"F2kCombo 3 - AutoLookuplect all>>9w"F2Combo 4 - DLookupuplect all>>9w"F2ACombo 5- Link drugs to treatment Subform2Combo 5- link patients name to patient subform2Combo 5_(treatment subform)to patient subform2combo5_(patient_subform)m)to patient subform2 drug pie chart_subform)m)to patient subform2X frontie chart_subform)m)to patient subform2 Normale chart_subform)m)to patient subform2Patientschart_subform)m)to patient subform2kPatients test controls)m)to patient subform2Subform 1 - Aggregate)m)to patient subform2ASubform 1_(subform)e)m)to patient subform2Subform 2 - One-Many-Many)to patient subform2Subform 2_(first subform))to patient subform2Subform 2_(second subform)to patient subform2 Technique 1 - Dialog Box)to patient subform2X Technique 1_(Treatment form used by dialog box form)2 Technique 2 - Find Recordm used by dialog box form)2(Technique 3 - Not in Listm used by dialog box form)2k(Technique 3_(drug form)tm used by dialog box form)2(Technique 4 - RuntimeLVAL dU(Form_BeforeUpdate Form_t2 macro Form_t2 basicf`U(PatientID_AfterUpdatef`U(f`U(f`U(f`U(f`U(f`U( no_treatments\;|? no treatments foundf`U(f`U( $Form_Technique 2 basic - Find Record $Form_Technique 2 macro - Find record +Form_Technique 2 module basic - Find Record +Form_Technique 2 macro version- Find recordbristolPatient 2Form_Technique 2 module basic version- Find Record *Form_Technique 1 macro version- Dialog box 1Form_Technique 1 module basic version- Dialog Box;Form_Tecnique 1_(treatment form used by module dialog form)<Form_Technique 1_(treatment form used by module dialog form)?Form_Technique 1_(Treatment form used by macro dialog box form)@Form_Technique 1_(treatment form used by module dialog box form) ,Form_Technique 3 module version- Not in ListtR[`U( 3Form_Technique 3_(drug form used by module version)U`U(Y`U(X`U( (Technique 3 module version - Not in List 'Technique 3 module version- Not in ListR`U(\`U([`U( +Form_Technique 3 macro version- not in list 2Form_Technique 3_(drug form used by macro version)qR[`U(uR[`U( (Form_Technique 4 module version- Runtime &Form_TEchnique 4 macro version-RuntimeR[`U(R[`U(e`U(R[`U(R[`U(R[`U(m`U(R[`U(~R[`U(R[`U(R[`U(R[`U(nonbristoloption bristoloptionR[`U(R[`U( optionpatientѿi`U(տi`U(Կi`U(nonbrifLVALrkkkkkkkkk k kkkkkkkkkkkkkkk&k'k(k)k*k+k,k-k.k/k0k1k2ooo o o o o o o o o o o o o o o o o o o o ooooooooooo o!o"o#o$o%o&o'o(o)o*o+o,o-o.o/      !"#$%&'()*+,-. /   !!!!""" " # # # #$!$"$#$$%%%&%'%(&)&*&&''''(((( ) ) ) ) ***)tm used by dialog box form)2A(temp_form_to_add_treatment_data by dialog box form)2(combo 5split name LVALqg]SI?5|?KKDValidationRuleValidationText ColumnWidth ColumnOrder ColumnHidden DescriptionFormat DecimalPlaces InputMaskCaption DefaultValueRequiredAllowZeroLengthn. &[Date end course]>=[Date start course]4 ,Date end course must be >= Date start coursevDate start course '   Default = today d/m/yy now$()  Date end course   e ]Must be greater than or equal to Date start course (validated when rcord is saved or updated) d/m/yy   Dosage   G ?Number of tablets per dose, default = 1, must be greater than 0   1    >0> 6Dosage must be > 0; does not have to be a whole number Frequency   V NDefault = 1 (= daily; 3 = every third day), must be greater than or equal to 1   1    >=1P HFrequency of treatment; must be >= 1 (where 1=daily, 3=every 3 days etc) Doses per day   ` XDefault = 1 (= once each day that tablets are taken), must be greater than or equal to 1   1    >=1E =Number of doses on days when treatment is given; must be >= 1c PatientID    Links to Patients table   ] DrugID    Links to Drugs table    iDoctorID f   Links to Doctor table   0  4LVAL@e 6X;h*Z$V hX(  "+XxpX 'hZ   } $''" < '<  $'@fh   $} $' < }'< $8''<   $} $'   $} $'\M   $}stolpatient \ؿi`U(⿄i`U(ῄi`U( Commandfind Report_Patients_saveasreport7z q`U(7z q`U(7z q`U(7z q`U(7z q`U(7z q`U(Commandfind_ClickAĒ`U(EĒ`U(DĒ`U(FĒ`U(HĒ`U(GĒ`U(sxG`U(sxG`U(sxG`U( split name get_initials get_surname get_title     x @  i XModule1 get_address split address  `  got more than 4 lines+__SRP_1rU~~~~~~~~~~k       ( Q 8 1H  XCancel hNewDataResponse  x   1!ButtonShiftXYfullname fulladdress address_line1 address_line2 address_line3 address_line4lineLVAL fKKDLValidationRuleValidationText ColumnWidth ColumnOrder ColumnHidden DescriptionFormat DecimalPlaces InputMaskCaption DefaultValueRequiredAllowZeroLengthFilterOrderBy OrderByOnDisplayControl RowSourceType RowSource BoundColumn ColumnCount ColumnHeads ColumnWidthsListRows ListWidth LimitToListw. &[Date end course]>=[Date start course]4 ,Date end course must be >= Date start course zDate start course '   Default = today d/m/yy now$()  Date end course   e ]Must be greater than or equal to Date start course (validated when rcord is saved or updated) d/m/yy   Dosage   G ?Number of tablets per dose, default = 1, must be greater than 0   1    >0> 6Dosage must be > 0; does not have to be a whole number m  Frequency   V NDefault = 1 (= daily; 3 = every third day), must be greater than or equal to 1   1    >=1P HFrequency of treatment; must be >= 1 (where 1=daily, 3=every 3 days etc) m Doses per day   ` XDefault = 1 (= once each day that tablets are taken), must be greater than or equal to 1   1    >=1E =Number of doses on days when treatment is given; must be >= 1 mP PatientID    Links to Patients table    o  Table/Queryu mSELECT DISTINCTROW [Patients].[PatientID], [Patients].[Given name], [Patients].[Family name] FROM [Patients];     900;1440;1440  3780twip  DrugID    Links to Drugs table     o  Table/QueryN FSELECT DISTINCTROW [Drugs].[Dru&LVAL2qg]SI?5` |? I @ @& % :.!";gID], [Drugs].[Drug name] FROM [Drugs];    912;1440  2352twip QDoctorID f   Links to Doctor table   0   o  Table/Queryp hSELECT DISTINCTROW [Doctors].[DoctorID], [Doctors].[Given name], [Doctors].[Family name] FROM [Doctors];     876;1440;1440  3756twip LVAL 2t^h0cghijXk ۱@ treatmentHelv8 hApple LaserWriter II NTX TD[ od,Xe`!)@Apple LaserWriter II NTXpscriptLPT1: dbcd ee3f1k3l3m5b@ i nj o3bl pe`f`o Detail0m7U;`abe PatientID PatientID-Number automatically assigned to new product.d5U` abcText0 Patient ID:m7`aXb# eo kdate start courseDate start course Long Datedate_start_coursed5]`aXbcText1Date start course:o5U9`cde] hn"";"";"";"";"10";"40"DRugIDDrugID Table/QueryISELECT DISTINCTROW [DrugID], [Drug Name] FROM Drugs ORDER BY [Drug Name];0Same as DrugID in Drugs table.x"SELECT DISTINCTROW [DrugID], [Drug Name] FROM Drugs ORDER BY [Drug Name];";"Drugs";"";"DrugID";"Drug Name";"PrimaryKey"d5U`abcText2Drugr:d5U`abcXText4ONOTE: Drug field displays Drug names from the Drugs table but saves ID numbers.22( Q[Drug Name]nz([Forms]![Combo 5 - values from a combo box]![DrugID].[Column](1))(>W[Forms]![Combo 5 - values from a combo box]![cost per packet]nz([drugid].[Column](2))([patientName][Forms]![Combo 5 - values from a combo box]![patientid].[Column](1) & ' ' & [Forms]![Combo 5 - values from a combo box]![patientid].[Column](2)(T[date of birth][Forms]![Combo 5 - values from a combo box]![patientid].[Column](3)( M[gender][Forms]![Combo 5 - values from a combo box]![patientid].[Column](4)ss`DDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD1qL1 dL"mC+sN$ zgT*~R)doctors doctors  [doctorID]" g [family Name]% g   G  [family Name]% 'patients  [family Name]% g [patientID]# g  treatment   G   G r [Drug Name]# 'rDrugs  [Drug Name]# gDRugID gr r treatment   G   G  [Drug Name]# 'Drugs  [Drug Name]# g[DrugID] g  CoTreatment   GCo Co  G Co [Drug Name]# 'CoDrugs [cost per packet]) g [Drug Name]# gDRugID gCo Co  Co patientid! 'Copatients gender g[date of birth]' g [family name]% g [given name]$ g patientid! gCo Co Treatment   G  drugs  [drug name]# gdrugid g>qJ2zU+mZG+oB/ hU @ @ @ @`4`5`6`/`B`E`D`F`C`G`L`K`I`J`H`M`Q`O`P`N`Rhhh`Shhhh   Diag Di  G  [Drug name]# gall_info Treatment_PatientID'@+ o [Drug name]# g   G date_happening& ' Patients.PatientID* 'X7YZ_____2@" 7  GX7YZ_____1i@1" 7  Treatment   G  doctors  [family name]% gdoctorid g  drugs  [drug name]# gdrugid g  treatment   G   G  [DRug Name]# 'drugs [drugID] g [drug Name]# g   G  [family Name]% 'VCN kk     2 PatientIDDoctorID Date seen diagnosisk kkDoctorsDiagnosisPatientsDiagnosis PrimaryKey$@@*HZ@0@`@ 0@,@|@0~@(L0$f((L(8 r> LLLLLLLLLLLLLLLLLLLLLLL << <<<<< <$<(<,<0<4<8<<<@rrrrrrrrrr r r r r rrrrrrrrrrrrrrrrrrr ssssssss     ' (        *+,- ! ! ! 7 )7 7 7 7 ; ; ; ; ; > > > > > @ @ @ @ @    !   XH,XpXpXp !"#  $%&$ꀶW@T$$ꀺWjRj1  &PF@G@@DG10bad leg0))))%  @ @@ @?DG10sickness1))))%  @-@/@?DG9asthma.((((% -@.@@DG1nothing wrong5((((% @1@?DG4pregnant0((((%  +@@-@@DG12broken arm3))))% `+@@,@ @DG6headache0((((% +@+@?DG4headache0((((%(LVAL nKKD'ValidationRuleValidationText OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat DefaultValueRequired DecimalPlacesDisplayControl RowSourceType RowSource BoundColumn ColumnCount ColumnHeads ColumnWidthsListRows ListWidth LimitToListAllowZeroLengthw. &[Date end course]>=[Date start course]4 ,Date end course must be >= Date start course zDate start course '   Default = today d/m/yy now$()  Date end course   e ]Must be greater than or equal to Date start course (validated when rcord is saved or updated) d/m/yy   Dosage   G ?Number of tablets per dose, default = 1, must be greater than 0    1    >0> 6Dosage must be > 0; does not have to be a whole number  m  Frequency   V NDefault = 1 (= daily; 3 = every third day), must be greater than or equal to 1    1    >=1P HFrequency of treatment; must be >= 1 (where 1=daily, 3=every 3 days etc)  m Doses per day   ` XDefault = 1 (= once each day that tablets are taken), must be greater than or equal to 1    1    >=1E =Number of doses on days when treatment is given; must be >= 1  mP PatientID    Links to Patients table      o Table/Queryu mSELECT DISTINCTROW [Patients].[PatientID], [Patients].[Given name], [Patients].[Family name] FROM [Patients];     900;1440;1440  3780twip  DrugID    Links to Drugs table     o Table/QueryN FSELECT DISTINCTROW [Drugs].[DrugID], [Drugs].[Drug name] FROM [DrugsKLVALWNkkx^ ,(@P4<8DLHH8LXH 8Lv@$@@*HZ@0@`@ 0@,@|@0~@(L0$f((L(8 r> LLLLLLLLLLLLLLLLLLLLLLL << <<<<< <$<(<,<0<4<8<<<@=[Date start course]4 ,Date end course must be >= Date start course zDate start course '   Default = today d/m/yy now$()  Date end course   e ]Must be greater than or equal to Date start course (validated when rcord is saved or updated) d/m/yy   Dosage   G ?Number of tablets per dose, default = 1, must be greater than 0    1    >0> 6Dosage must be > 0; does not have to be a whole number  m  Frequency   V NDefault = 1 (= daily; 3 = every third day), must be greater than or equal to 1    1    >=1P HFrequency of treatment; must be >= 1 (where 1=daily, 3=every 3 days etc)  mP PatientID    Links to Patients table      o Table/Queryu mSELECT DISTINCTROW [Patients].[PatientID], [Patients].[Given name], [Patients].[Family name] FROM [Patients];     900;1440;1440  3780twip  DrugID    Links to Drugs table     o Table/QueryN FSELECT DISTINCTROW [Drugs].[DrugID], [Drugs].[Drug name] FROM [Drugs];    912;1440  2352twip QDoctorID f   Links to Doctor table    0    o Table/Queryp hSELECT DISTINCTROW [Doctors].[DoctorID], s(~dU n_EPA'2# xiKKDValidationRuleValidationText ColumnWidth ColumnOrder ColumnHidden DescriptionFormat Yb;   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Yb;   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Yb;   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Yb;   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Yb;   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    Yb;  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o   Vx ?=  Yb;  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o  X Yb; X Xۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o B?ǍǍǍǍǍǍǍǍǍǍǍǍǍǍǍǍǍǍǍǍǍǍǍǍǍǍǍǍǍǍ~ o`QB3$jufL @ @ @ @   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Yb;   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Yb;   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Yb;   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Yb;   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Yb;   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Yb;   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o d!~do`FQB(3$ yj[L&&&&&&&&&vvvvvvŜĜĥV1xNullBehavior AccessVersionBuildShow Values LimitS Yb;   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Yb;   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Yb;   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Yb;   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Yb;   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Yb;   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Yb;   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o ~ o`\M3$yufWH[L d@2@~sq_cTechnique 2 module basic version- Find Record~sq_cDoctorID``````````^ 9@w@~sq_cTechnique 2 module basic version- Find Record~sq_cDrugIDU*@@[vvvj^^^^^^\ `@%l@~sq_fTechnique 2 - Find Record8 :*@?[WWWK??????= `t5@s@~sq_cTechnique 2 - Find Record~sq_cdrugID3*@>[bbbVJJJJJJH ` {@.@~sq_cTechniqu ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Yb;   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o   Yb;  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o  j Yb; j jۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o j  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Yb;   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ZLVALfȠzG[Doctors].[Given name], [Doctors].[Family name] FROM [Doctors];     876;1440;1440  3756twip vLVAL|KKD'ValidationRuleValidationText OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat DefaultValueRequired DecimalPlacesDisplayControl RowSourceType RowSource BoundColumn ColumnCount ColumnHeads ColumnWidthsListRows ListWidth LimitToListAllowZeroLengthw. &[Date end course]>=[Date start course]4 ,Date end course must be >= Date start course zDate start course '   Default = today d/m/yy now$()  Date end course   e ]Must be greater than or equal to Date start course (validated when rcord is saved or updated) d/m/yy   Dosage   G ?Number of tablets per dose, default = 1, must be greater than 0    1    >0> 6Dosage must be > 0; does not have to be a whole number  mP PatientID    Links to Patients table      o Table/Queryu mSELECT DISTINCTROW [Patients].[PatientID], [Patients].[Given name], [Patients].[Family name] FROM [Patients];     900;1440;1440  3780twip  DrugID    Links to Drugs table     o Table/QueryN FSELECT DISTINCTROW [Drugs].[DrugID], [Drugs].[Drug name] FROM [Drugs];    912;1440  2352twip QDoctorID f   Links to Doctor table    0    o Table/Queryp hSELECT DISTINCTROW [Doctors].[DoctorID], [Doctors].[Given name], [Doctors].[Family name] FROM [Doctors];     876;1440;1440  3756twip  LVAL|N  KKD'ValidationRuleValidationText OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat DefaultValueRequired DecimalPlacesDisplayControl RowSourceType RowSource BoundColumn ColumnCount ColumnHeads ColumnWidthsListRows ListWidth LimitToListAllowZeroLengthw. &[Date end course]>=[Date start course]4 ,Date end course must be >= Date start course zDate start course '   Default = today d/m/yy now$()   Dosage   G ?Number of tablets per dose, default = 1, must be greater than 0    1    >0> 6Dosage must be > 0; does not have to be a whole number  mP PatientID    Links to Patients table      o Table/Queryu mSELECT DISTINCTROW [Patients].[PatientID], [Patients].[Given name], [Patients].[Family name] FROM [Patients];     900;1440;1440  3780twip  DrugID    Links to Drugs table     o Table/QueryN FSELECT DISTINCTROW [Drugs].[DrugID], [Drugs].[Drug name] FROM [Drugs];    912;1440  2352twip QDoctorID f   Links to Doctor table    0    o Table/Queryp hSELECT DISTINCTROW [Doctors].[DoctorID], [Doctors].[Given name], [Doctors].[Family name] FROM [Doctors];     876;1440;1440  3756twip  LVAL|     KKD'ValidationRuleValidationText OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat DefaultValueRequired DecimalPlacesDisplayControl RowSourceType RowSource BoundColumn ColumnCount ColumnHeads ColumnWidthsListRows ListWidth LimitToListAllowZeroLengthw. &[Date end course]>=[Date start course]4 ,Date end course must be >= Date start course zDate start course '   Default = today d/m/yy now$()   Dosage   G ?Number of tablets per dose, default = 1, must be greater than 0    1    >0> 6Dosage must be > 0; does not have to be a whole number  mP PatientID    Links to Patients table      o Table/Queryu mSELECT DISTINCTROW [Patients].[PatientID], [Patients].[Given name], [Patients].[Family name] FROM [Patients];     900;1440;1440  3780twip QDoctorID f   Links to Doctor table    0    o Table/Queryp hSELECT DISTINCTROW [Doctors].[DoctorID], [Doctors].[Given name], [Doctors].[Family name] FROM [Doctors];     876;1440;1440  3756twip 8y @ @ @ @ @ @ @`4`5`6`/`B`E`D`F`C`G`L`K`I`J`H`M`Q`O`P`N`Rhhh`Shhhhh<hCh>h?h@hAhB hDh=hEhLhJhGhHhI hKhFhMhOhPhNhQhWhUhShT hVhRhXhZh[hYh\hbh`h^h_ hah]hchehfhdhghmhkhihj hlhhhnihrhphq ihoiiiii iii i i i i iiiiiii +x @ @ @ @ @ @ @ @ @ hShT hVhRhXhZh[hYh\hbh`h^h_ hah]hchehfhdhghmhkhihj hlhhhnihrhphq ihoiiiii iii i i i i iiiiiiiiiiiiiii2i6i1i3 i4 i5ii7i=i;i9i: i<i8ioard 439b50ae9*DQ0?EnableControls 839b50ae9*D>@9BForm_People username registration 27353f366a*DO5%(Form_People software 336c8265e*Dx#Patients  ( drug namedrugsDrug name[drug name]?4+&&;   drugiddrugsDrugIDdrugid4.(##; LVAL|g]SI?5|?KKD'ValidationRuleValidationText OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat DefaultValueRequired DecimalPlacesDisplayControl RowSourceType RowSource BoundColumn ColumnCount ColumnHeads ColumnWidthsListRows ListWidth LimitToListAllowZeroLKKD'ValidationRuleValidationText OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat DefaultValueRequired DecimalPlacesDisplayControl RowSourceType RowSource BoundColumn ColumnCount ColumnHeads ColumnWidthsListRows ListWidth LimitToListAllowZeroLengthw. &[Date end course]>=[Date start course]4 ,Date end course must be >= Date start course r Date seen '   Default = today d/m/yy now$()   Dosage   G ?Number of tablets per dose, default = 1, must be greater than 0    1    >0> 6Dosage must be > 0; does not have to be a whole number  mP PatientID    Links to Patients table      o Table/Queryu mSELECT DISTINCTROW [Patients].[PatientID], [Patients].[Given name], [Patients].[Family name] FROM [Patients];     900;1440;1440  3780twip QDoctorID f   Links to Doctor table    0    o Table/Queryp hSELECT DISTINCTROW [Doctors].[DoctorID], [Doctors].[Given name], [Doctors].[Family name] FROM [Doctors];     876;1440;1440  3756twip  LVAL  KKD'ValidationRuleValidationText OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat DefaultValueRequired DecimalPlacesDisplayControl RowSourceType RowSource BoundColumn ColumnCount ColumnHeads ColumnWidthsListRows ListWidth LimitToListAllowZeroLengthw. &[Date end course]>=[Date start course]4 ,Date end course must be >= Date start course r Date seen '   Default = today d/m/yy now$()   diagnosis   G ?Number of tablets per dose, default = 1, must be greater than 0    1    >0> 6Dosage must be > 0; does not have to be a whole number  mP PatientID    Links to Patients table      o Table/Queryu mSELECT DISTINCTROW [Patients].[PatientID], [Patients].[Given name], [Patients].[Family name] FROM [Patients];     900;1440;1440  3780twip QDoctorID f   Links to Doctor table    0    o Table/Queryp hSELECT DISTINCTROW [Doctors].[DoctorID], [Doctors].[Given name], [Doctors].[Family name] FROM [Doctors];     876;1440;1440  3756twip LVAL }irth] O%O(T O(T1 Rdrugs O O O Oh O OO(T O(T  O(T !O(T 1O(T Patients OO OO OO !OO 1OO O OOO OO(T O(T O(T O(T 2O(T RO(T jO(T O(T treatment OO OO OO OO 2OO ROO jOO OOOOOO(OHO`OxO O@%OO @O@OOOO@OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OOOpOh,OO@OO pOO @OO @OO @OO @OO @OO @OO pO`O @O`O pOO pOO pOO pOO @OO |O  O+O( O OTOO0OO`OOOOOOO O O0OPO@O|O O!Ox+OO(!O OpT0OOPOOpO|OLVAL  O!O+OO O OTOOOOO@OOpOOOOO 0O`OOOO OPO OO O O @O pOOdDO O(O0O8O@OHOPOXO`OhOpOxOOO!Ox!OO0O`OOOO OPOOOOO@OpOO `OOOdrugs OPrimaryKeyPatientsO OPrimaryKey PatientID treatmentX O h Ox OReference2 Reference1 Reference O O `O!OO O O!OO` O PrimaryKey O  O8!Ox!O  `O H!O PrimaryKey!OOv 8'O('OOv (O'Ox)OOv )O)O+OO@%O@s%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@%OH+O Ox+O +O &OO&O(*OO"O(O treatment@O"OpO"O @O"O8'OOh'O'O'O'Odrugs PrimaryKeypO$#O @O$#O(O'O@(Op(OO$#O)O )O )O,)O PrimaryKey h'O<)O (O\)O8)O@)O(O PrimaryKeyPatients PrimaryKey@O0$O@O0$O LVALN|?@KKD'ValidationRuleValidationText OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat DefaultValueRequired DecimalPlacesDisplayControl RowSourceType KKDLValidationRuleValidationText OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat DefaultValueRequired DecimalPlacesDisplayControl RowSourceType RowSource BoundColumn ColumnCount ColumnHeads ColumnWidthsListRows ListWidth LimitToListAllowZeroLengthFilterOrderBy InputMaskCaption v Date seen '   Default = today  Short Date Date()  r diagnosis     comments about the visit      mP PatientID    Links to Patients table      o Table/Queryu mSELECT DISTINCTROW [Patients].[PatientID], [Patients].[Given name], [Patients].[Family name] FROM [Patients];     900;1440;1440  3780twip HDoctorID f   Links to Doctor table      o Table/Queryp hSELECT DISTINCTROW [Doctors].[DoctorID], [Doctors].[Given name], [Doctors].[Family name] FROM [Doctors];     876;1440;1440  3756twip  LVAL|N     KKD'ValidationRuleValidationText OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat DefaultValueRequired DecimalPlacesDisplayControl RowSourceType RowSource BoundColumn ColumnCount ColumnHeads ColumnWidthsListRows ListWidth LimitToListAllowZeroLengKKDLValidationRuleValidationText OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat DefaultValueRequired DecimalPlacesDisplayControl RowSourceType RowSource BoundColumn ColumnCount ColumnHeads ColumnWidthsListRows ListWidth LimitToListAllowZeroLengthFilterOrderBy InputMaskCaption v Date seen '   Default = today  Short Date Date()  P PatientID    Links to Patients table      o Table/Queryu mSELECT DISTINCTROW [Patients].[PatientID], [Patients].[Given name], [Patients].[Family name] FROM [Patients];     900;1440;1440  3780twip HDoctorID f   Links to Doctor table      o Table/Queryp hSELECT DISTINCTROW [Doctors].[DoctorID], [Doctors].[Given name], [Doctors].[Family name] FROM [Doctors];     876;1440;1440  3756twip Pj@ +l  @l FP&l+`l +l -@l -llKKD'ValidationRuleValidationText OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat DefaultValueRequired DecimalPlacesDisplayControl RowSourceType RowSource BoundColumn ColumnCount ColumnHeads ColumnWidthsListRows ListWidth LimitToListAllowZeroLengthw. &[Date end course]>=[Date start course]4 ,Date end course must be >= Date start course r Date seen '   Default = today d/m/yy now$()   diagnosis   G ?Number of tablets per dose, default = 1, must be greater than 0    1    >0> 6Dosage must be > 0; does not have to be a whole number  mPjaC1 @1 @Diagnosiss@666*******( @3z1 @3z1 @Reference3++++++++++) @@~sq_fTechnique 2 module basic version- Find RecordK ^*@B[kkk_SSSSSSQ `@2@~sq_cTechnique 2 module basic version- Find Record~sq_cDoctorID\*@A[xxxl``````^ ` LVAL        I` @ KKDLValidationRuleValidationText OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat DefaultValueRequired DecimalPlacesDisplayControl RowSourceType RowSource BoundColumn ColumnCount ColumnHeads ColumnWidthsListRows ListWidth LimitToListAllowZeroLengthFilterOrderBy InputMaskCaption v Date seen '   Default = today  Short Date Date()  P PatientID    Links to Patients table      o Table/Queryu mSELECT DISTINCTROW [Patients].[PatientID], [Patients].[Given name], [Patients].[Family name] FROM [Patients];     900;1440;1440  3780twip HDoctorID f   Links to Doctor table      o Table/Queryp hSELECT DISTINCTROW [Doctors].[DoctorID], [Doctors].[Given name], [Doctors].[Family name] FROM [Doctors];     876;1440;1440  3756twip r diagnosis     comments about the visit     m LVALNKKDLValidationRuleValidationText OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat DefaultValueRequired DecimalPlacesDisplayControl RowSourceType RowSource BoundColumn ColumnCount ColumnHeads ColumnWidthsListRows ListWidth LimitToListAllowZeroLengthFilterOrderBy InputMaskCaption v Date seen '   Default = today  Short Date Date()  P PatientID    Links to Patients table      o Table/Queryu mSELECT DISTINCTROW [Patients].[PatientID], [Patients].[Given name], [Patients].[Family name] FROM [Patients];     900;1440;1440  3780twip HDoctorID f   Links to Doctor table      o Table/Queryp hSELECT DISTINCTROW [Doctors].[DoctorID], [Doctors].[Given name], [Doctors].[Family name] FROM [Doctors];     876;1440;1440  3756twip r diagnosis     comments about the visit     mTLVALf           TKKDC ColumnWidth ColumnHiddenFormat RecordLocks ODBCTimeout  <KKD8 RecordLocks ODBCTimeout MaxRecords Replicable  <KKD, RecordLocks ODBCTimeout MaxRecords  <KKDW RecordLocks ODBCTimeout MaxRecords RecordsetTypeFilterOrderBy OrderByOn1  <  KKDc RecordLocks ODBCTimeout MaxRecords Recͬ%T4 `U(Detail0mPatientIDd Text0d Text1oDrugIDd Text2d Text3d Text4d Text5d Text15mGenderd Text17mDate_of_BirthDate of Birthd Text18m costm patientnamemdate_start_courseDate start coursemDrug_NameDrug nameͬ &*I`U(Detail0mPatientIDd Text0d Text1oDrugIDd Text2d Text4DoctorID Date end course Dosage Frequency Doses per daymdate_start_courseDate start courseͬsxG`U(Detail0d Text0d Text1oDrugIDd Text2d Text3d Text4d Text5d Text15mGenderd Text17mDate_of_BirthDate of Birthd Text18DoctorIDDate end courseDosageFrequencyDoses per daymdate_start_courseDate start coursemDrug_NameDrug namem cost_per_packetcost per packetoPatientIDm patientnameLVAL < 4Z s4M?4Z4Zx 4Z4Z  )4Za4Z4Z4Z4Z 4ZX4Z4Z4Z4Z84Z84Z84Z84Z84ZH4Zp4Z4Z4Z4Z      (      patients.patientidpatients PatientIDpatients.given name Given namepatients.family name Family namepatients.date of birth Date of Birthpatients.genderGender(4Z 4Z4Z4Z 4Z]@4Z 4Z )4ZR a4ZR 4ZR 4ZR 4ZR patients4ZH4Z4Z4Z4Z۱0@4~sq_cCombo 5 - values from a combo box~sq_cPatientID 4Z )4Z4Z 4Z4Z 4Z 4Z (4Z84Z 4Z@4Z)4Z [given name]4Z [family name]4Z[date of birth](4Z4Z4ZR 4ZR 4ZR 4ZR 4ZR PatientID Family name Given nameGender Date of Birthpatients )4Z 4Z 0 4Z( 4Z H 4Z@ 4Z 4ZX 4Z h 4Z` 4Z)4Z4Z Family name4Z Given name4Z(4Z Date of Birth 4Z4Z4Z 4Z@4ZX4Zp4Z4Z4Zx 4Z 4Zx 4Z 4Zx 4Z 4Zx 4Z 4Zx 4Z 4Zx 4Z 4Zx 4Z 4Zx 4Z 4Zx 4Z 4Zx 4Z 4Zx 4Z 4Zx 4Z 4Zx 4Z 4Zx 4Z 4Zx 4Z 4Zx 4Z 4Zx 4Z 4Zx 4Z 4Zx 4Z 4Zx 4Z 4Zx 4Z 4Zx 4Z 4Zx 4Z 4Zx 4Z 4Zx 4Z 4Zx 4Z 4Zx 4Z 4Zx 4Z 4Zx 4Z 4Zx 4Z4Z4Z 4ZP4Z@4Z4Z`p4Z4Z p4Z4Z @4Z4Z p4Z4Z |4Z 4Z4Z4ZR 4Z 4Z 4Z4Z4Z4ZH4Z4Zx4Z4Z 4ZLVAL0MSyy++++sFFFBB##############################~P+⢔]@]@~sq_cCombo 5 - values from a combo box~sq_cPatientIDUUUUUUUUUUS 0"T@o@split address.........., X1uS@TS@bad_design7@[777+++++++) @-NnS@lnS@split name++++++++++) P{~@u~@~sq_cCombo 2 - AutoLookup~sq_cDrugIDF*@]]]QEEEEEEC `z+m@!X@combo 5@ g4(((((((((& y\@ FA@Combo 5 - values from a combo box6@LWF000$l`NNBBBBBB@ xCA@U_5@Report2@5LWF000#4RF44((((((& wxV@xV@~sq_fPatients'B*@FFF:......, `vPc&@b->m@conditional macro@>2222222220 tҩܖ@ܖ@~sq_fSubform 2 - One-Many-OneS.*@VVVJ>>>>>>< `svVܖ@vV  4Z 4ZH4Z x4Z<4Z4Z4Z4Z4Z 4Z 4Z4ZH4Zx4Z4Zpatients4Z 4ZPrimaryKey PatientID4Z4Zv  4Z4Z4Z4Z4Zs4Z4Z4Z4Z4Z4Z4Z4Z4Z4Z4Z4Z4Z4Z4Z4Z4Z4Z4Z4Z4Z4Z4Z4Z4Z4Z4Z4Z4Z4Z x 4Z4Z4Z4Z4Zpatients PrimaryKey@4Z4Z@4Z4Z 4Z4ZP4Z4ZP4Z@4Z4Z4Z4Z4Z4Z4ZLVAL <[,s4M? [X[@[ [    [[[ [[[ [[[ [[([    (    Drugs.DRugIDDrugsDrugIDDrugs.Drug NameDrug nameDrugs.cost per packetCost per packetP[H[[[ 8[K]]@@[H[ [R [R [R Drugsh[[`[8[L@1~sq_cCombo 5 - values from a combo box~sq_cDrugIDH[ [[ [[ [[[ [Drug Name][[cost per packet][8[R @[R P[R DrugID Drug nameCost per packetDrugs [[ [[ 0[([[[ Drug name[Cost per packet [ [[ 8[@[P[`[p[[@[ [@[ [@[ [@[ [@[ [@[ [@[ [@[ [@[ [@[ [@[ [@[ [@[ [@[ [@[ [@[ [@[ [@[ [@[ [@[ [@[ [@[ [@[ [@[ [@[ [@[ [@[ [@[ [@[ [@[[[ [[v x [p [ 0 [ [s [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [h[ @[[8[p[  [Drugsp[ [ p[ [ @[ [x [ [[ [[  [ x [ [ @ @ @p[ [ p[ [ @[ [[([[8[[HLVAL @ @ @ @ @ @ @`4`5`6`/`B`E`D`F`C`G`L`K`I`J`H`M`Q`O`P`N`Rhhh`Shhhhhh h h h  h hhhhhh<hCh>h?h@hAhB hDh=hEhJhGhHhI hKhF[     [ [[LVAL <& d]b sM?d]d]P d]d]! d]d]d]d]d]"d]:d]Rd]d]d]d]d]d]d]0d]Hd]d]d]d]d]d]d]d]d]d]d]d]d]d]"d]:d]Rd]                Treatment.PatientID TreatmentTreatment.DrugIDTreatment.DoctorIDTreatment.Date start courseTreatment.Date end courseTreatment.DosageTreatment.FrequencyTreatment.Doses per dayd]d] (d]d] `d]ٕ]@d]d][8[d]R[HԂ:d]R   d]R d]R[d]R "d]R :d]R Rd]R Treatmentd]@d]d]d]`d]".G@&~sq_fCombo 5 - values from a combo boxd] d]d] d]d] d]d] d]d] d] d] d](d] 0d]0d] Hd]8d]d]d]d]d]d]d]0d]Hd] d]R{Բd]R [Dd]Rd]R pd]R ["d]R:d]Rx Rd]R[Treatment d] d] d] d] d] d] d]( d] d]0 d] "d]8 d] :d]@ d] Rd]H d]d]d]d]d]d]d]0d]Hd] d]d]d] `d]@d]`d]d]d]d]P d] d]P d] d]P d] d]P d] d]P d] d]P d] d]P d] d]P d] d]P d] d]P d] d]P d] d]P d] d]P d] d]P d] d]P d] d]P d] d]P d] d]P d] d]P d] d]P d] d]P d] d]P d] d]P d] d]P d] d]P d] d]P d] d]P d] d]P d] d]P d] d]P d]d]`d]d]d]@d]d] pd]d] @d]d] @d]d] @d]d] @d]d] @d]d] ~LVALs`D1xeR?###########################################~P+sC+ I @ & !:@.!m8@d]d] |d] d]xd]d] Rd] d] d] d] d]0d] d]@d]Pd]Pd]d]`d]d]pd]d]d] d]  d] d] d]Pd]d]d]d]H Pd]Xd]`d]hd]pd]xd]d]d] d] d] d] d]Pd]d]d]d]d] Treatmentd] d]d]Reference2 Reference1 Referenced]d]v d]d]d]d]d]sd]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]hd] P d]xd]Xd]d]d]Treatment Reference2@d]d]d]d]d]@d]d]xd]Hd]xd]d]d]LVAL& N 0cghij2kL -L@ Treatmentcombo 5Helv8 hApple LaserWriter II NTX TD[ od,Xe`!)@Apple LaserWriter II NTXpscriptLPT1: dbcd ee3f1k3l3m5b@ i nj o3bl pe`f`hDetail0 m7U`a(b# eo kdate start courseDate start course Long Datedate_start_coursed5U` a(bTcText1 Start course:o5U9`cde] hn/"";"";"";"";"";"#,##0.00;-#,##0.00";"10";"40"DrugIDDrugID Table/QueryWSELECT DISTINCT DRugID, [Drug Name], [cost per packet] FROM Drugs ORDER BY [Drug Name];0;1440combo 5"SELECT DISTINCT DRugID, [Drug Name], [cost per packet] FROM Drugs ORDER BY [Drug Name];";"Drugs";"";"DRugID";"Drug Name";"PrimaryKey"d5U` abcText2Drug:m7U`apek Drug Namecombo 5 Drug_Named5U` apbEcText3 Drug Name:m7U`a ekcost per packetcost_per_packetd5U` a b*cText4Cost:d5U`a@ bcText5NOTE: Form is based on the Drugs(autolookup form) query, which uses AutoLookup. When you select a treatment, the patients details, Drug Name and cost fields are automatically looked up and filled in.m7U`aXbk patientnamed5UaXbc Text15name:m7U`abfekGender m or f onlyd5UabcText17Gender:m7U`axe)k Date of Birthd/m/yy.Must be less than or equal to the current date Date_of_Birthd5U` axbcText18Date of Birth:o5U9`bcdxeh+"";"";"";"";"";"";"";"d/m/yy";"";"";"4";"4" PatientID PatientID Table/Querycselect patientid,[given name],[family name],[date of birth],gender from patients order by patientid288;1080;1080;720;720combo 5d5U` axbcText0 Patient ID:LVAL <_s4M? __8_ _   ________    (  Drugs.DrugIDDrugsDrugs.Drug NameDrug name____ _lȡb@__ _R _R Drugsx_@_p_ __L@,~sq_cCombo 1 - Storing an ID~sq_cDRugID_ _ _ (_8_[DrugID]_ [Drug Name](__R `_R Drug nameDrugs __ (_ __(_ Drug name _0 _ _ _@_H_P_X_`_8_ _8_ _8_ _8_ _8_ _8_ _8_ _8_ _8_ _8_ _8_ _8_ _8_ _8_ _8_ _8_ _8_ _8_ _8_ _8_ _8_ _8_ _8_ _8_ _8_ _8_ _8_ _8_ _8_ _8____( _ p_ _ p_ _ |_ p _x_x _pR_x _ _ _ x _  _0X _` _x _ _ _Drugs  _PrimaryKey __v __ 0 _0 _0s _0 _0 _0 _0 _0 _0 _0 _0 _0 _0 _0 _0 _0 _0 _0 _0 _0 _0 _0 _0 _0 _0 _0 _0 _0 _0 _0 _0 _(_ 8_H___ _Drugsp_ _ @_ __ ___ __ @ p_0 _ @_0 _H__x_LVAL55ǰ**ĶĶĶGDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD1qL1 dL"mC+`4`5`6`/`B`E`D`F`C`G`L`K`I`J`H`M`Q`O`P`N`Rhhh`Shhhhhh h h h  h hhhhhh9h9h9pppIb@lȡb@~sq_cCombo 1 - Storing an ID~sq_cDRugIDHHHHHHHHHHF ٕ]@ٕ]@~sq_fCombo 5 - values from a combo boxb *@5[___SGGGGGGE `顝@'@~sq_fTechnique 2 macro version- Find record\ =*@'[dddXLLLLLLJ `E@m@~sq_cTechnique 2 macro version- Find record~sq_cDrugID<*@%[ooocWWWWWWU `@6@~sq_cTechnique 2 macro version- Find record~sq_cDoctorID*@#[qqqeYYYYYYW `q|@q|@~sq_cTechnique 2 macro version- Find record~sq_cselectpatient*@![vvvj^^^^^^\ `=X@P@~sq_cTechnique 2 macro version- Find record~sq_cno_treatmentg*@[uuui]]]]]][ `)n@)n@test split address= h@[@WKK?3333331 `~}nS@iS@test split name?_  x__ _LVAL < `6 sM?``H ``! `````"`:`R```````0`H``````````````"`:`R`                treatment.PatientID treatmenttreatment.DrugIDtreatment.DoctorIDtreatment.Date start coursetreatment.Date end coursetreatment.Dosagetreatment.Frequencytreatment.Doses per day`` (`` ``b@`` `R `R `R `R `R "`R :`R R`R treatment`8`````".G@~sq_fCombo 1 - Storing an ID` `` `` `` `` `` ` ` 0`(` H`0```````0`H``R `R `R `R `R "`R :`R R`R treatment ` ` ` ` ` ` ` ` `( ` "`0 ` :`8 ` R`@ ```````0`H` ``` ``@``````H ` `H ` `H ` `H ` `H ` `H ` `H ` `H ` `H ` `H ` `H ` `H ` `H ` `H ` `H ` `H ` `H ` `H ` `H ` `H ` `H ` `H ` `H ` `H ` `H ` `H ` `H ` `H ` `H ` `H ``````@`` p`` @`` @`` @`` @`` @`` @`` |`LVAL i_VBA_MODULE: xE (6 <8 $*\Rffff*9e38c8d6eb*\R0*#11*\R0*#c@X0$$`<N.$`h$ $8.8P.hl  8P L .8  J   8 J ( @ @ 8     `H taI I 8  AO>( @ (0XXME B 0( 0 H   6LVAL X;h*Z$ hX(  "@xpX 'hZ   } $''" < '<  $'@fh   $} $' < }'< $8''<   $} $'   $} $'\M   $} $'"t   $} $'$(13)  $}   $} $'got more than 4 linesA@J0Z 8Z@ < <+8 +8aE  $} _   $} $ <+8Pgot more than 3 linesA@J+8  <+8sAttribute VB_Name = "split address" Option Compare Database`Ex`cit FuncZget_A(full, line) Dim t As Sng'_&(1 To (10) $iIn tegeruor i/ Fi)Nexv=  %If InH(, Chr(13) 0 Then- .1 %Else: Do While'> 0$ TLeft>Dh- 1 dMid+ 2r i + 1=Loop End pIf ]LA Ci > 3?MsgBox ("got moathan Ams"`  D E __SRP_2rU~} de!ed Af`NcJ( kNP; NdJ 81hpN6lhF8 ( ((]15(\8#P;/6lhF8 ( ((]r5(\Z ( lhF8(("hM@  `#kNP;/6(V ( 'lhF8(("hM@ `1h6( kNpN lhkNP; kN+''':8N(( 6(8"PFlLVALl l l n !n "n #n $n %o0o0o0o0o0p0p0p0p0p0 q0 q0 q0 q0 q0r0r0r0r0r0s0s0s0s0s0t0t0t0t0t0vHvHvHvHvHw0+w0,w0-w0.wH xH xH xH xHyHyHyHyHzHzHzHzHzH{ &{ '{ ({ ){H~H#~H$~H%~H&H'H(H)H*H+ppppppp p p ppp `p``R` ` `` `(``8`H`H`x`X``h``x` `  ` ``H`x```H H`P`X```h`p`x`` ` ` ``H`x```` treatment` ``Reference2 Reference1 Reference``v `````s``````````````````````````````` H `p`P```treatment Reference2@`````@``p`@`p```LVAL <`,a1s`,M?!aX,aa"a! <<aaaa2aRajaaaaaa a!a1a<aaaa(aHa`axaaaaaaa(a<aaaaaaaaaaaaaaa<aaaa2aRajaaaaaa a!a1a                  (     (            treatment.PatientID treatmenttreatment.DrugIDtreatment.DoctorIDtreatment.Date start coursetreatment.Date end coursetreatment.Dosagetreatment.Frequency-treatment.Doses per daydrugs.Drug namedrugsdrugs.Cost per packetPatients.Family namePatientsPatients.Given namePatients.Initials&Patients.GenderPatients.Date of Birth a aa a@aFI\@(a0a aa aa aR aR aR aR 2aR RaR jaR aR aR aR aR aR  aR !aR 1aR drugsH a a@ a`a@aL@PatientsXa aHaa@a۱0@ treatment@aa0aa@a".G@$Drugs (AutoLookup form)0aaa a( a a0 a a8 a a@ a (aH a HaP a `aX a xa` a h a a a a a a a a a a a a a aaaaa(aHa`axadrugs.[Drug name]h adrugs.[Cost per packet] aPatients.[Family name] aPatients.[Given name] aaaPatients.[Date of BLVAL irth] aaR aR drugs a a a ah a aaR aR  aR !aR 1aR Patients aa aa aa !aa 1aa a aaa aaR aR aR aR 2aR RaR jaR aR treatment aa aa aa aa 2aa Raa jaa aaaaaa(aHa`axa a@%aa @a@aaaa@aa aa aa aa aa aa aa aa aa aa aa aa aa aa aa aa aa aa aa aa aa aa aa aa aa aa aa aa aa aaapah,aa@aa paa @aa @aa @aa @aa @aa @aa pa`a @a`a paa paa paa paa @aa |a  a+a( a aRaa0aa`aaaaaaa a a0aPa@a|a a!ax+aa(!a aPR0aaPaapa|aLVAL  a!a+aa a aRaaaaa@aapaaaaa 0a`aaaa aPa aa a a @a paadDa a(a0a8a@aHaPaXa`ahapaxaaa!ax!aa0a`aaaa aPaaaaa@apaa `aaadrugs aPrimaryKeyPatientsa aPrimaryKey PatientID treatmentX a h ax aReference2 Reference1 Reference a a `a!aa a a!aa` a PrimaryKey a  a8!ax!a  `a H!a PrimaryKey!aav 8'a('aav (a'ax)aav )a)a+aa@%a@s%a@%a@%a@%a@%a@%a@%a@%a@%a@%a@%a@%a@%a@%a@%a@%a@%a@%a@%a@%a@%a@%a@%a@%a@%a@%a@%a@%a@%aH+a ax+a +a &aa&a(*aa"a(a treatment@a"apa"a @a"a8'aah'a'a'a'adrugs PrimaryKeypa$#a @a$#a(a'a@(ap(aa$#a)a )a )a,)a PrimaryKey h'a<)a (a\)a8)a@)a(a PrimaryKeyPatients PrimaryKey@a0$a@a0$a)ahLVAL        )a)a*aa0$a*a *a*a*a PrimaryKey8'a*a (*a*a*a*a*a PrimaryKey@(a)a'a@a@%a@a@%a@a@%ax+a+a+a,a+a,ax+a(,a+a8,a+aH,a a`aaLVAL <csM? cc8c c   cccccccc    (  Drugs.DRugIDDrugsDrugIDDrugs.Drug NameDrug namecccc cZ1k@cc cR cR Drugsxc8cpc ccL@$~sq_cCombo 2 - AutoLookup~sq_cDrugIDc cc c0cc [Drug Name] cXcR `cR DrugID Drug nameDrugs cc (c cc c Drug name c0 c c c@cHcPcXc`c8c c8c c8c c8c c8c c8c c8c c8c c8c c8c c8c c8c c8c c8c c8c c8c c8c c8c c8c c8c c8c c8c c8c c8c c8c c8c c8c c8c c8c c8cccc( c pc c pc c |c p cxcx cpRcx c c c x c  c0X c` cx c c cDrugs  cPrimaryKey ccv cc 0 c0 c0s c0 c0 c0 c0 c0 c0 c0 c0 c0 c0 c0 c0 c0 c0 c0 c0 c0 c0 c0 c0 c0 c0 c0 c0 c0 c0 c0 c0 c(c 8cHccc cDrugspc c @c cc ccc cc @ pc0 c @c0 cHccxLVAL0MSyy++++s³³¯Bt-rDDDDDDDDDDDDDDDDDDDDDDDDDDDD1qL1 dL]1k@Z1k@~sq_cCombo 2 - AutoLookup~sq_cDrugIDEEEEEEEEEEC K]]@K]]@~sq_cCombo 5 - values from a combo box~sq_cDrugID,*@3[jjj^RRRRRRP `⢔]@]@~sq_cCombo 5 - values from a combo box~sq_cPatientID *@1[mmmaUUUUUUS `0"T@o@split address.........., X1uS@TS@bad_design7@[777+++++++) @-NnS@lnS@split name++++++++++) Pz+m@!X@combo 5@ g4(((((((((& y\@B]@Combo 5 - values from a combo box@LWF000l`NNBBBBBB@ xCA@U_5@Report2@5LWF000#4RF44((((((& wxV@xV@~sq_fPatients'B*@FFF:......, `vPc&@b->m@conditional macro@>2222222220 tҩܖ@ܖ@~sq_fSubform 2 - One-Many-OneS.*@VVVJ>>>>>>< `svVܖ@vVܖ@~sq_cSubform 2 - One-Many-One~sq_cdrug form ,*@dddXLLLLLLJ `rťܖ@'Aܖ@~sq_cSubform 2 - One-Many-One~sq_cSecond Subform(*@iii]QQQQQQO `ql&u@du@~sq_cCombo 4- Link drugs to treatment Subform~sq_cDRugIDC$*@qqqeYYYYYYW `plu@&u@~sq_cCombo 4- Link drugs to treatment Subform~sq_cEmbedded1r"*@ttth\\\\\\Z `ou@%u@~sq_fCombo 3 - DLookupU *@OOOC7777775 `n5-u@Xku@~sq_cCombo 3 - DLookup~sq_cdoctorIDA*@\\\PDDDDDDB `lԩݲu@&޲u@~sq_fPatients test ccc  xcc cLVALN  Bt-r~ o`QB3$jufLqL1 dL]0cghixj|k,/@Drugs (AutoLookup form)Helv8 hApple LaserWriter II NTX TD[ od,Xe`!)@Apple LaserWriter II NTXpscriptLPT1: dbcd ee3f1k3l3m5b@ i nj o3bl pe`f`hDetail0 m7U;`axbe PatientID PatientID-Number automatically assigned to new product.d5U` axbcText0 Patient ID:m7U`a(b# eo kDate start courseDate start course Long DateDate_start_coursed5U` a(bTcText1 Start course:o5U9`cde] hn"";"";"";"";"10";"40"DrugIDDrugID Table/QueryGSELECT DISTINCTROW DRugID, [Drug Name] FROM Drugs ORDER BY [Drug Name];0'Same as Supplier ID in Suppliers table.v"SELECT DISTINCTROW DRugID, [Drug Name] FROM Drugs ORDER BY [Drug Name];";"Drugs";"";"DRugID";"Drug Name";"PrimaryKey"d5U` abcText2Drug:m7U`apek drug Name Drug name drug_Named5U` apbEcText3 Drug Name:m7U`a ekcostCost per packetd5U` a b*cText4Cost:d5U`a@ bcText5NOTE: Form is based on the Drugs(autolookup form) query, which uses AutoLookup. When you select a treatment, the patients details, Drug Name and cost fields are automatically looked up and filled in.m7U`aXk patientname#=[Given name] & ' ' & [family name]d5U`aXbcText15name:m7U`abfekGenderGender m or f onlyd5UabcText17Gender:m7U`axe)k Date of Birth Date of Birthd/m/yy.Must be less than or equal to the current date Date_of_Birthd5U` axbcText18Date of Birth:x|.['s:v>  @ @ @ @ @ @K ORAC_PEOPLE.PERSON_CODE = ORAC_TELEPHONE.PERSON_CODEORAC_PEOPLE.PERSON_CODE = ORAC_POSTGRADUATES.PERSON_CODEORAC_PG_DEPT_CODES.ORGANISATION_CODE = ORAC_POSTGRADUATES.ORGANISATION_CODE((ORAC_PEOPLE.PERSON_TYPE="u") AND (ORAC_PEOPLE.SURNAME Like [give first few letters of surname (case sensitive)] & "*"))ORAC_PEOPLE.PERSON_CODE = ORAC_UNDERGRADUATES.PERSON_CODEORAC_COURSE_CODES.COURSE_CODE = ORAC_UNDERGRADUATES.COURSE_CODEORAC_UNDERGRADUATES.ENTRY_SESSIONORAC_COURSE_CODES.COURSE_DESCRIPTIONORAC_PEOPLE.PERSON_CODE = ORAC_STAFF.PERSON_CODEORAC_PEOPLE.PERSON_CODE = ORAC_TELEPHONE.PERSON_CODEORAC_PEOPLE.PERSON_CODE = ORAC_POSTGRADUATES.PERSON_CODEORAC_PG_DEPT_CODES.ORGANISATION_CODE = ORAC_POSTGRADUATES.ORGANISATION_CODESELECT DISTINCT DEPTS.FULL_NAME,LOCAL.KNOWN_NAME, PEOPLE.SURNAME,TELEPHONE.INTERNAL_TEL,TELEPHONE.EXTERNAL_TEL, TELEPHONE.ROOM_NO,PP_DATA.EMAIL_NAME,PP_DATA.DELIVERY_ADDRESS FROM DEPTS,PEOPLE,STAFF,TELEPHONE,LOCAL,PP_DATA,ROLES WHERE ROLES.JOB='net-reps' and PEOPLE.PERSON_CODE=LOCAL.PERSON_CODE and PEOPLE.PERSON_CODE=TELEPHONE.PERF=" @L" @~sq_cdrug pie chart~sq_cEmbedded0*@$ZZZNBBBBBB@ `23 @23 @DoctorsDiagnosis1111111111/ ~H23 @~H23 @PatientsDiagnosis22222222220 -3 @(5 @treatments and diagnosis@!@QEE99999997 @jaC1 @623 @Diagnosis@666*******( @3z1 @3z1 @Reference3++++++++++) @@~sq_fTechnique 2 module basic version- Find RecordK ^*@B[kkk_SSSSSSQ `@2@~sq_cTechnique 2 module basic version- Find Record~sq_cDoctorID\*@A[xxxl``````^ `LVALKKDLValidationRuleValidationText OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat DefaultValueRequired DecimalPlacesDisplayControl RowSourceType RowSource BoundColumn ColumnCount ColumnHeads ColumnWidthsListRows ListWidth LimitToListAllowZeroLengthFilterOrderBy InputMaskCaption v Date seen '   Default = today  Short Date Date()  P PatientID    Links to Patients table      o Table/Queryu mSELECT DISTINCTROW [Patients].[PatientID], [Patients].[Given name], [Patients].[Family name] FROM [Patients];     900;1440;1440  3780twip HDoctorID f   Links to Doctor table      o Table/Queryp hSELECT DISTINCTROW [Doctors].[DoctorID], [Doctors].[Given name], [Doctors].[Family name] FROM [Doctors];     876;1440;1440  3756twip r diagnosis H    comments about the visit     mj @llllll ll Sۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o   Yb;  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o  j Yb; j jۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o j  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Yb;   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o j @llll l l l l  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o   Yb;  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o  j Yb; j jۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o j  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Yb;   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKۼ.gSk~]ԉ$wV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o LVALhShT hVhRhXhZh[hYh\hbh`h^h_ hah]hchehfhdhghmhk |PDiagnosisPDoctors(PatientsaDrugsDrugs(PatientsPatients?XTreatmentTreatment$DoctorsDoctorsIDoctors_1Doctors:bDiagnosisDiagnosis LVAL|zU+mZG+X7YZ_____1W@1" 7  Treatment   G  doctors 23 @23 @DoctorsDiagnosis1111111111/ ~H23 @~H23 @PatientsDiagnosis22222222220 -3 @o R3 @treatmeSELECT Patients.PatientID, [Patients].[Given name] & " " & [Patients].[Family name] AS patient, [Doctors].[Title] & " " & [Doctors].[Family name] AS doctor, Treatment.[Date start course],Drugs.[Drug name] FROM Doctors INNER JOIN (Drugs INNER JOIN (Patients INNER JOIN Treatment ON Patients.PatientID = Treatment.PatientID) ON Drugs.DrugID = Treatment.DrugID) ON (Doctors.DoctorID = Treatment.DoctorID) AND (Doctors.DoctorID = Treatment.DoctorID)LVAL/|zU+mZG+@ @ @hShT hVhRhXhZh[hYh\hbh`h^h_ hah]hchehfhdhghmhkhihj hlhhhnihrhphq ihoiiiii iii i i i i iiiiiiiiiiiiiX7YZ_____1i@1" 7  Treatment   G  doctors 23 @23 @DoctorsDiagnosis1111111111/ ~H23 @~H23 @PatientsDiagnosiSUM([all_info].[Treatment].[PatientID])SELECT Patients.PatientID, [Patients].[Given name] & " " & [Patients].[Family name] AS patient, [Doctors].[Title] & " " & [Doctors].[Family name] AS doctor, Treatment.[Date start course] as date_happening,Drugs.[Drug name] FROM Doctors INNER JOIN (Drugs INNER JOIN (Patients INNER JOIN Treatment ON Patients.PatientID = Treatment.PatientID) ON Drugs.DrugID = Treatment.DrugID) ON (Doctors.DoctorID = Treatment.DoctorID) AND (Doctors.DoctorID = Treatment.DoctorID)LVAL |<`,O5s`,(M?!OX,OO"O! <<OOOO2OROjOOOOOO O!O1O<OOOO(OHO`OxOOOOOOO(O<OOOOOOOOOOOOOOO<OOOO2OROjOOOOOO O!O1O                  (     (            treatment.PatientID treatmenttreatment.DrugIDtreatment.DoctorIDtreatment.Date start coursetreatment.Date end coursetreatment.Dosagetreatment.Frequency-treatment.Doses per daydrugs.Drug namedrugsdrugs.Cost per packetPatients.Family namePatientsPatients.Given namePatients.Initials&Patients.GenderPatients.Date of Birth O OO O@OFI\@(O0O OO OO O(T O(T O(T O(T 2O(T RO(T jO(T O(T O(T O(T O(T O(T  O(T !O(T 1O(T drugsH O O@ O`O@OL@PatientsXO OHOO@OĔH23 @ treatment@OO0OO@O/z1 @$Drugs (AutoLookup form)0OOO O( O O0 O O8 O O@ O (OH O HOP O `OX O xO` O h O O O O O O O O O O O O O OOOOO(OHO`OxOdrugs.[Drug name]h Odrugs.[Cost per packet] OPatients.[Family name] OPatients.[Given name] OOOPatients.[Date of BLVAL)Oh)O)O*OO0$O*O *O*O*O PrimaryKey8'O*O (*O*O*O*O*O PrimaryKey@(O)O'O@O@%O@O@%O@O@%Ox+O+O+O,O+O,Ox+O(,O+O8,O+OH,O O`OOLVAL <{&Os&(M?O%OOhO  <OOOOOO (  all_info.Drugs.Drug nameDrugsTreatment_PatientID`OXOO0O OL" @OO OO OO OO XOhO O(T O(T all_info@ O  0 O O OO࣭F@ Doctors`OXOXOO623 @DrugshOPO`OOL@Patients OOOOĔH23 @ Treatment`OPOPOO/z1 @!~sq_cdrug pie chart~sq_cEmbedded0O OO OO [Drug name]OOOO OO OO OhO OT OT  OT  OT  OT   OT  O(T  OT DoctorsDrugsPatients TreatmentDoctorID Family name Given nameInitialsTitleDrugID PatientIDall_infoOOOhO HO@OODrugs.Drug nameDoctorsO(TDrugs NOOOPatients Treatment OT&O&O$O@OHOPOXO`OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OO OOOOOOv OOOv  O O!OOv)LVAL5 "O!Op#OOv #O#O$Oi0OO@ OO%OOXO%OzO $O%OO 8"O OOOh%O$O O@O#OOO"OOhO O Treatment@OhOpOhO @OhOO Op O@ O ODoctorsPrimaryKey@OtO O OOtOp!O !O!O!O PrimaryKey@ O!O  O!O!O!O O PrimaryKeyDrugs PrimaryKeypOO pOO "O!O8"Oh"OOO#O #O#O$#O PrimaryKey  O4#O "OT#O0#O8#Ox"O PrimaryKeyPatients PrimaryKey@OO#O`#OOOX$O h$Op$O|$O PrimaryKeyO$O #O$O$O$O#O PrimaryKey @ @OXO @OXO@OXO%O$O8%O%Oh%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%OO}OT&OT&OT&OT&OT&OT&OT&OT&OT&OT&OT&OT&OT&OT&OT&OT&OT&OT&OT&OT&OT&OT&OT&OT&OT&OT&OT&OT&OT&OT&OO %Oh%OLVAL ʾxxxxxTreatmentExample 09 query using aggregate query functionsdrug pie chartCombo 1 - Storing an ID2,9w"F2Combo 2 - Adding <