Standard Jet DB nb` Ugr@? ~1y0̝cǟFN7]D^(`T{6߱wCϯ34ay[|*|OJl>`&_Љ$g 'DeFx - { N @ @ @ 1vt,bfosmr}ff1vt,b`vvrbj`wjrpv wA 1vt,bfosmr}ff1vt,brbbxuufpbf,w}sfvxagruo w@ 1vt,brbbxuufpbf,w}sfvxagruo1vt,bjd,wrsjb w> 1vt,brbbxuufpbf,w}sfvxagruo1vt,brbbxuufpbfw}sf w= 1vt,bwrsjb,w}sf1vt,bwrsjbvxagruo wB 1vt,g`vvrbj`wjrp <3 1vt,g`vvrbj`wjrpvxagruo w 1vt,g`vvrbj`wjrp,w}sf w 1vt,g`vvrbj`wjrpv 2222220 ` G LVJ (_@(_@ ~sq_fassociations5 * @& JJJ>2222220 `J (_@(_@ ~sq_fassociations5 * @& JJJ>2222220 ` ' ,Ss\@?rc@ AccessLayout* @d @4 E99-------+ @& is\@is\@ Reference4++++++++++) eZ9s\@bx_@ occurrence_type @ <<<0000000. @ 嶸Ps\@&|G^@ association @| LWF0004 @ VJ88,,,,,,* b6s\@)_@ associations @ LWF000 WK99------+ cq\@cq\@ Reference2++++++++++) X hq\@,3^@ association @ 888,,,,,,,* @ T ڧq\@\K^@ association_type @ ===1111111/ @ q\@B*_@ employee @
LWF000 @ SG55))))))' Yq\@Ic@ all_topics - @[& @ OCC7++++++) ` VC S A 2 ObjectIdSIDACM FInheritable
ObjectId 3 3 3 3 3 3( ) * +
! " # $ % & ' = = = = = =
= = = = = = = =! =" =? & * & + & , + B + C + D , E , F , G . P . P . P / P / P / P 0 P 0 P 0 P 2 P 2 P 2 P 3 P 3 P 3 P 4 P 4 P! 4 P" 5 P# 5 P$ 5 P% 6 P& 6 P' 6 P( 7 P) 7 P* 7 P+ 8 P, 8 P- 8 P. 9 P/ 9 P0 9 P1 : P2 : P3 : P4 ; P= ; P> ; P? < N < O < P = Q = R = S G o G p G q H r H s H t I u I v I w J x J y J z [ 4 [ 5 [ 6 \ F \ G \ H ] I ] J ion a z*_@ z*_@ ~sq_femployee * @D& FFF:......, ` ` ;*_a z*_@ z*_@ ~sq_femployee * @D& FFF:......, ` VC ? G S q
ObjectId AttributeOrderName1Name2
ExpressionFlag ilnzjtz ObjectIdAttribute
f
f
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKVf
f
f
f
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKVf
f
f
f
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKVf
f
f
f
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKVf
f
f
f
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKVf
f
f
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKVf
f
f
f
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKVf
f
f
f
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKVf
f
f
f
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKVf
f
f
f
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKVf
7 7 ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o 7 6 6 ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o 6 VC S
szRelationshipgrbitccolumnicolumnszObjectszColumnszReferencedObjectszReferencedColumn
szObjectszReferencedObjectszRelationship
id_employee$#~"~"~"~D#~
'employee't#~@#~,#~ #~ $~#~ #~#~#~
~ [employee]![last_name]#~ ", " $~
~ [employee]![first_name]<$~#~#~0#~$~H$~~x ~~x ~~x ~ h$~X$~ $~$~ $~%~
%~
%~
0&~
@
@
@
%~
h$~%~%~%~%~ %~
$~%~%~%~%~ &~
$~&~%~4&~&~ ~ ~
~ ~
~ ~
@&~ &~p&~&~&~&~
department~d~ ~d~
'~&~@'~p'~
@&~
p&~
&~
(~
(~
@'~$(~ 0(~`(~4(~
'department_' d(~
'~
id_department(~ (~h(~'~(~ 'department'(~(~~~~~~~ (~(~ )~)~ P)~)~
p*~
*~
*~
0+~
p+~
@
@
@
@
@
D*~
(~H*~)~t*~@*~ *~
)~*~`*~*~*~ *~
(~*~*~*~*~ +~
)~+~*~4+~+~ D+~
P)~H+~ +~t+~@+~ ~p~
~p~
~p~
~p~
~p~
+~`+~+~p,~+~,~,~,~@,~,~
+~
,~
@,~
{qg]SI? 5 ~v @ @ B` @ @ o { ǀ all_top all_topicsa all_top all_topicsall_topics_1"" all_topicsall_topics_1"" all_top all_top all_topicsall_topics_1 all_topicsall_topi all_topicsall_topics_1"" associationall_topics$ @ 5 -! ass associationall_topics$ @ 5 -! associationall_topics$ @ 5 -! associationall_topics$ @ 5 -! associationall_topics$ @ 5 -! associationall_topics$ @ 5 -! associationall_topics$ @ 5 -! associationall_topics$ @ 5 -! associationall_topics$ @ 5 -! employee.last_name* g G G type ' type ' type type ' & depar & dep & depa o { } ͬ iLPߓF FormHeader d
instanceOf_Label instanceOf Label d
name_Label name Label d
displayname_Label displayname Label d
sortname_Label sortname Label Detail m name m displayname m sortname FormFooter
id_topic instanceOf ͬ iLPߓF FormHeader d
instanceOf_Label instanceOf Label d
name_Label name Label d
displayname_Label displayname Label d
sortname_Label sortname Label Detail m name m displayname m sortname FormFooter
id_topic instanceOf ͬ
DV`D { FormHeader Detail m name d name_Label name Label o id_employee d id_employee_Label id_employee Label p employee_Subform employee Subform d
employee_Subform_Label employee Subform Label FormFooter id_department ͬ ^$~4L M?йY) FormHeader Detail m last_name d last_name_Label last_name Label m first_name d first_name_Label first_name Label m date_of_birth d date_of_birth_Label date_of_birth Label m salary d salary_Label salary Label m
name d name_Label name Label m Text10 d
Label11 p associations p occurrence_type_subform occurrence_type subform d
Label18 d
Label19 FormFooter id ͬ
)vlT@h FormHeader d
name_Label name Label d
id_association_Label id_association Label d
id_association_type_Label id_association_type Label d
member_1_Label member_1 Label d
member_2_Label member_2 Label Detail o instanceOf d Label16 o member_1 d
Label17 @ @ @ @ @ @ @ `vvrbj`wjrp,w}sf ! `vvrbj`wjrpv dfs`uwofpw fosmr}ff fosmr}ffvxagruo rbbxuufpbf,w}sf . rbbxuufpbfv v{jwbiar`ud . wrsjbvxagruo wrsjb,w}sf |wo `dojp d`w`a`vfv gruov ordxmfv ufm`wjrpvijsv ufsruwv
vbujswv v}vufm w`amfv 1vt,bdfs`uwofpw1vt,bfosmr}ffvxagruo . 1vt,bdfs`uwofpw1vt,bjd,fosmr}ff . 1vt,bfosmr}ff1vt,b`vvrbj`wjrpv . 1vt,bfosmr}ff1vt,brbbxuufpbf,w}sfvxagruo . 1vt,bwrsjb,w}sf1vt,bwrsjbvxagruo . 1vt,g`vvrbj`wjrp,w}sf 1vt,gdfs`uwofpw . 1vt,gfosmr}ff 1vt,grbbxuufpbf,w}sf 1vt,gv{jwbiar`ud . 1vt,gwrsjb,w}sf . `mm,wrsjbv `vvrbj`wjrp `vvrbj`wjrp,w}sf dfs`uwofpw fosmr}ff ov}v`bfv ov}vordxmfv . ov}vordxmfvX . ov}vrakfbwv ov}vtxfujfv ov}vufm`wjrpvijsv rbbxuufpbf . rbbxuufpbf,w}sf . v{jwbiar`udjwfov . wrsjb . wrsjb,w}sf . `bbfvvm`}rxw
ov}vda vxoo`u}jpgr xvfudfgjpfd dfs`uwofpwfosmr}ff . ufgfufpbf . ufgfufpbfW . ufgfufpbfX . ufgfufpbfZ .
ufgfufpbfX . ufgfufpbfZ .
pbfX . ufgfufpbfZ .
ufgfufpbfZ .
W
WW
WW
WW
WW
WW
WW
WW
WW
WW
WW
WW
WW
WW
WW
WW
WW
WW
WW
WW
WW
WW
WW
WW
WW
WW
WW
WW
WW
WWo { < 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< 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< C< A> D> J> I> F> G> H> E? K? k? k? k? M? k ? k? k? L@ k @ k$@ k#@ k @ k!@ k"@ k A k%A k+A k*A k'A k(A k)A k&B k,B k1B k0B k.B k/B k-C k2C k:C k;C k4C k5C k6C @ @ @ @ @ @ @
. . . . .
. . . . . . ' . ( ! ) . * . + , - . . & , . / . [ . b . g . m . . < associa< associa< association_type < association_type < < association_type < < association_type < < associa< associa< association_type < < associa< association_type < < association_type < associa< associa< associa< association_type < association_type < < association_type < < association_type < < associa< associa< association_type < association_type < < association_type < < association_type < < associa< associa< associa< association_type < association_type < < association_type < < association_type < < associa< associa< associa< association_type < associa< associa< associa< association_type <
{qg]SI?bv ( b bbv @ @ ; @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ s s s s s s s s s
s s s s s s s s s s s s s! s+ s, s- s. y y
y
y
y y y y y y y
y y y
y y y y y y y# y$ y% 6 6 y& y y y y y y y y y y y y y y! y"
' T ' T ' T
( T ( T ( T
) T ) T ) T * T * T * T + T + T + T , T , T , T - T - T - T . T . T . T 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6
& 6 & 6 & 6
, 6 , 6 , 6 / 6 / 6 / 6 [ 6 [ 6 [ 6! b 6" b 6# b 6$ g 6% g g m m m s s s s s s s
s s s s s s s s s s s P) K % )& @P) u xx + K % ) P) E HH u K % )4 P)5 @ @ @ @ @ @ @ @ @
! " # % & $ ) X ) X ) X
) X ) X ) X * X * X * X * X * X * X + X + X" + X + X! + X + X + X + X + X + X + X + X , X# , X% , X& , X$ - X' - X) - X* - X( . X+ . X- . X. . X, & X & X
U|xU|
U|xU|
U|xU|
U|xU|
U|xU|
U|xU|
U|xU|
U|xU|
U|xU|
U|xU|
U|xU|
U|xU|
U|xU|
U|xU|
U|xU|
U|xU|
U|xU|
U|xU|
U|xU|
U|xU|
U|xU|
U|xU| dfs`uwofpwfosmr}ff r ufgfufpbf rufgfufpbfW rufgfufpbfX rufgfufpbfZ rruwv
vbujswv v}vufm w`amfv `s{~,tu}amrblbrpwurmv `s{~,tu}brpwurmp`ofv `s{~,tu}daw}sfjpdf|fv
'employee_' "U|
U|
id_employee$#U|"U|"U|"U|D#U|
'employee't#U|@#U|,#U| #U| $U|#U| #U|#U|#U|
U| [employee]![last_name]#U| ", " $U|
U| [employee]![first_name]<$U|#U|#U|0#U|$U|H$U|U|x U|U|x U|U|x U| h$U|X$U| $U|$U| $U|%U|
%U|
%U|
0&U|
@
@
@
%U|
h$U|%U|%U|%U|%U| %U|
$U|%U|%U|%U|%U| &U|
$U|&U|%U|4&U|&U| U| U|
U| U|
U| U|
@&U| &U|p&U|&U|&U|&U|
departmentU|dU| U|dU|
'U|&U|@'U|p'U|
@&U|
p&U|
&U|
(U|
(U|
@'U|$(U| 0(U|`(U|4(U|
'department_' d(U|
'U|
id_department(U| (U|h(U|'U|(U| 'department'(U|(U|U|U|U|U|U|U| (U|(U| )U|)U| P)U|)U|
p*U|
*U|
*U|
0+U|
p+U|
@
@
@
@
@
D*U|
(U|H*U|)U|t*U|@*U| *U|
)U|*U|`*U|*U|*U| *U|
(U|*U|*U|*U|*U| +U|
)U|+U|*U|4+U|+U| D+U|
P)U|H+U| +U|t+U|@+U| U|pU|
U|pU|
U|pU|
U|pU|
U|pU|
+U|`+U|+U|p,U|+U|,U|,U|,U|@,U|,U|
+U|
,U|
@,U| `vvrbj`wjrp rdfs`uwofpw rfosmr}ff r rbbxuufpbf rwrsjb rW
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKVW
W
V
V
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKVW
W
S
J
J
J
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKVJ
J
J
J
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKVJ
J
J
J
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKVJ
J
J
J
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKVJ
J
J
J
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKVJ
= = ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o = , , ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o , + + ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o + & & ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o & ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o @ @ `vvrbj`wjrp,w}sf rdfs`uwofpw r fosmr}ff rrbbxuufpbf,w}sf rwrsjb,w}sf r(t ttt
(tt{G^@ 0t@tXqXqt0.Xq-qt0.Xq q t0.Xq qassociationttt
t(t,3^@~sq_fassociation@t tt tt ttttt t0.-t0. t0. association tt tt ttttt
tXt t (t@tPt`tpttt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
ttttt t
t
t t
t
t
t
|t H t0tX t3.@t t
t tP
t t t
t
P
t4 ( t0 t8 t t
tP
t
t association t t tPrimaryKeyid_association_typeid_association ttv ttttXtXstXtXtXtXtXtXtXtXtXtXtXtXtXtXtXtXtXtXtXtXtXtXtX< " Q]u=Dqqqq
B>CBb A: & & bc@bc@ & OL q\@( ;mc@uc@ association_type_ @| LWF000 @ [O==111111/ & OL q\@dH;+q\@ employee @ Y 555)))))))' @ v"q\@dH;+q\@ department5 @ P 777+++++++) @ . hq\@,3^@ association @u 888,,,,,,,* @ Yq\@Ic@ all_topics @u @z C77+++++++) @
!]'q\@펋s\@ Admin4 @ 2&&&&&&&&&$ o_@.Ƹc@ XTM$$$$$$$$$$" . (g^@~+Nc@ topic SubformM @| LWF000R @} XL::......, VJ_@@Tpc@ occurrences,,,,,,,,,,* .
q\@rc@ employee @v LWF000 @ SG55))))))' |1q\@H `@ department< @v LWF000 @ z UI77++++++) b6s\@rc@ associations @v LWF000 x WK99------+ -ܸq\@-ܸq\@ UserDefined,,,,,,,,,,* . ,Ss\@H6c@ AccessLayout* @ u @ E99-------+ @ Qq\@Qq\@ SysRel''''''''''% Qq\@Qq\@ Scripts((((((((((& -ܸq\@-ܸq\@ Reports((((((((((& Qq\@Qq\@ Modules((((((((((& -ܸq\@-ܸq\@ Forms&&&&&&&&&&$ q\@q\@ MSysRelationships22222222220 q\@q\@ MSysQueries,,,,,,,,,,* q\@q\@ MSysACEs))))))))))' q\@q\@ MSysObjects,,,,,,,,,,* q\@cxc@ MSysDb @Y 333'''''''% @ q\@q\@ Relationships.........., q\@q\@ Databases**********( q\@q\@ Tables''''''''''% B bA lY"vcP3
wdQ>!!!!!!!!!!!!!!!!!!!!!!!!!!!!% % % employee.dat% % % employee.date_of% % employee.date_of_birth% employe% % % % employee.da% % % % % employee.date_o% employee.date_of_birth. % % % % % employee.date_o% employee.date_of_birth. % % % employee.date_of_birth. % employee.date_of_birth. % employee.date_of_birth. g%
topic_type G
([__id_topic_type] = instanceOf)8 ' __id_topic_type O topictopic_type G department G G employee [employee].[first_name]/ g [employee].[last_name]. g [employee].[id_employee]0 g # @ ' __id_department O employeedepartment G type ' id ' X7YZ_____2H @ " 7 X7YZ_____1x @ " 7 G G LVAL @ 1= $ % & ' ( ) * +
= = = = = =
= = = = = = = =! =" =? & * & + & , + B + C + D , E , F , G . P . P . P / P / P / P 0 P 0 P 0 P 2 P 2 P 2 P 3 P 3 P 3 P 4 P 4 P! 4 P" 5 P# 5 P$ 5 P% 6 Pdepartment.id_department = employee.iddepartment.id_department = employee.id_department"employee_" & [employee]![id_employee]SELECT association.instanceOf, association.member_1, association.member_2, association_type.role_type_1, association_type.role_type_2 FROM association_type INNER JOIN association ON association_type.id_association_type = association.instanceOf;SELECT DISTINCTROW occurrence_type.name, occurrence.id_topic, occurrence_type.datatype, occurrence.resource, occurrence.instanceOf FROM occurrence_type INNER JOIN occurrence ON occurrence_type.id_occurrence_type = occurrence.instanceOf;([__id_department] = id_department)SELECT 'Department_' & id_department, 'Department', name FROM departmentSELECT topic_type.name & '_' & topic.id_topic AS id, topic_type.name AS type, topic.name AS name FROM topic, topic_type WHERE topic.instanceOf = topic_type.id_topic_type
UNION SELECT 'TopicType_' & id_topic_type, 'Topic Type', name FROM topic_type
UNION SELECT 'Employee_' & id_employee, 'Employee', [employee]![last_name] & ", " & [employee]![first_name] FROM employee
VC N
U*2
2 id_association
instanceOfmember_1member_2 ++ ++ id_associationid_association_type
PrimaryKey ))
ac@ac@ Admin$$$$$$$$$$$ ac@ac@ XTM""""""""""" ac@ac@ topic_type))))))))))) ac@ac@ topic Subform,,,,,,,,,,, ac@ac@ occurrence_type subform66666666666 ac@ac@ employee Subform///////////
ac@ac@ employee''''''''''' ac@ac@ department))))))))))) ac@ac@ associations+++++++++++
ac@ac@ association_type/////////// ac@ac@ association Subform22222222222 ac@ac@ association*********** ac@ac@ UserDefined*********** ac@ac@ SummaryInfo*********** ac@ac@ AccessLayout+++++++++++ ac@ac@ SysRel%%%%%%%%%%% ac@ac@ Scripts&&&&&&&&&&& ac@ac@ Reports&&&&&&&&&&& ac@ac@ Modules&&&&&&&&&&& ac@ac@ Forms$$$$$$$$$$$ ac@ac@ MSysRelationships22222222220 ac@ac@ MSysQueries,,,,,,,,,,* ac@ac@ MSysACEs))))))))))' ac@ac@ MSysObjects,,,,,,,,,,* ac@ac@ MSysDb''''''''''% ac@ac@ Relationships.........., ac@ac@ Databases**********( ac@ac@ Tables''''''''''% S {qg @ pp ppv 'p&p
0%phphsphphphphphphphphphphphphphphphphphphphphphphphphphphphphp)p ppx+p)p pp(p'p'p p\p0p ps p p p p p p p p p p p p p p p p p p p p p p p p p p p p pH%p8&p %p p pp`$p@!p!p pPpp8px ptop |\;wW7 @ @ @ @ @ `vvrbj`wjrp `vvrbj`wjrpvxagruo `vvrbj`wjrp,w}sf `vvrbj`wjrpv dfs`uwofpw fosmr}ff fosmr}ffvxagruo rbbxuufpbf,w}sfvxagruo wrsjbvxagruo wrsjb,w}sf |wo `dojp d`w`a`vfv gruov ordxmfv ufm`wjrpvijsv ufsruwv
vbujswv v}vufm w`amfv `mm,wrsjbv ov}v`bfv ov}vrakfbwv ov}vtxfujfv ov}vufm`wjrpvijsv `bbfvvm`}rxw
ov}vda vxoo`u}jpgr xvfudfgjpfd nce_type
occurrencedY
dYdYdYPrimaryKeyid_topicid_occurrence_type
id_occurrence
dYdYdY dYdYHdY
dY`dY
PrimaryKeyhdYdYv dYdYdYdYv xdYXdYhdYdY employee_5Course_1 employee_5Course_6 employee_5Country_4 employee_3Course_6 employee_3Course_7 employee_3Country_9 employee_1Course_6
employee_1Course_1 employee_2employee_3 employee_6Course_2 employee_4Country_4 employee_2Country_4 employee_2Course_2 employee_1Country_4 employee_6Country_3 employee_6employee_1 employee_2Course_1 o @ @
topics)))))))))))
ac@ac@ Admin$$$$$$$$$$$ ac@ac@ XTM""""""""""" ac@ac@ topic_type))))))))))) ac@ac@ topic Subform,,,,,,,,,,, ac@ac@ occurrence_type subform66666666666 ac@ac@ employee Subform///////////
ac@ac@ employee''''''''''' ac@ac@ department))))))))))) ac@ac@ associations+++++++++++
ac@ac@ association_type/////////// ac@ac@ association Subform22222222222 ac@ac@ association*********** ac@ac@ UserDefined*********** ac@ac@ SummaryInfo*********** ac@ac@ AccessLayout+++++++++++ ac@ac@ SysRel%%%%%%%%%%% ac@ac@ Scripts&&&&&&&&&&& ac@ac@ Reports&&&&&&&&&&& ac@ac@ Modules&&&&&&&&&&& ac@ac@ Forms$$$$$$$$$$$ ac@ac@ MSysRelationships22222222220 ac@ac@ MSysQueries,,,,,,,,,,* ac@ac@ MSysACEs))))))))))' ac@ac@ MSysObjects,,,,,,,,,,* ac@ac@ MSysDb''''''''''% ac@ac@ Relationships.........., ac@ac@ Databases**********( ac@ac@ Tables''''''''''% o @ @
teUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtra
Id ParentIdName
ions5 * @& JJJ>2222220 ` G LVJ (_@(_@ ~sq_fassociations5 * @& JJJ>2222220 `J (_@(_@ ~sq_fassociations5 * @& JJJ>2222220 ` ' ,Ss\@?rc@ AccessLayout* @d @4 E99-------+ @& is\@is\@ Reference4++++++++++) eZ9s\@bx_@ occurrence_type @ <<<0000000. @ 嶸Ps\@&|G^@ association @| LWF0004 @ VJ88,,,,,,* b6s\@)_@ associations @ LWF000 WK99------+ cq\@cq\@ Reference2++++++++++) X hq\@,3^@ association @ 888,,,,,,,* @ T ڧq\@\K^@ association_type @ ===1111111/ @ q\@B*_@ employee @
LWF000 @ SG55))))))' Yq\@Ic@ all_topics - @[& @ OCC7++++++) ` o @ @
^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^
^ ^ _ _ _ _ _ _ ` ` ` ` ` ` a a )a 'a (a a !a "a #a $a %a &a b *b .b ,b -b /b +c 0c 6c 5c 2c 3c 4c 1d 7d 9d n d 8e ne ne ne ne ne nf nf n VC K N
2
+2
2 id_association_typename role_type_1 role_type_2 ++ ++ id_association_type
PrimaryKey 7YZ_____1.name`X88
pp(_@
0
`p
,
, , d , all_topics8pIc@
X7YZ_____1topic p
^@
topic_type
p ]q\@ ~sq_cassociations~sq_cmember_1 0[all_topics].[id][all_topics].[type][all_topics].[name]
1 p
xp
,
, , d , X7YZ_____1
topic
topic_type
all_topics @ , @ d @
1
p
,
, , d , X7YZ_____1P topic
topic_type
` p
8
@ p
,
, , d , X7YZ_____1 X
topic
topic_typep
p
,
, , d , topic
topic_type
ptopic
topic_type
topic_type
]q\@
topic_type
employeedH;+q\@employeex departmentdH;+q\@
department
7 p@P`p
{q
Pv p$h$v P%0%&v &&v 8,(,v 11U0B s 4 X64 h 3h22 0- @ @ @ @ @ @ @ @ @ `vvrbj`wjrp `vvrbj`wjrpvxagruo `vvrbj`wjrp,w}sf `vvrbj`wjrpv dfs`uwofpw fosmr}ff fosmr}ffvxagruo rbbxuufpbf,w}sfvxagruo wrsjbvxagruo wrsjb,w}sf |wo `dojp d`w`a`vfv gruov ordxmfv ufm`wjrpvijsv ufsruwv
vbujswv v}vufm w`amfv `mm,wrsjbv `vvrbj`wjrp ov}v`bfv ov}vrakfbwv ov}vtxfujfv ov}vufm`wjrpvijsv `bbfvvm`}rxw
ov}vda vxoo`u}jpgr xvfudfgjpfd
10H11x11
department
112H2
1
H1
x1
h3
3
22 383 3
'Department_' <3
1
id_departmentl32@3X23 'Department'33h h h 3x3 3X4 (4h4
H5
5
5
6
H6
@
@
@
@
@
5
3 5x4L55 \5
3`5855X5 5
35x555 5
355 65 6
(4 65L66
MarriageWifeHusband
NationalityCitizenCountry EnrollmentStudentCourse 1.X7YZ_____1.X7YZ_____1.type0all_topics.X7YZ_____1.X7YZ_____1.X7YZ_____1.name`X88
pp(_@
0
`p
,
, , d , all_topics8pIc@
X7YZ_____1topic p
^@
topic_type
p ]q\@ ~sq_cassociations~sq_cmember_1 0[all_topics].[id][all_topics].[type][all_topics].[name]
1 p
xp
,
, , d , X7YZ_____1
topic
topic_type
all_topics @ , @ d @
1
p
,
, , d , X7YZ_____1P topic
topic_type
` p
8
@ p
,
, , d , X7YZ_____1 X
topic
topic_typep
p
,
, , d , topic
topic_type
ptopic
topic_type
topic_type
]q\@
topic_type
employeedH;+q\@employeex departmentdH;+q\@
department
7 p@P`p
IdParentIdNameType
DateCreate
DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtra
Id ParentIdName
ions5 * @& JJJ>2222220 ` G LVJ (_@(_@ ~sq_fassociations5 * @& JJJ>2222220 `J (_@(_@ ~sq_fassociations5 * @& JJJ>2222220 ` ' ,Ss\@?rc@ AccessLayout* @d @4 E99-------+ @& is\@is\@ Reference4++++++++++) eZ9s\@bx_@ occurrence_type @ <<<0000000. @ 嶸Ps\@&|G^@ association @| LWF0004 @ VJ88,,,,,,* b6s\@)_@ associations @ LWF000 WK99------+ cq\@cq\@ Reference2++++++++++) X hq\@,3^@ association @ 888,,,,,,,* @ T ڧq\@\K^@ association_type @ ===1111111/ @ q\@B*_@ employee @
LWF000 @ SG55))))))' Yq\@Ic@ all_topics - @[& @ OCC7++++++) ` VC N ! !
2
id_department id_employeename ! # ! $ ! % & .rDid_boss
id_department
PrimaryKey nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf n S {qg partment_' & ded Gd Gd d Gd Gd d Gd d Gd Gd Gd Gd d Gd d d Gd d d Gd d d Gd Gd Gd d Gd Gd d Gd d d Gd Gd Gd d Gd Gd d Gd d d Gd Gd Gd Gd d Gd d d Gd d d Gd d d Gd Gd Gd a Ga Ga employee aa employee a departmentemployee1 @Y5 * a departmentemployee1 @Y5 * a dep @ @ @ @ @ @ `vvrbj`wjrp `vvrbj`wjrpvxagruo `vvrbj`wjrp,w}sf `vvrbj`wjrpv dfs`uwofpw fosmr}ff fosmr}ffvxagruo rbbxuufpbf,w}sfvxagruo wrsjbvxagruo wrsjb,w}sf |wo `dojp d`w`a`vfv gruov ordxmfv ufm`wjrpvijsv ufsruwv
vbujswv v}vufm w`amfv `mm,wrsjbv `vvrbj`wjrp `vvrbj`wjrp,w}sf ov}v`bfv ov}vrakfbwv ov}vtxfujfv ov}vufm`wjrpvijsv `bbfvvm`}rxw
ov}vda vxoo`u}jpgr xvfudfgjpfd x x Xx@xPx`xpxx@x
x@x
x@x
x@x
x@x
x@x
x@x
x@x
x@x
x@x
x@x
x@x
x@x
x@x
x@x
x@x
x@x
x@x
x@x
x@x
x@x
x@x
x@x
x@x
x@x
x@x
x@x
x@x
x@x
x@xxxpx xx@ x`x@ x x@ x
x@ x
|x (
xx8
x@ x
x
xP x
x` x xp x
x
x
x
x8
x
x
x
x
x
x
x x@ x associationh
xx
x
xPrimaryKeyid_association_typeid_association
xxv xxxx Marketing Sales " " nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf nf n " "
IdParentIdNameType
DateCreate
DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtra
Id ParentIdName
ions5 * @& JJJ>2222220 ` G LVJ (_@(_@ ~sq_fassociations5 * @& JJJ>2222220 `J (_@(_@ ~sq_fassociations5 * @& JJJ>2222220 ` ' ,Ss\@?rc@ AccessLayout* @d @4 E99-------+ @& is\@is\@ Reference4++++++++++) eZ9s\@bx_@ occurrence_type @ <<<0000000. @ 嶸Ps\@&|G^@ association @| LWF0004 @ VJ88,,,,,,* b6s\@)_@ associations @ LWF000 WK99------+ cq\@cq\@ Reference2++++++++++) X hq\@,3^@ association @ 888,,,,,,,* @ T ڧq\@\K^@ association_type @ ===1111111/ @ q\@B*_@ employee @
LWF000 @ SG55))))))' Yq\@Ic@ all_topics - @[& @ OCC7++++++) ` " " `_ _p__(__ ___H__|_ _P_P ____X(0_x___(__
_
H_
x_
_<_____H___H_x____association_type8_H_PrimaryKeyid_association_type association___PrimaryKeyid_association_typeid_association ___ __H__`_
PrimaryKeyh__v ___v _x_ __ _ s_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _0 _ _P _ _ X___ _ association__ __
___8__@__P_t_ ___
h _ [__id] _
_
member_1_p__`___
___association_type
PrimaryKey_______ ___ _ _ _ _
PrimaryKey_ _
_ _ _ _VC N ' '
2
2 id_employee
id_department last_name
first_name
date_of_birthsalary ' ) ' * ' + departmentemployee id-employee
id_department
PrimaryKey ubform~sq_cid_topic * @<& bbbVJJJJJJH ` \ <_@<_@ ~sq_coccurrence_type subform~sq_coccurrence typeK * @:& iii]QQQQQQO ` [ o_@__@ XTM$$$$$$$$$$" = VJ_@f=_@ occurrence_type subform88888888886 < _@_@ ~sq_fassociation_type * @ NNNB6666664 ` ; R_@R_@ ~sq_cassociation_type~sq_cassociation Subform
* @ fffZNNNNNNL ` : k"_@k"_@ ~sq_fassociation Subformj s * @ QQQE9999997 ` 9 $ "_@$ "_@ ~sq_cassociation Subform~sq_cmember_1 * @ ^^^RFFFFFFD ` 8 z"_@Y"_@ ~sq_cassociation Subform~sq_cmember_2 * @ _
_
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o _
^
^
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ^
]
]
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ]
\
\
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o \ _
PrimaryKey___ __ _P _ _ _ _P _ _ _ ___ S {qg PP) e 5 K % ) \PP) e e e e e e K % ) PP) K % ) QP) K % ) XQP) K % ) QP) K % )+ RP) u xx E K % )n TRP) U XX K % 4) RP) e K % 4) RP) e e u u K `e % )| PSP) u 5 K % ) SP) e e % K % ) SP) e % e K % )d LTP) E HHu e K % ) TP) U U e K % ) TP) e e U % U K % ) HUP) U & _5
@ @ @ @ @ @ @ @ `vvrbj`wjrp `vvrbj`wjrpvxagruo `vvrbj`wjrp,w}sf `vvrbj`wjrpv dfs`uwofpw fosmr}ff fosmr}ffvxagruo rbbxuufpbf,w}sfvxagruo wrsjbvxagruo wrsjb,w}sf |wo `dojp d`w`a`vfv gruov ordxmfv ufm`wjrpvijsv ufsruwv
vbujswv v}vufm w`amfv `mm,wrsjbv `vvrbj`wjrp `vvrbj`wjrp,w}sf dfs`uwofpw ov}v`bfv ov}vrakfbwv ov}vtxfujfv ov}vufm`wjrpvijsv `bbfvvm`}rxw
ov}vda vxoo`u}jpgr xvfudfgjpfd d_`d_
PrimaryKey`d_d_v d_d_d_v Pd_(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_ d_ d_ d_ d_ Pd_d_d_d_x d_occurrence_type d_d_d_d_d_d_d_d_
occurrenceid_occurrence_typed_d_ d_d_
d_d_Pd_d_ @ @SmithSusan# ? @@ @@HunterHelena% ? C@ X@FieldingFred%!? @@ @@JenkinsJoe# ? &@ L@JonesSally# ? @ @SmithJohn" ?& @ ( ( ( ( ( ( subform * @@& bbbVJJJJJJH ` ^ =_@CA=_@ ~sq_foccurrence_type subform
* @>& UUUI======; ` ] <_@ =_@ ~sq_coccurrence_type subform~sq_cid_topic * @<& bbbVJJJJJJH ` \ <_@<_@ ~sq_coccurrence_type subform~sq_coccurrence typeK * @:& iii]QQQQQQO ` [ o_@__@ XTM$$$$$$$$$$" = VJ_@f=_@ occurrence_type subform88888888886 < _@_@ ~sq_fassociation_type * @ NNNB6666664 ` ; R_@R_@ ~sq_cassociation_type~sq_cassociation Subform
* @ fffZNNNNNNL ` : k"_@k"_@ ~sq_fassociation Subformj s * @ QQQE9999997 ` 9 $ "_@$ "_@ ~sq_cassociation Subform~sq_cmember_1 * @ ^^^RFFFFFFD ` 8 z"_@Y"_@ ~sq_cassociation Subform~sq_cmember_2 * @ _
_
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o _
^
^
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ^
]
]
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ]
\
\
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o \ _
PrimaryKey___ __ _P _ _ _ _P _ _ _ ___ & @ ( ( ( ( ( (
IdParentIdNameType
DateCreate
DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtra
Id ParentIdName
ions5 * @& JJJ>2222220 ` G LVJ (_@(_@ ~sq_fassociations5 * @& JJJ>2222220 `J (_@(_@ ~sq_fassociations5 * @& JJJ>2222220 ` ' ,Ss\@?rc@ AccessLayout* @d @4 E99-------+ @& is\@is\@ Reference4++++++++++) eZ9s\@bx_@ occurrence_type @ <<<0000000. @ 嶸Ps\@&|G^@ association @| LWF0004 @ VJ88,,,,,,* b6s\@)_@ associations @ LWF000 WK99------+ cq\@cq\@ Reference2++++++++++) X hq\@,3^@ association @ 888,,,,,,,* @ T ڧq\@\K^@ association_type @ ===1111111/ @ q\@B*_@ employee @
LWF000 @ SG55))))))' Yq\@Ic@ all_topics - @[& @ OCC7++++++) ` & @ ( ( ( ( ( ( W Wp WWv W WWv 'W'W01WxWxsWxWxWxWxWxWxWxWxWxWxWxWxWxWxWxWxWxWxWxWxWxWxWxWxWxWxWxWxW)W W+W)W WW(W'W'W( WlW0 W( W(s 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( WX%WH&W0%W WWp$WP!W!W W`WWHW WtopicWHWWHW WHW
( WX W W W W
topic_type
PrimaryKeyWTW WTW
W W8 Wh WWTW W W W$ W
PrimaryKeyX W4 W
WT W0 W8 Wx W
PrimaryKeyemployeeW`W W`W
W`W
W` W W !W W0!W
"W
8 W
W
(#W
x#W
@$W!W !WX"W!W "W0"W"W
8 W topic_type.name4"W '_' \"W
( W topic.id_topic"W!W"W@!W`"W"W"W "W"WVC E N - -
__A__
2
2 id_employee
id_department last_name
first_name
date_of_birthsalary 3 3ee~sq_coccurrence_type subform * @@& bbbVJJJJJJH ` ^ =_@CA=_@ ~sq_foccurrence_type subform
* @>& UUUI======; ` ] <_@ =_@ ~sq_coccurrence_type subform~sq_cid_topic * @<& bbbVJJJJJJH ` \ <_@<_@ ~sq_coccurrence_type subform~sq_coccurrence typeK * @:& iii]QQQQQQO ` [ o_@__@ XTM$$$$$$$$$$" = VJ_@f=_@ occurrence_type subform88888888886 < _@_@ ~sq_fassociation_type * @ NNNB6666664 ` ; R_@R_@ ~sq_cassociation_type~sq_cassociation Subform
* @ fffZNNNNNNL ` : k"_@k"_@ ~sq_fassociation Subformj s * @ QQQE9999997 ` 9 $ "_@$ "_@ ~sq_cassociation Subform~sq_cmember_1 * @ ^^^RFFFFFFD ` 8 z"_@Y"_@ ~sq_cassociation Subform~sq_cmember_2 * @ _
_
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o _
^
^
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ^
]
]
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ]
\
\
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o \ _
PrimaryKey___ __ _P _ _ _ _P _ _ _ ___ { < dW K x &? dWdWPdWh dW4
dWdWdWdWdWdWdWdW
2 "occurrence_type.id_occurrence_type$occurrence_type occurrence_type.namedWdWdWdW
dW<_@ dWdWx
$GsdWA)
$Gx#xdWA)
$Gx xoccurrence_type dWdWdW dWdWbx_@0~sq_coccurrence_type subform~sq_coccurrence typedW @dWhdW pdWdW&[occurrence_type].[id_occurrence_type]@dW[occurrence_type].[name]pdW dWA)$G!dWA) occurrence_type dW@dW dWHdW@dWpdW
dWx
dW dW dW@dWHdWPdWXdW`dWPdW
dWPdW
dWPdW
dWPdW
dWPdW
dWPdW
dWPdW
dWPdW
dWPdW
dWPdW
dWPdW
dWPdW
dWPdW
dWPdW
dWPdW
dWPdW
dWPdW
dWPdW
dWPdW
dWPdW
dWPdW
dWPdW
dWPdW
dWPdW
dWPdW
dWPdW
dWPdW
dWPdW
dWPdW
dWPdWdWdWdW@ dW dW dW` dW dW
|dW dWPdW dWC)dW dW dW dW dW
dW0p dWx dW dW dW dWoccurrence_type dW dWPrimaryKeyid_occurrence_type dWdWv dWdWdWdW 7 @k(x=Ċ%NNy!AA= } ' ,zhc@,zhc@ occurrence_type00000000.
c@
c@ ~sq_fSwitchboard
R * @+O III=111111/ ` * 9rc@\8rc@ ~sq_cemployee~sq_cassociationsx * @ O WWWK??????= ` ) 9rc@9rc@ ~sq_cemployee~sq_coccurrence_type subform~ * @O bbbVJJJJJJH ` {QZc@{QZc@ ~sq_ctopic_type~sq_ctopic Subform * @
O ZZZNBBBBBB@ ` ,Yc@,Yc@ ~sq_fdepartment * @O HHH<000000. ` ,Yc@,Yc@ ~sq_cdepartment~sq_cid_employee * @O XXXL@@@@@@> ` Yc@Yc@ ~sq_cdepartment~sq_cemployee Subform * @O ]]]QEEEEEEC ` $/Bc@Hc@ Switchboard,,,,,,,,,,* X(Bc@)Bc@ Switchboard Items @ >>>22222220 @ ڧq\@\K^@ association_type @ O ===1111111/ @ #g^@~+Nc@ topic_type @v LWF000 @ ~ UI77++++++) m1q\@hD `@ employee Subformv @| LWF000 @ } [O==111111/ -ܸq\@-ܸq\@ SummaryInfoB @u 888,,,,,,,* @ is\@is\@ Reference4++++++++++) cq\@cq\@ Reference2++++++++++) a>\q\@a>\q\@ Reference1++++++++++) 8$q\@8$q\@ Reference**********( A
;+q\@A
;+q\@ departmentemployee33333333331 m >eqVq\@]q\@ topic_typel @ 777+++++++) @ g Zq\@
^@ topic @ 222&&&&&&&$ @ b eZ9s\@bx_@ occurrence_type @ <<<0000000. @ [ Giq\@C_@ occurrenceQ @ 777+++++++) @ / -ܸq\@-ܸq\@ MSysModules2----------+ , -ܸq\@-ܸq\@ MSysModules,,,,,,,,,,* VC e D N 0 0
FlagsFormModuleNameReplicationVersionTypeTypeInfoVersion 0 Z Index1 0 0 0 =_@CA=_@ ~sq_foccurrence_type subform
* @>& UUUI======; ` ] <_@ =_@ ~sq_coccurrence_type subform~sq_cid_topic * @<& bbbVJJJJJJH ` \ <_@<_@ ~sq_coccurrence_type subform~sq_coccurrence typeK * @:& iii]QQQQQQO ` [ o_@__@ XTM$$$$$$$$$$" = VJ_@f=_@ occurrence_type subform88888888886 < _@_@ ~sq_fassociation_type * @ NNNB6666664 ` ; R_@R_@ ~sq_cassociation_type~sq_cassociation Subform
* @ fffZNNNNNNL ` : k"_@k"_@ ~sq_fassociation Subformj s * @ QQQE9999997 ` 9 $ "_@$ "_@ ~sq_cassociation Subform~sq_cmember_1 * @ ^^^RFFFFFFD ` 8 z"_@Y"_@ ~sq_cassociation Subform~sq_cmember_2 * @ _
_
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o _
^
^
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ^
]
]
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ]
\
\
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o \ _
PrimaryKey___ __ _P _ _ _ _P _ _ _ ___ {qg]SI? 5 8
= @ 0 @ LVAL 2 < ' x c x x l)?
xh8V
@1Ii 8X1Ii
2
2
2 $association_type.id_association_typeassociation_typeassociation_type.name association_type.role_type_1 association_type.role_type_2@p
xOAzc@
3
13 I3 i3 association_typeP h x\K^@~sq_fassociation_type 0 8 8@ XH 8X3
13 I3 i3 association_type H 1P IX i` 8X
H x@P`ph
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
| P
(h
Ȃ3
x 8
8 8(
0
8
@
8 h association_type
PrimaryKeyid_association_type
v }LVAL @ @ @ @ @ @ @ @
! " # % & $ & X & X & X
& X ) X ) X ) X
) X ) X ) X * X * X * X * X * X * X + X + X" + X + X! + X + X + X + X + X + X + X + X , X# , X% , X$ s s
s s HHsHHHHHHHHHHHHHHHHHHHHHHHHHHHH h(p8association_type
PrimaryKey8 H((Xh LVAL 4 < W P t x P l)? tPtt
t4
tt0t tt t ttt tt0t
2
2 "occurrence_type.id_occurrence_type$occurrence_type occurrence_type.nameoccurrence_type.datatype@t8tt t
@tG {c@HtXt
t3
t3 0t3 occurrence_type ttt p
t@tbx_@~sq_foccurrence_typeXt tt tt tttt tt3
t3 0t3 occurrence_type tt tt 0tttt t
t(t t @t@tPt`tpttt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tt
tttt`t t
tp
t` tp
t
tp
t
|t 8 ttH tȂ3Xt t
t t@
t t t
t
@
t4 t t( t t
t@
tp
toccurrence_typeh tx tPrimaryKeyid_occurrence_type ttv tttt(t(st(t(t(t(t(t(t(t(t(t(t(t(t(t(t(t(t(t(t(t(t(t(t(t(t(t(t(t(tt t tMLVAL Y @ @ @ @ @ @ @ @ @
! " # % & $ & X & X & X
& X ) X ) X ) X
) X ) X ) X * X * X * X * X * X * X + X + X" + X + X! + X + X + X + X + X + X + X + X , X# , X% , X& , X$ - X' - X) - X( s ! CommandSwitchboard ItemsCommandCommandC tHt"
toccurrence_type PrimaryKeyt
tt ttt(tttt0tp
t / DžDž5MI:+ĩĩĚ' xteeeeeeeeeeeeeeeeeeeeeeeeeeeeeVVVVVVVVVVVVVVVVG
ۇ 1
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKVA
A
@
@
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKVA
A
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o X X ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o X T T ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o T ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o F F ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvw AF MSysDb C # AF MSysDb C # y Form_occurrences AF MSysDb C # y Form_occurrences F MSysDb C # y Form_occurrences A EA51- J U > Q Form_Switchboard V < EA51- K 7 XTM \ & ~ok\MI:+6'teaRC & bc@bc@ employee''''''''''' bc@bc@ dg b b ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o b [ [ ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o [ ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o T ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o / / ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o / , , ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o , T ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o & & ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o & ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o LVAL 8 i _ V B A _ M O D U L E x V ف x @ 1 8L 8L (LX >
L L L L L L L L L L L L L L L L L <| < le : > * \ R 4 * # 6 a * \ R 4 * # 8 * \ R 2 * # 2 d $ * \ R f f f f * e 1 3 e 1 f 3 6 8 0 * \ R 2 * # 2 8 * \ R 0 * # c * \ R 4 * # b * \ R 0 * # 1 0 * \ R 2 * # 2 f * \ R 2 * # 3 0 * \ R 2 * # 1 b * \ R 2 * # 3 1 * \ R 4 * # 1 * \ R 2 * # 0 * \ R 2 * # 2 8 * \ R 1 * # 8 e * \ R 1 * # 8 f * \ R 0 * # 1 * \ R 0 * # b * \ R 4 * # 1 1 * \ R 4 * # 6 * \ R 4 * # 1 2 * \ R 0 * # 1 1 * \ R 1 * # 8 e * \ R 2 * # 2 8 * \ R 4 * # 1 2 * \ R 4 * # 6 * \ R 4 * # 1 1 * \ R 4 * # 8 * \ R 2 * # 2 d p $ 0 $ tP X $ $ `x $ $ $ ` `H $ $ $ `d $ $ $ t $ > > ( $ $ $ ^h8 > > P > 0 $ $ > X ] @ 8 LVAL 9 > > $ $ $ @ 8 $ ` l +r@ ` k n n 8 ) X )^ $ iz > h x 8 4 ( \jn6r \ X W > ) L ( > + ` p
k . . )^ h x < @ , ( ( @ h l` |ph `~d 8 `P b 8 h p p @ ` @ @ @ p x @ @ P @
@ p `rz \ @ h h @` (
a ` h 8 X 8
P
8
x
P
X p @ \ @X @ H @ 8 @( @
@P h
a @ @ P
b @
@v @x LVAL : ( @ @ @ @ @& @,p @4` @6 P 8
@ L ( @ H @ D @ @ @< @, @ P p @h @
@ h x @ @8 (
h @ @ @8
P
@ `
8
x 8
( ` h 8 x P ( `z ( @r \ @ @ l @ h @d @@ T @ D @ 4 @$ p @8 P @ 8 @ @ P @ x @ @v @ @x @ @ 8 p @ 8 ( ME B 0 @ L 0R . ( $ ) 04 N
N 2 R . & xL K S P R ` Z j I n J n M t K f xI LVAL ; @W F 0 Y &
N PD 2 H' 4 D `' & I ' 0& ' & hZ & D S Z C C d @T `C $ D @C 2 U C : V 0 @V & Z J h) ) ) * , X[ \ + ) + + & Z t [ 6 \ f \ d B ) A B 8\ d B ) A A , X\ X (, ) + , * Z (* T ) H + P pV ` V @* ) ( ) t E ) 8D F D `W Z W p PX ^ X W & X (D D [ 8< P ) C N V Y ` PY 0X Z \ 8L< (O ) N O L X]
H( 8X ( ] & E ] 0' B
( 0 8+ ,
, - .
x $ 8 @& 2 4 `
" @ H% @ (. P = & ( 4 p( & / ' 2 S ) H h = & 4 $ , / # " O " " ' = & / $ ( / # & / % & < ' $ 8# @ " % ^ PJ H * / `# * / p% " O # $ h (( 0 NI 4
H4 5 ,
- ( 4 H. 2 p. 4 .
- = 0 ( / (0 & / P0 2 S X1 - . = 1 A 0 0 . x0 LVAL < . . 1 = 82 0 * / 0 " O 2 H1 (1 * / 0 * F 5 01 4 4 4
`4 x4 M E
hD 5 F
xD 2 G = G ( 4 F ( / @G & / hG 2 P G * / 8F " O hF F G XI
`I pI -
p (' " B > 81
< * 4 : 2 H< 4 h<
< = < ( / < & / < 2 S = 8= 1 = = $ / P; & / : & / (; 2 S N > ; = x; & / ; 2 S = 1 ; = ; $ / < & / hA & / A 2 S B ; @= = @ & / A 2 S (A ; > >
> > > > ^ x Z Z k @ Variabele xmlDoc Private Global zodat je er van overal bij kunt Beperkingen verder uitwerken Alle FK's langslopen Code modulariseren! ) Controle of msxml4.dll geinstalleerd is? 9 XML tekst output eerst controleren op < en & en vertalen % . % ! Import . Issue bij import is m.n. FK's van beperkingen Msxml2.DOMDocument.4.0$ . \ id extension_topic_map B@ N B@ Z Z Z 8 . h ! ^ ! ! % ! U % . % ! % . % ! id_werknemer % ! ' h B@ B@ x a h
topic_typeH Q H Q Q nameH Q ! ^ ! ! % ! LVAL = \% . h % ! $ . h % ! $ kgevh % ! ' h B@ B@ B@ idH Q ' \ - SELECT * FROM WERKGEVER WHERE id_werkgever = ; % . ! ^ werkgever % . % . ! ! % ! $ F % ! % . g % ! % . B@ B@ % ! id_contactorganisatie % ! $ ? SELECT * FROM CONTACTORGANISATIE WHERE id_contactorganisatie = % ! ; % . ! ^ contactorganisatie % . % . ! ! % ! $ F % ! % . g % ! % . B@ B@ B@ x B@B h ` % !
id_arbodienst % ! $ ? SELECT * FROM CONTACTORGANISATIE WHERE id_contactorganisatie = % ! ; % . ! ^
arbodienst % . % . ! ! % ! $ F % ! % . g % ! % . B@ B@ B@ B@B h p % ! id_verzekeraar % ! $ ? SELECT * FROM CONTACTORGANISATIE WHERE id_contactorganisatie = % ! ; % . ! ^ verzekeraar % . % . ! ! % ! $ F % ! % . g % ! % . B@ B@ B@ LVAL > B@B h % ! id_uvi % ! $ ? SELECT * FROM CONTACTORGANISATIE WHERE id_contactorganisatie = % ! ; % . ! ^ UWV % . % . ! ! % ! $ F % ! % . g % ! % . B@ B@ B@ B@B h B@ B@B & SELECT * FROM CASE WHERE id_dossier = ; % . ! ^
contactmoment % . % . ! ! % ! $ F % ! % . g % ! ' duur_groter_13 weken_met F duur_groter_13_weken_met' g % . B@ B@ % ! id_contactorganisatie % ! $ ? SELECT * FROM CONTACTORGANISATIE WHERE id_contactorganisatie = % ! ; % . ! ^ contactorganisatie % . % . ! ! % ! $ F % ! % . g % ! % . B@ B@ B@
B@B h
% ! id_contactpersoon % ! $ 7 SELECT * FROM CONTACTPERSOON WHERE id_contactpersoon = % ! ; % . ! ^ contactpersoon % . % . ! ! % ! $ F % ! % . g % ! % . B@ B@ B@ B@B h % ! id_casemanager % LVAL ? ! $ 7 SELECT * FROM CONTACTPERSOON WHERE id_contactpersoon = % ! ; % . ! ^ casemanager % . % . ! ! % ! $ F % ! % . g % ! % . B@ B@ (
B@
B@B h % ! beperking_rubriek_1 % ! $ / SELECT * FROM SOORT_RUBRIEK WHERE id_rubriek = % ! ; % . ! ^ ! ! % ! $ F % ! % . g % ! % . B@ B@ x B@ ` B@B h H % ! beperking_kwaliteit_1 % ! $ 3 SELECT * FROM SOORT_KWALITEIT WHERE id_kwaliteit = % ! ; % . ! ^ ! ! % ! $ F % ! % . g % ! % . B@ B@ B@ B@B h % ! beperking_veld_1 % ! $ ) SELECT * FROM SOORT_VELD WHERE id_veld = % ! ; % . ! ^ ! ! % ! $ F % ! % . g % ! % . B@ B@ ( B@ B@B h B@ B@B - SELECT * FROM INTERVENTIE WHERE id_dossier = ; % . ! ^ interventie % . % . ! ! % ! $ F % ! % . g LVAL @ % ! % . B@ B@ % ! id_contactorganisatie % ! $ ? SELECT * FROM CONTACTORGANISATIE WHERE id_contactorganisatie = % ! ; % . ! ^ behandelaar % . % . ! ! % ! $ F % ! % . g % ! % . B@ B@ B@ B@B h x B@ ` B@B ' SELECT * FROM ACTIE WHERE id_dossier = ; % . ! ^ actie % . % . ! ! % ! $ F % ! % . g % ! % . B@ B@ B@ B@B * SELECT * FROM KNELPUNT WHERE id_dossier = ; % . ! ^ knelpunt % . % . ! ! % ! $ F % ! % . g % ! % . B@ B@ B@ p B@B ) SELECT * FROM NOTITIE WHERE id_dossier = ; % . ! ^ notitie % . % . ! ! % ! $ F % ! % . g % ! % . B@ B@ B@ B@B B@ B@B
C:\dev\tm.xml xB@ f xmlns:xlink http://www.w3.org/1999/xlink B@ aps.or B@ xmlns ! http://www.topicmaps.org/xtm/1.0/ B@
xlink:href #display xB@ , variantName \% LVAL A &% . 4 to baseNameString \% % .
parameters \% &% . , % ! \% . topic_ 6B@ baseName % . tnam % . baseNameString % . % . % ! % . B@ variant \% % . & baseName \% % . topicRef \% ,% . xsu id % ! B@ tname resourceData \% 4% . 6/xtm/1
xlink:href #sort xB@ maps.o B B@ DOCTYPE % L . N859- \! p. ^.l % ! $ "/>"s s topic \% ^% . topicMap % % . op& Unable to load tm-extension.xtm A@6 not xh p' & ' displayname H sortnameH Q "xtm1.' r f \( b tX \! f! h X Loading j < l /> \! f! h n parser errorA@6 h 0& % ! displayname p: topicRef \% v% . xYP ' z d$ ' \p SYST B@B % .
instanceOf \% % . v % . ' Modulariseren (soort TM library maken) e_ ! Topics sort en display toevoegen AddOccurences omhoog trekken van$ % . ^$ r ' t\ A SELECT 'topic_type_' & id_topic_type AS id, name FROM topic_type; ' % . ^$ r ' t
xlink:href # % ! xB@ me FRO ^$ r ' t\ ) B SELECT 'employee_' & id_employee AS id, 'employee' AS topic_type, ^ first_name & ' ' & last_name AS name, last_name & ', ' & first_name AS sortname FROM employee; ' 22h, % . ^$ r ' t h H Z 8 . id_to % . LVAL B d$ ' \ ^$ r ' t DA S SELECT 'association_type_' & id_association_type AS id, name FROM association_type; ' on F % . ^$ r ' tsoft D P SELECT 'occurrence_type_' & id_occurrence_type AS id, name FROM occurrence_type;' % . d$ ' \rrenceh % . | . Z L SELECT occurrence.instanceOf AS type, occurrence_type.datatype AS datatype, occurrence.resource AS resource ! FROM occurrence, occurrence_type WHERE occurrence.id_topic = ; ' L E |! ^ ' h h Z P typeH Q x datatypeH Q a h z F % ! ' ~g
occurrence \% % . |! ! |% ! h Z L SELECT occurrence.instanceOf AS type, occurrence_type.datatype AS datatype, occurrence.resource AS resource ! FROM occurrence, occurrence_type WHERE occurrence.id_topic = % ! ; ' id % ! B@ nce.in F % ! ' g B@ ' |% ! $ esou
instanceOf \% % . v topicRef \% v% . x ' B@ |% ! URI ur resourceRef \% % . dataty resourceData \% % . 6 resou resourceH Q a P h H Z @ Z 6B@
xlink:href # |% ! xB@ ployee |% ! $ enRe . href h Z role_1H Q h % ! x% . nd Fun |% ! \% . p As R |% ! $ ment
parameters x% &% . , subjectIndicatorRef x% ,% . 2create % ! displayname o
xlink:href 5 http://www.topicmaps.org/xtm/1.0/core.xtm#psi-display 2B@ Caa #
xlink:href 2 http://w LVAL C ww.topicmaps.org/xtm/1.0/core.xtm#psi-sort 2B@ h # variantName x% &% . 4ll(rst % ! x% . endChi 6B@ h " k " " X
Start Program Error handling X ar .i8" |B@ 6 6
; SELECT 'occurrence_type_' & occurrence.instanceOf AS type, & occurrence_type.datatype AS datatype, occurrence.resource AS resource ! FROM occurrence, occurrence_type WHERE occurrence.id_topic = ' ~ ' AND ; occurrence.instanceOf = occurrence_type.id_occurrence_type; ' 86
xlink:href |% ! B@ topic x% d% . ! ! % ! idH Q D id % ! B@ 000-C0 F % ! ' g
topic_typeH Q es\Mic % ! $ #Mic
instanceOf x% % . topicRef x% % . *
xlink:href # % ! B@ WINDOW nameH Q hdoc % ! $ ntro baseName x% % .
baseNameString x% % . E221 % ! x% . .dll#M B@ h 5 displayname H sortnameH Q nce_ty % ! $ variant x% % . &
parameters x% &% . , subjectIndicatorRef x% ,% . 2 L E % ! displayname !
xlink:href 5 http://www.topicmaps.org/xtm/1.0/core.xtm#psi-display 2B@
a 3
xlink:href 2 http://www.topicmaps.org/xtm/1.0/core.xtm#psi-sort 2B@ h X3 variantName x% &% . 4 _
resourceData x% 4% . 6urce " % ! x% . ence, 6B@ h 2 k 2 2 association \% ^% . 'occu roleSpec \% % . role_2H Q member_1H Q h topicRef \% % LVAL D . x member \% % . WH % ! $ ole % ! $ % h topicRef \% % . x; X ce"))
% . ! ^ cc.Fie member \% % . . ! ! % ! type typeH Q % ! $ Occ.
instanceOf \% % . v topicRef \% v% . xce
xlink:href # % ! xB@ h / member_2H Q % ! $ dChi % ! URI ") ' a / ' h / h / % ! $ ield
xlink:href # % ! xB@ % ! x% . If 6B@ resourceRef x% % . If
xlink:href % ! B@ h h. k `. X. B@ @. . ' f . @
= SELECT 'association_type_' & association.instanceOf AS type, ( association_type.role_type_1 AS role_1, " association.member_1 AS member_1, ( association_type.role_type_2 AS role_2, ! association.member_2 AS member_2 # FROM association, association_type D WHERE association.instanceOf = association_type.id_association_type; ' s(i) roleSpec x% % . =
xlink:href # % ! B@ f AS t % ! $ ole_ topicRef \% % . xpe
xlink:href # % ! xB@ e_type+ roleSpec \% % . topicRef \% % . x % . ^$ r ' tation_ % . ^$ r ' t \ SELECT DISTINCT 'role_type_' & role_type_1 AS id, role_type_1 AS name FROM association_type;' \ SELECT DISTINCT 'role_type_' & role_type_2 AS id, role_type_2 AS name FROM association_type;'
xlink:href # % ! xB@ xB@ - MUST contain 'id' LVAL E ins th - MAY contain 'sortname' - MUST contain 'name'n 'i % . S The recordset contains the following fields in this order, with these field names: ERE to - MAY contain 'displayname' _typ x@ % . \% d yee"X ROM to |! ^ ' % . ^$ r ' t I SELECT DISTINCT 'department' AS id, "Department" AS name FROM topic_type; ' H SELECT 'department_' & id_department AS id, 'department' AS topic_type, name FROM department; ' me, SELECT date_of_birth, salary FROM employee WHERE id_employee = ~ ~ $ ; '
date_of_birth H Q ou ^$ r ' t#date_ resourceData \% % . 6' |% ! \% . tanceO 6B@ ' e"> % . |
occurrence \% % . |! ! |% ! $
instanceOf \% % . v topicRef \% v% . x
xlink:href # |% ! xB@ h A |% ! $ |% ! URI ' a A ' h pA h hA resourceH Q |% ! $ resourceData \% % . 6 |% ! \% . 6B@ a @ resourceRef \% % .
xlink:href |% ! B@ h X@ h P@ k H@ @@ |B@ (@ W Salary ' c> [ Employee ' X nodSIRef.setAttribute "xlink:href", "http://www.topicmaps.org/xtm/1.0/core.xtm#psi-sort"ic _ Department ' ' e Date of birth ' Sort name ' { ' http:/ Display name ' < _ Assignment ' Z . sociat
xlink:href # % ! xB@ n_type \( b % Z ` ^$ ' t . % . ^$ ' t
SELECT 'assignment' AS type, 'department' AS role_1, 6 'department_' & department.id_department AS member_1, 'employee' AS role_2, / 'employee_' & employee.id_employee AS member_2 FROM employee, department 8 WHERE department.id_department = employee.id_department; ' pe J
= SELECT 'association_type_' & association.instanceOf AS type, 7 'role_type_' & association_type.role_type_1 AS role_1, " association.member_1 AS member_1, 7 'role_type_' & association_type.role_type_2 AS role_2, ! association.member_2 AS member_2 # FROM association, association_type D WHERE association.instanceOf = association_type.id_association_type; ' R F MSXML zorgt voor vertaling &, Euro-teken e.d., gecontroleerd en werkt (R + Make a basic Topic Map as a starting point J Add topic and association types related to tables Employee and Department Display name ' > Make a recordset containing topics and send it to AddTopics() ^ - MAY contain 'topic_type', being the id of the topic of which this topic is an ' an
5 SELECT topic_type.name & '_' & topic.id_topic AS id, D 'topic_type_' & topic_type.id_topic_type AS topic_type, topic.name, " topic.displayname, topic.sortname FROM topic, topic_type 2 WHERE topic.instanceOf = topic_type.id_topic_type; ' + The order of the last two is not important f the 4 Make such a recordset for all topic in the database ) First topics from the 'topic map' tables I Now make topic queries for the 'database' tables Employee and Department Y Replace those with your own queries when you want to use the code with your own database - MUST contain 'member_1' Finish basic Topic Map em = Make queries for all associations contained in the database. S The recordset contains the following fields in this order, with these field names: - ditto 'role_2' and 'member_2'th
Save the XTM t fo j - MAY contain 'association_type', being the id of the topic of which this association is an X - MAY contain 'role_1', being the id of the topic which the first refers to ) Make DOM object and load basic Topic Map Y Replace those with your own queries when you want to use the code with your own database O Now make association queries for the 'database' tables Employee and Department Y Replace those with your own queries when you want to use the code with your own database Set root to element Make topics for all topic types Make topics for all role types # Make topics for all regular topics LVAL H = First make a recordset for the 'topic map' table association es & Make topics for all association types m To do: role types may be the same as topic types ('Course' and 'Country'), these need only to be added once. / A simple NOT EXISTS clause would do the trick. Same for second role type % Make topics for all occurrence types tionH _ However, that needs fixing the id's for the roles when making associations, which is trickier. S There is an 'assignment' (bad name) association between an employee and department E To do: add is-manager-of association between employee and department " To do: prompt for name & location[ Save XTM file to: $ l \B@ ] Ʒ Attribut e VB_Nam e = "XTM "
Dim d om As MS XML2.DOM Document 40
Fu nction To f()
' Controle of msxm l4.dll g einstall eerd is?V tekst output cBren op < &ver Ben; zorgt voor ing &, Euro- Z 9e.d., U werktHodularHise7(s%t TM libr ary makenmAddOccu ces om hoog treFk $ErrChandl C rootIxEle
(SQLS ng rstTemp
Recordse YSet dDbsCur HtDb' MZ a basic pMap a&s
rtpo$intmA~ & "ndic atorRef :href@2* @ee.-#psi-/>S& n@ e LVAL I 6= d4}rpHnta"0Q}`se@
kP`ST\s ' spPe f ollowfields inpis er,SROO b\s: - MUSTE 'id'AY
_[', be!qUid9 whichS3an <ҤnceOf>A 'Au 'l?X
|O
`+e
latwo not imp|b4 su afТee d@Pa#s fr:'@z'o
2@ jrcQSEL0ECT #B_'1@3id_ A
S l, FROM ;1,,bs.Open(,@ASn hotDx *T, 3
w
0gۀ
XR 5} p и" \| h 0=zoC:`ׂ@yp5p3e sQpR" ('Cse'a @y'),=neonlFy` qaddce.A s. NOT EXIS@TS cla!wpould ckVHoweqat ap ix@'s 1.qs B0{!sHA@"i,erTk-D IN- 1% ,??. $&P* et' / /?s( / -uSBs`_ndG $QL"4<er.
2 ype_2 AS name FR OM assoc iation_tA ;"
S et rstTe mp = dbs .OpenRec ordset(SQL, ,(Sna@pshot)rx ^AddTopics(, roB'' Make t' for all occu`rrenc s+ m U"SELE0CT '$_' & id_ 8id, uregulartłq.& 'v . yt" _#"'7,$ ,
.displ ay& sort*Q
WHERE!instaOf@
K0sgNow mF queriesthe 'd atabase'
l@Empl oyee and Departmentk' ReQhose w ith your ownwhenA want F u
Acod C {"g5I''MC5"fZi|_b>S qlast#, G,GD:= , True䖲$dF5$'&%G~%$ _ _ V DUahs contained in KeI.$' T \rsbfollo wing fieldscis er,#[
Wbs:% - MAY E
'', be id of"whic.h@ H n
<>rolel_1 e e@ ^ refer !o USTmemb er dittHo '2''2'Fm a
D mapĎcS @].H.Wp:Q>a" oZ1q3 1oi . 2o2Mp"BholDo Untilŋ.EOF+$ ŬOj76For i0 To3.Cou- 1a30 RGȳ^oSa(T03/Al_F P'Jϯ3It_[B- OO_ (ONBRe?CU pO$u )"UxRI"K ._! FaO/ Tr TRa CU p o9-}o3?3%
}9 3}%e/~x nodRes Data.app endChild ( Txt)
Else:!bSet Ref =Occu@rrence ( dom.crea teElemen t("resource :")hd.setAtt ribute " xlink:hr ef", rstTemp .Fi elds(i).ValubEnd8 Ifr
SelectNexCHMoveLoop" 'SQL "SELECT d _of_b irth, sa lary " & _ "FROM loyeIT WHERE id_F
=BRig ht(topic _id, LenF) - 9) " ;"K Deb ug.Print> / C 6dbs.ORecordu( , dbSnapshoMDo UntDilzEOFKFor i 0 TBoτ.Cou'- 1K
MIf N ot IsNul l(o) Thenć@"@CtoFϖInsta@Oi&} T!@&{'"Gz "e z"#[0namz#D/1]#xt 'TNode9GF!_Ke Qߏˏ LVAL K
c/. '(Add":s "Tr! FunctiRo@e
e @A@ssociaAsa% As fo q@IXMLDO
M)BooleaoDimk+ ͇.jGh`r}FaJF$ӵ Cas eEhُ^"typelEҙqL5& F;~F D@00F1_("F FǃFM#2r)_1`e peuMemxbers("mb?MR c LSpec{ Q e _P 8 6 [ 0%v u0200Ѻ__Ts0͏0 N07_P0 00 ߏ k 0 uef_
0 0 1kߔQ{fl.
_ _ S R P _ 2 8 rU ~} u
a ! ) Q 1 Y q Y ! $ a% Y' # ( )) * # , - . . 0 0 A1 i2 2 4 4 i5 A6 6 7 i3 3 3 / / / 8 I8 8 8 !9 Y9 9 9 9 : Q: : : ; I; ; ; < I< < = A> > q? @ 9@ 9A aA A A B !B YB B B C D qD D E E E !F YF F F F H yL aM N N P \" $
Q\L :, < <:, < <:, < <:, < <:, < <:, < <:, < <:, < <:, < <:, <
5 _
<_
k/ 2_
$ :\>F 9) \5 D:\ *F < :, : 9\6
I\_
\
$ '':, N >F
\6 LVAL L \_
l\=< h\ Cd )d@, %L `5 +h` , Cd )d@, %L `5 +h` , Cd )d@, %L `5 +h` , Cd )d@, %L `5 +h` , Cd )d@, %L `5 +h` , *q r *#" *## *#$ *1d2 )d@, %L `5 +h` , % & *1d )d@, %L `5 +h` , ' ( *1d )d@, %L `5 +h` , <) * *#+ *#g *#- *#. *#/ *1d2
)d@, %L `5 h` 0 , <1 2 *#3 *#4 *#p *#6 *#o *1d2
)d@, %L `5 h` 0 ,
`
E'p''''' :,t N s F`%_
6 p` ken D , l ` d < L h H \ p `
h" $
Qhl `H
4 k` 8Xh: _
lh=; [\H
T ; lX=< t) h\X 2(( H`hH
h
= k`D8hh 4\HhH
h
0 > \
, ? >1 ) h\
l @ 0 \ @\HhH
h
0 > \
D ? @ t
< ) h\5 Y 8\HhH
h
0 > \
D ? `1d) h\5
l A 0 a =\HhH
h
0 > \
D ? B ) h\5 \ 4XhC _
lh=; [\t
T ; QX) h\ /hD _
Qho%E N5 S:(F %:8G \HhH
h
0 > \
D ? %H ) h\6
l I 0 s =\HhH
h
0 > \
D ? B ) h\5 n 4XhJ _
lh=; [\t
T ; QX) h\ /hK _
Qho%E N5 OX\HhH
h
0 > \
D ? `#_
QX/) h\5 % LVAL M E l L 0 l M 0 =\HhH
h
0 > \
D ? B ) h\5 /hN _
Qho%E N5 /hO _
Qho%E pN5 /hD _
Qho%pE N5 <\HhH
h
0 > \
, ? lL 0/) h\ :8F %:(P %H :8F %:(Q %H /hR _
Qho%E `N5 /hS _
Qho%`E PN5 OX\HhH
h
0 > \
D ? `#_
QX/) h\5 %PE / H~ IT U *#V *#LW *#HX *#Dld*#@Y *#<Z *F,2 LHD@< :h,9h 5h'%'%8 %,l
[ Qhp/6 `p
4 k`
4Xh\ _
lh=; [\t
T ; QX ) h\ 2(( H`hp
h
= k`D8hh 4\Hhp
h
0 > \
, ? >1) h\
l] 0 =\Hhp
h
0 > \
D ? B ) h\5 /hC _
Qho% E N5 /hD _
Qho%E N5 S:(F %:8G \Hhp
h
0 > \
D ? %H ) h\6
l^ 0 =\Hhp
h
0 > \
D ? B ) h\5 } A\Hhp
h
0 > \
D ? :8_ ]/) h\5\r pb { pb
l` 0 =\Hhp
h
0 > \
D ? B ) h\5 kb f /hS _
Qho% E PN5 OX\Hhp
h
0 > \
D ? `#_
QX/) h\5 %PE /ha _
Qho% E N5 F:8F %\Hhp
h
0 > \
D ? %H ) h\5 / H~
p
0 Mc d *#e *FldJ dM8@
b :(f ,/6 :h,9h 5h'%'%8 %,l
[ Qhp/6 `p
4 k` 2(( H`hp
h
= k`D8hh =\Hhp
h
0 > \
D ? B ) h\5 4Xh\ _
lh=; [\t
T ; QX ) h\ /hC _
LVAL N Qho% E N5 /hD _
Qho%E N5 P:8F %G \Hhp
h
0 > \
, ? l*F%H /) h\5 /hS _
Qho% E PN5 OX\Hhp
h
0 > \
D ? `#_
QX/) h\5 %PE H~
p
H
pz p P H p , t p l ` d @
L H D @ < h \ X H rH
4 kr 4dlh _
ll=; [hH
T ; QdT) lh 2($ DrlH
l
= krD4lh 4 hDlH
l
0 > h
, ? > 1) lh
l] 0 =hDlH
l
0 > h
D ? B ) lh5 /lC _
Qlo%TE N5 /lD _
Qlo%E N5 S:$F %:4G hDlH
l
0 > h
D ? %H ) lh6
li 0 =hDlH
l
0 > h
D ? B ) lh5 /lj _
Qlo%TE N5 /lk _
Qlo%E N5 /lD _
Qlo%E N5 S:$F %:4G hDlH
l
0 > h
D ? %H ) lh6
ll 0 =hDlH
l
0 > h
D ? B ) lh5 /lD _
Qlo%E N5 S:$F %:4G hDlH
l
0 > h
D ? %H ) lh6
lm 0 =hDlH
l
0 > h
D ? B ) lh5 /lj _
Qlo%TE N5 /lk _
Qlo%E N5 /lD _
Qlo%E N5 S:$F %:4G hDlH
l
0 > h
D ? %H ) lh6
ln 0 =hDlH
l
0 > h
D ? B ) lh5 /lD _
Qlo%E N5 S:$F %:4G hDlH
l
0 > h
D ? %H ) lh6 / D~{
5LVAL A H
pz c L 4
D T t $ l h d a _ _ S R P _ 3 rU $ ` @ ` =a = 8 ` =a = p LVAL, żŒhh>>ĖĖĖĖĖĖĖĖllBB KKD
AccessVersion Build AppTitle StartUpForm StartUpShowDBWindow StartUpShowStatusBar StartUpMenuBar AllowShortcutMenus AllowFullMenus\
07.53
Switchboard KKD
AccessVersion Build AppTitle StartUpForm StartUpShowDBWindow StartUpShowStatusBar StartUpMenuBar KKD KeepLocal
TKKD KeepLocal
TKKD KeepLocal
TKKD KeepLocal
TKKD KeepLocal
TKKD KeepLocal
TKKD KeepLocal
TKKD KeepLocal
TKKD KeepLocal
TKKD KeepLocal
TKKD KeepLocal
TKKD KeepLocal
TKKD ValidationRule ValidationText Filter OrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden Description Format Caption InputMask DefaultValue Required AllowZeroLength DisplayControl @ id_association_type M
name
m T role_type_1
m T role_type_2
m LVAL @ @ @ @ @ @ @ @ @ @ @ @ s s s s s s s s s
s s s s s s s s s s s s s! s" s# s$ s% s& s'
s(
s)
s* s+ s, s- s. y y
y
y
y y y y y y y
y y y
y y y y y y y# y$ y% 6 6 y& y y y y y y y y y y y y y y! y" 6 6 6 6 6 6 6 6 s s s s s s s
s s s s s KKD L ValidationRule ValidationText Filter OrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden Description Format Caption
DecimalPlaces InputMask DefaultValue Required DisplayControl
RowSourceType RowSource BoundColumn ColumnCount ColumnHeads ColumnWidths ListRows ListWidth LimitToList AllowZeroLength :
id_department I id_employee
manager
0
o
Table/Queryu m SELECT DISTINCTROW [employee].[id_employee], [employee].[last_name], [employee].[first_name] FROM [employee];
0;1440;1440
2880twip M
name
m LVAL W i _ V B A _ M O D U L E 0 @DH7a8 yRK.(a ͕H " * \ R f f f f * 8 3 e 4 7 b 6 6 6 * \ R 2 * # 2 8 * \ R 2 * # 2 d * \ R 1 * # 2 e * \ R 1 * # 8 e * \ R 1 * # 8 f * \ R 1 * # 8 5 ( $ ` |k p iH
` p 0k ` k / / @ B x@ $ t` $ `p `H n ` N i i B i i @ B @" B @$ B @& B @( B @* B @, B @.H B @0 B ` x $ t( $ LVAL S < d:
x D)?d:d:Hd:Pd:%
2d:jd:d:d:d: d:Xd:xd:d:d:@d:@d:@d:@d:@d:2d:jd:d:d:d:
2 1Switchboard Items.SwitchboardID Switchboard Items Switchboard Items.ItemNumberSwitchboard Items.ItemTextSwitchboard Items.CommandSwitchboard Items.Argumentd:d:d:d:
d:
c@d:d:
2d:H,
jd:H, d:H, d:H, d:H, Switchboard ItemsXd:d:@d: x d:d:)Bc@~sq_fSwitchboardd: d:d: Xd:d: xd:d: d:d: d:d: d:Xd:xd:d:d:2d:H,
jd:H, d:H, d:H, d:H, Switchboard Items 2d: d: jd:(d: d:0d: d:8d: d:@d: d:Xd:xd:d:d:
d:`d:
d: d:@d:Xd:pd:d:d:Hd:
d:Hd:
d:Hd:
d:Hd:
d:Hd:
d:Hd:
d:Hd:
d:Hd:
d:Hd:
d:Hd:
d:Hd:
d:Hd:
d:Hd:
d:Hd:
d:Hd:
d:Hd:
d:Hd:
d:Hd:
d:Hd:
d:Hd:
d:Hd:
d:Hd:
d:Hd:
d:Hd:
d:Hd:
d:Hd:
d:Hd:
d:Hd:
d:Hd:
d:Hd:d:d:d: d:d:x d: d:x d: d:x d:
d:x d: d:x d:
|d: d:@d:d:P,d: d: d:
d: d:
d: d:
d:H d:
d: d: d:
d: d:
H d:<`d:hd:pd:xd:d: d: d: d: d:H d:x d:Switchboard Itemsd:PrimaryKeyd:d:vLVAL 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:0d: Hd:@d: d:d:Pd:Switchboard Items
PrimaryKeyd:Pd:d:
d:d:d:`d:@d:d:@d:pd:x d: . ~o`\M>:+ xences?7
rstTempOcc% topic_id\ occ_data
nodOccurrenceB nodResRef nodRes$ ( AddAssociations nodAssociation# nodMember nodRole
_B_var_prolog,
_B_var_rootEl _B_var_x _B_var_nodInstanceOf} _B_var_nodTopicRef_
_B_var_SQL3 _B_var_nodOccurrence _B_var_nodResRef8 _B_var_nodAssociations; _B_var_nodMemberr _B_var_nodRole debog _B_var_debog Right
_B_var_Right9 tmF_ tk _B_var_tm xlink> href Sort topicmapsG org core psi^ display operatm! xmlns rec re^ occurrence_type `
.
.
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o .
-
-
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o -
,
,
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ,
+
+
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o +
*
*
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o *
)
)
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o )
( ( ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ( ' ' ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ' LVAL N ĖĖĖĖĖĖĖĖllB- .
c@
c@ 0 2 =Bb
c e
g hijk+k ,[ItemNumber] = 0 AND [Argument] = 'Default' .Bc@Switchboard Items Switchboard[Event Procedure][Event Procedure]Arial d 2 e 12 bRcRf bg 2 3 7bch bcg h
MS Sans Serif ` Detail d 5]8`8ae b:cd Label2 tm-extensionTimes New Romanh 1U`Yabcg
Option1=HandleButtonClick(1)Systemd 5U`abc OptionLabel1=HandleButtonClick(1)h 1U`YaQbcg
i Option2=HandleButtonClick(2)Systemd 5U`aQbc OptionLabel2=HandleButtonClick(2)h 1U`Yabcg
i Option3=HandleButtonClick(3)Systemd 5U`abc OptionLabel3=HandleButtonClick(3)h 1U`Yabcg
i Option4=HandleButtonClick(4)Systemd 5U`abc OptionLabel4=HandleButtonClick(4)h 1U`Ya=
bcg
i Option5=HandleButtonClick(5)Systemd 5U`a=
bc OptionLabel5=HandleButtonClick(5)h 1U`Ya bcg
i Option6=HandleButtonClick(6)Systemd 5U`a bc OptionLabel6=HandleButtonClick(6)h 1U`Ya
bcg
i Option7=HandleButtonClick(7)Systemd 5U`a
bc OptionLabel7=HandleButtonClick(7)h 1U`Ya)bcg
i Option8=HandleButtonClick(8)Systemd 5U`a)bc OptionLabel8=HandleButtonClick(8)d 58`a8 b:cd Label1 tm-extensionTimes New Romanf 3U5abZHorizontalDividingLined 5U` abcdLabel22aCopyright Marc de Graauw 2003.
This database and its contents, sample code included, are meant for demonstration purposes only. This code is no production-quality code. Permission is granted to use this database and the sample code to all in all perpetuity, provided the author will not be held responsible in any way of the consequences of such use.LVAL @k(x=Ċ%NNy!AA= @ @ @ 9.
c@
c@ ~sq_fSwitchboard* @*O ===1111111/ @ * 9rc@\8rc@ ~sq_cemployee~sq_cassociationsx * @ O WWWK??????= ` ) 9rc@9rc@ ~sq_cemployee~sq_coccurrence_type subform~ * @O bbbVJJJJJJH ` {QZc@{QZc@ ~sq_ctopic_type~sq_ctopic Subform * @
O ZZZNBBBBBB@ ` ,Yc@,Yc@ ~sq_fdepartment * @O HHH<000000. ` ,Yc@,Yc@ ~sq_cdepartment~sq_cid_employee * @O XXXL@@@@@@> ` Yc@Yc@ ~sq_cdepartment~sq_cemployee Subform * @O ]]]QEEEEEEC ` $/Bc@bǻbc@ Switchboard,,,,,,,,,,* X(Bc@)Bc@ Switchboard Items @ >>>22222220 @ ڧq\@\K^@ association_type @ O ===1111111/ @ #g^@~+Nc@ topic_type @v LWF000 @ ~ UI77++++++) m1q\@hD `@ employee Subformv @| LWF000 @ } [O==111111/ -ܸq\@-ܸq\@ SummaryInfoB @u 888,,,,,,,* @ is\@is\@ Reference4++++++++++) cq\@cq\@ Reference2++++++++++) a>\q\@a>\q\@ Reference1+++++ ͬ yRK.(a Detail SwitchboardID ItemNumber ItemText Command Argument d
Label2 h Option1 h
Option2 h Option3 h Option4 h
Option5 h Option6 h Option7 h Option8 d
Label1 f HorizontalDividingLine d
OptionLabel1 d
OptionLabel2 d
OptionLabel3 d
OptionLabel4 d
OptionLabel5 d
OptionLabel6 d
OptionLabel7 d
OptionLabel8 d
Label22 LVAL t 0 $ J $ $ $ J@ $ p $ 0 $ J $ $ P $ J $ $ p X ( p @ @X x @ h @d @ T @D @4 @0 ( h ( @ p " @ h @ X @T p @ R @P X " @L @h < % @ , @ @ @ @ X 0 X x ME " < B P 8
{ / WD1 W%sB%
ub@- . Switchboard Items . G. . - occurrence_type - G- - , Wi association_type , G, Wi , Wi + G+ employee + department + departmentemployee1 @ * + id& @
o+ department.name' g+ employee.salary' g+ employee.date_of_birth. g+ employee.first_name+ g+ employee.last_name* g+ + * ([__id] = member_1)+ '* __id O* employee @ 7* G* * ) ([__id] = id_topic)+ ') __id O) employee @ 7) G) ) LVAL 555ŭ]u=Dq DC3B BOA & bc@bc@ employee''''''''''' bc@bc@ department))))))))))) . hq\@,3^@ association @u 888,,,,,,,* @ Yq\@Ic@ all_topics @u @z C77+++++++) @
!]'q\@펋s\@ Admin4 @ 2&&&&&&&&&$ o_@.Ƹc@ XTM$$$$$$$$$$" . (g^@~+Nc@ topic SubformM @| LWF000R @} XL::......, VJ_@f=_@ occurrence_type subform88888888886 .
q\@B*_@ employee @ | LWF000 @ { SG55))))))' |1q\@H `@ department< @v LWF000 @ z UI77++++++)
.
֖"_KKD
AccessVersion Build AppTitle StartUpForm StartUpShowDBWindow StartUpShowStatusBar StartUpMenuBar AllowShortcutMenus AllowFullMenus AllowBuiltInToolbars AllowToolbarChanges AllowBreakIntoCode AllowSpecialKeys AppIcon StartupShortcutMenuBar
07.53
Switchboard
KKD ValidationRule ValidationText Filter OrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden Description Format Caption InputMask DefaultValue Required AllowZeroLength DisplayControl
DecimalPlaces 8 id_employee R last_name
m S
first_name
m C
date_of_birth
X salary 0
m _
id_department 0
m / @ gruo,rbbxuufpbfv 5gruo,v{jwbiar`ud 5ov}vda 5|wo 5 5ov}vda 5|wo 5 5ov}vda 5|wo 5 5|wo 5 <_@ =_@ ~sq_coccurrence_type subform~sq_cid_topic * @<& bbbVJJJJJJH ` \ <_@<_@ ~sq_coccurrence_type subform~sq_coccurrence typeK * @:& iii]QQQQQQO ` [ o_@__@ XTM$$$$$$$$$$" = VJ_@f=_@ occurrence_type subform88888888886 < _@_@ ~sq_fassociation_type * @ NNNB6666664 ` ; R_@R_@ ~sq_cassociation_type~sq_cassociation Subform
* @ fffZNNNNNNL ` : k"_@k"_@ ~sq_fassociation Subformj s * @ QQQE9999997 ` 9 $ "_@$ "_@ ~sq_cassociation Subform~sq_cmember_1 * @ ^^^RFFFFFFD ` 8 z"_@Y"_@ ~sq_cassociation Subform~sq_cmember_2 * @ _
_
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o _
^
^
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ^
]
]
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ]
\
\
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o \ _
PrimaryKey___ __ _P _ _ _ _P _ _ _ ___ VC N \ \
2
2
id_occurrence
instanceOfid_topicresource mor\ ^ rn_poueey\ _ \ ` **\ a
id_occurrenceid_occurrence_typeid_topic
PrimaryKey {qg @ b[ ZA& jQ
@ @ @ @ @ `vvrbj`wjrp `vvrbj`wjrpvxagruo `vvrbj`wjrp,w}sf `vvrbj`wjrpv dfs`uwofpw fosmr}ff fosmr}ffvxagruo rbbxuufpbf,w}sfvxagruo wrsjbvxagruo wrsjb,w}sf |wo `dojp d`w`a`vfv gruov ordxmfv ufm`wjrpvijsv ufsruwv
vbujswv v}vufm w`amfv `mm,wrsjbv `vvrbj`wjrp `vvrbj`wjrp,w}sf dfs`uwofpw fosmr}ff ov}v`bfv ov}vordxmfv . ov}vordxmfvX . ov}vrakfbwv ov}vtxfujfv ov}vufm`wjrpvijsv `bbfvvm`}rxw
ov}vda vxoo`u}jpgr xvfudfgjpfd employee_5Yes employee_5C:\pictures\helenahunter.jpg/
employee_4Yes employee_35 employee_3C:\reviews2002\Annual review Joe Jenkins.rtf?
employee_12 employee_2C:\reviews2002\Annual review Sally Jones.rtf? employee_2Yes employee_1C:\reviews2002\Annual review John Smith.rtf> employee_1No employee_6Yes employee_62 employee_6C:\reviews2002\Annual review Susan Smith.rtf? employee_6C:\pictures\susansmith.jpg- employee_6http://www.susansmith.nl+ [ @ @ ] ] ] ] ] ] ] ] ]
] ]
]
] ]
] [ @ @ ] ] ] ] ]
] ]
] ] ] ] ] ] ] ]Type
DateCreate
DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtra
Id ParentIdName
ions5 * @& JJJ>2222220 ` G LVJ (_@(_@ ~sq_fassociations5 * @& JJJ>2222220 `J (_@(_@ ~sq_fassociations5 * @& JJJ>2222220 ` ' ,Ss\@?rc@ AccessLayout* @d @4 E99-------+ @& is\@is\@ Reference4++++++++++) eZ9s\@bx_@ occurrence_type @ <<<0000000. @ 嶸Ps\@&|G^@ association @| LWF0004 @ VJ88,,,,,,* b6s\@)_@ associations @ LWF000 WK99------+ cq\@cq\@ Reference2++++++++++) X hq\@,3^@ association @ 888,,,,,,,* @ T ڧq\@\K^@ association_type @ ===1111111/ @ q\@B*_@ employee @
LWF000 @ SG55))))))' Yq\@Ic@ all_topics - @[& @ OCC7++++++) ` [ fosmr}ff,W ]fosmr}ff,W ]fosmr}ff,W ] fosmr}ff,X ]fosmr}ff,X ]fosmr}ff,Y ]
fosmr}ff,Y ] fosmr}ff,Z ] fosmr}ff,[ ]
fosmr}ff,[ ]fosmr}ff,\ ] fosmr}ff,\ ]fosmr}ff,\ ]fosmr}ff,\ ]fosmr}ff,\ ] [ @ @ ] ] ] ] ] ] ] ] ]
] ]
]
] ]
] VC ( N c c
2
2 id_occurrence_typenamedatatype * c e * *c f id_occurrence_type
PrimaryKey {q @ bb v @ @ @ @ @ @ @ `vvrbj`wjrp `vvrbj`wjrpvxagruo `vvrbj`wjrp,w}sf `vvrbj`wjrpv dfs`uwofpw fosmr}ff fosmr}ffvxagruo rbbxuufpbf,w}sfvxagruo wrsjbvxagruo wrsjb,w}sf |wo `dojp d`w`a`vfv gruov ordxmfv ufm`wjrpvijsv ufsruwv
vbujswv v}vufm w`amfv `mm,wrsjbv `vvrbj`wjrp `vvrbj`wjrp,w}sf dfs`uwofpw fosmr}ff ov}v`bfv ov}vordxmfv . ov}vordxmfvX . ov}vrakfbwv ov}vtxfujfv ov}vufm`wjrpvijsv rbbxuufpbf . `bbfvvm`}rxw
ov}vda vxoo`u}jpgr xvfudfgjpfd Attends New Year Party?Boolean# ChildrenInteger
PictureURI Annual review 2002URI Home pageURIb d d d d d b d d d d d
IdParentIdNameType
DateCreate
DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtra
Id ParentIdName
ions5 * @& JJJ>2222220 ` G LVJ (_@(_@ ~sq_fassociations5 * @& JJJ>2222220 `J (_@(_@ ~sq_fassociations5 * @& JJJ>2222220 ` ' ,Ss\@?rc@ AccessLayout* @d @4 E99-------+ @& is\@is\@ Reference4++++++++++) eZ9s\@bx_@ occurrence_type @ <<<0000000. @ 嶸Ps\@&|G^@ association @| LWF0004 @ VJ88,,,,,,* b6s\@)_@ associations @ LWF000 WK99------+ cq\@cq\@ Reference2++++++++++) X hq\@,3^@ association @ 888,,,,,,,* @ T ڧq\@\K^@ association_type @ ===1111111/ @ q\@B*_@ employee @
LWF000 @ SG55))))))' Yq\@Ic@ all_topics - @[& @ OCC7++++++) ` VC N h h
*2
2
*2 id_topic
instanceOfname displaynamesortname **h j **h k ***h l id_topic
id_topic_type
PrimaryKey S {qg g c"jM. @ @ @ @ @ @ @ `vvrbj`wjrp `vvrbj`wjrpvxagruo `vvrbj`wjrp,w}sf `vvrbj`wjrpv dfs`uwofpw fosmr}ff fosmr}ffvxagruo rbbxuufpbf,w}sfvxagruo wrsjbvxagruo wrsjb,w}sf |wo `dojp d`w`a`vfv gruov ordxmfv ufm`wjrpvijsv ufsruwv
vbujswv v}vufm w`amfv `mm,wrsjbv `vvrbj`wjrp `vvrbj`wjrp,w}sf dfs`uwofpw fosmr}ff ov}v`bfv ov}vordxmfv . ov}vordxmfvX . ov}vrakfbwv ov}vtxfujfv ov}vufm`wjrpvijsv rbbxuufpbf . rbbxuufpbf,w}sf . `bbfvvm`}rxw
ov}vda vxoo`u}jpgr xvfudfgjpfd DEGermanyGermany FRFranceFrance RD-DESIGNRelational Database DesignRelational Database DesignF, ONTOLOGYOntology MasterclassOntology Masterclass9% UKUnited KingdomUnited Kingdom' USUnited States of AmericaUnited States of America;# NLThe NetherlandsNetherlands% XMLOne Day of XMLXML, One Day of) TOPICMAPSThe Art of Topic MapsArt of Topic Maps, The=' g @ i i i i i i i i i g @ i i i i i i i i i
IdParentIdNameType
DateCreate
DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtra
Id ParentIdName
ions5 * @& JJJ>2222220 ` G LVJ (_@(_@ ~sq_fassociations5 * @& JJJ>2222220 `J (_@(_@ ~sq_fassociations5 * @& JJJ>2222220 ` ' ,Ss\@?rc@ AccessLayout* @d @4 E99-------+ @& is\@is\@ Reference4++++++++++) eZ9s\@bx_@ occurrence_type @ <<<0000000. @ 嶸Ps\@&|G^@ association @| LWF0004 @ VJ88,,,,,,* b6s\@)_@ associations @ LWF000 WK99------+ cq\@cq\@ Reference2++++++++++) X hq\@,3^@ association @ 888,,,,,,,* @ T ڧq\@\K^@ association_type @ ===1111111/ @ q\@B*_@ employee @
LWF000 @ SG55))))))' Yq\@Ic@ all_topics - @[& @ OCC7++++++) ` g @ i i i i i i i i i VC N n n
2
id_topic_typename n p n q
id_topic_type
PrimaryKey {q m @ @ @ @ @ @ @ @ `vvrbj`wjrp `vvrbj`wjrpvxagruo `vvrbj`wjrp,w}sf `vvrbj`wjrpv dfs`uwofpw fosmr}ff fosmr}ffvxagruo rbbxuufpbf,w}sfvxagruo wrsjbvxagruo wrsjb,w}sf |wo `dojp d`w`a`vfv gruov ordxmfv ufm`wjrpvijsv ufsruwv
vbujswv v}vufm w`amfv `mm,wrsjbv `vvrbj`wjrp `vvrbj`wjrp,w}sf dfs`uwofpw fosmr}ff ov}v`bfv ov}vordxmfv . ov}vordxmfvX . ov}vrakfbwv ov}vtxfujfv ov}vufm`wjrpvijsv rbbxuufpbf . rbbxuufpbf,w}sf . wrsjb . `bbfvvm`}rxw
ov}vda vxoo`u}jpgr xvfudfgjpfd Country Course m o o m o o
IdParentIdNameType
DateCreate
DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtra
Id ParentIdName
ions5 * @& JJJ>2222220 ` G LVJ (_@(_@ ~sq_fassociations5 * @& JJJ>2222220 `J (_@(_@ ~sq_fassociations5 * @& JJJ>2222220 ` ' ,Ss\@?rc@ AccessLayout* @d @4 E99-------+ @& is\@is\@ Reference4++++++++++) eZ9s\@bx_@ occurrence_type @ <<<0000000. @ 嶸Ps\@&|G^@ association @| LWF0004 @ VJ88,,,,,,* b6s\@)_@ associations @ LWF000 WK99------+ cq\@cq\@ Reference2++++++++++) X hq\@,3^@ association @ 888,,,,,,,* @ T ڧq\@\K^@ association_type @ ===1111111/ @ q\@B*_@ employee @
LWF000 @ SG55))))))' Yq\@Ic@ all_topics - @[& @ OCC7++++++) ` c g"wu Reference4occurrenceinstanceOfoccurrence_typeid_occurrence_typeL:+!
Reference2associationinstanceOfassociation_typeid_association_typeO<,"
Reference1topicinstanceOftopic_typeid_topic_type=0&
Referencedepartmentid_employeeemployeeid_employee>3+
departmentemployeeemployeeid_departmentdepartmentid_departmentK>4'
/ o`QB qbO@1"s `QB ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o LVAL w " : Y 0 P X " ` 6 h * 6 4 8 @ p . A " A
4 0 0 h * D J & + H : ` D < 2 8 @ O P & O p , b
,
( 8 B @ 8 H 2 8 0 @ P ` & p 4 8 0 * . @ F e p B B +
X
h x
" < 5
(
Y 0
P
h
Y p
I
"
4
0 ( X ` 2 O 8
Y 0 8 X ` h D *
+
(
, 0
`
p
2
4
( $ 0 @ H 8 + P x 0 6 Minimize the database window and initialize the form. LVAL ǔ
@ @ @ @ @ KKD
AccessVersion Build AppTitle StartUpForm StartUpShowDBWindow StartUpShowStatusBar StartUpMenuBar AllowShortcutMenus AllowFullMenus AllowBuiltInToolbars AllowToolbarChanges AllowBreakIntoCode AllowSpecialKeys AppIcon
07.53
Switchboard
KKD L ValidationRule ValidationText Filter OrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden Description Format Caption
DecimalPlaces InputMask DefaultValue Required DisplayControl
RowSourceType RowSource BoundColumn ColumnCount ColumnHeads ColumnWidths ListRows ListWidth LimitToList AllowZeroLength ; id_association
instanceOf
0
o
Table/Query association_type
0;1440
1440twip / member_1
member_1
o
Table/Queryi a SELECT DISTINCTROW [all_topics].[id], [all_topics].[type], [all_topics].[name] FROM [all_topics];
0;0;1442
4320twip / member_2 2
member_2
o
Table/Queryi a SELECT DISTINCTROW [all_topics].[id], [all_topics].[type], [all_topics].[name] FROM [all_topics];
0;0;1441
4320twip KKD G ColumnWidth ColumnHidden RecordLocks ODBCTimeout
MaxRecords
< # id 7 %
name B KKD Title Author Company
tm-extensionKKD KeepLocal
TLVAL
ͬ 0+!Gt MpQ˙ FormHeader Detail m name d name_Label name Label p topic_Subform topic Subform FormFooter id_topic_type d
Label4 ͬ
DV`D { FormHeader ͬ 0+!Gt MpQ˙ FormHeader ͬ Iku9LI4u. FormHeader Detail m last_name d last_name_Label last_name Label m first_name d first_name_Label first_name Label m date_of_birth d date_of_birth_Label date_of_birth Label m salary d salary_Label salary Label m
name d name_Label name Label m Text10 d
Label11 p associations p occurrence_type_subform occurrence_type subform d
Label18 d
Label19 FormFooter id ͬ 0+!Gt MpQ˙ FormHeader Detail m name d name_Label name Label p topic_Subform topic Subform FormFooter id_topic_type d
Label4 ͬ
DV`D { FormHeader Detail m name d name_Label name Label o id_employee d id_employee_Label id_employee Label p employee_Subform employee Subform d
employee_Subform_Label employee Subform Label FormFooter id_department ͬ
)vlT@h FormHeader d
name_Label name Label d
id_association_Label id_association Label d
id_association_type_Label id_association_type Label d
member_1_Label member_1 Label d
member_2_Label member_2 Label Detail o instanceOf d Label16 o member_1 d
Label17 o member_2 d Label18 m
role_type_1 d Label19 m role_type_2 d Label20 FormFooter LVAL { < Move to the switchboard page that is marked as the default. , [ItemNumber] = 0 AND [Argument] = 'Default' ( ( l 4 Update the caption and fill in the list of options. " $ ( A@ l / Fill in the options for this switchboard page. # The number of buttons on the form. Z Z ( Z H Z h Z / Set the focus to the first button on the form, - and then hide all of the buttons on the form 9 but the first. You can't hide the field with the focus. "B@. Option $ ( OptionLabel $ ( . Open the table of Switchboard Items, and find * the first item for this Switchboard Page. $ . ! SELECT * FROM [Switchboard Items] ' , WHERE [ItemNumber] > 0 AND [SwitchboardID]= " ' ORDER BY [ItemNumber]; ' % . 3 If there are no options for this Switchboard Page, = display a message. Otherwise, fill the page with the items. ! , There are no items for this switchboard page "( a ! Option " $ ( OptionLabel " $ ( " OptionLabel " $ ( B@ h & Close the recordset and the database. B@B B@B l 2 This function is called when a button is clicked. + intBtn indicates which button was clicked. 1 Constants for the commands that can be executed. Z Z 0 Z H Z ` Z x Z Z Z An error that is special cased. Z Z Z 2@ - Find the item in the Switchboard Items table 1 that corresponds to the button that was clicked. $ . c LVAL o @ @ @ @ @ 0=Bb
c e
g hz
i jw.k (_@SELECT association.instanceOf, association.member_1, association.member_2, association_type.role_type_1, association_type.role_type_2 FROM association_type INNER JOIN association ON association_type.id_association_type = association.instanceOf; associationsArial d 2 e 12 bRcRf 5bg 2 3 7bch bcg h
MS Sans Serifi 1g hj 1g hk 1bcl 23 : bc g[m 4bg[ n 2cdh[ o 2ej[ p 5bcr 35cd z bci j
MS Sans Serif{ 5 bcJ
`b
FormHeader d 5U7`9 a9 b<c
name Labelname
DetachedLabel
name_Labeld 5U7`a9 bc id_association Labelid_association
DetachedLabelid_association_Labeld 5U7` a9 b<c id_association_type Labelid_association_type
DetachedLabelid_association_type_Labeld 5U7` a9 b<c member_1 Labelmember_1
DetachedLabelmember_1_Labeld 5U7`~a9 b9c member_2 Labelmember_2
DetachedLabelmember_2_Label `l Detail o 5U` bcdhi "";"";"";"";"10";"50"
instanceOf
instanceOf Table/QueryeSELECT DISTINCTROW association_type.id_association_type, association_type.name FROM association_type;0;1440d 5U`
abc Label16association typeo 5U` bcdRh'i n "";"";"";"";"";"";"10";"0"member_1member_1 Table/QueryaSELECT DISTINCTROW [all_topics].[id], [all_topics].[type], [all_topics].[name] FROM [all_topics];0;0;1442d 5U`
aRbWc Label17membero 5U` bcdh2
i n "";"";"";"";"";"";"10";"0"member_2member_2 Table/QueryaSELECT DISTINCTROW [all_topics].[id], [all_topics].[type], [all_topics].[name] FROM [all_topics];0;0;1441d 5U`
abc Label18memberm 7U`a e9f k role_type_1 role_type_1d 5U`
a bc Label19rolem 7U`aTef k role_type_2 role_type_2d 5UaTbc Label20role `
FormFooterK ' ~ok\MI:+' xteVRC4 ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o uLVAL + @ @ @ @ @ @ s s s s s s s s s
s s s s s s s s s s s s s! s" s# s$ s% s& s'
s(
s)
s* s+ s, s- s. y s s s s s s s
s s s s s ( Y
0 =Bb
c e
g h
ij-k8 |1q\@
department
departmentArial d 2 e 12 bRcRf 5bg 2 3 7bch bcg h
MS Sans Serifi 1g hj 1g hk 1bcl 23 : bc g[m 4bg[ n 2cdh[ o 2ej[ p 5bcr 35cd z bci j
MS Sans Serif{ 5 bcJ
`
FormHeader `[ Detail m 7U`ar b c e namenamed 5U`9 ar bc
name Labeldepartment name
name_Labelo 5U` b@ cde f h n "";"";"";"";"";"";"10";"50" id_employee id_employee Table/QuerymSELECT DISTINCTROW [employee].[id_employee], [employee].[last_name], [employee].[first_name] FROM [employee]; 0;1440;1440d 5U`9 abc id_employee Labelmanagerid_employee_Labelp 3W`9 ab~ cd employee SubformForm.employee Subform
id_department
id_departmentemployee_Subformd 5]`< abfc employee Subform Label employeesemployee_Subform_Label `
FormFooter LVAL Switchboard Items 4 % . [SwitchboardID]= " AND [ItemNumber]= B@6 < If no item matches, report the error and exit the function. ! 8 7 There was an error reading the Switchboard Items table. A@6 B@B B@B s h x " Go to another switchboard. H Q % [ItemNumber] = 0 AND [SwitchboardID]= " ( Open a form in Add mode. "H Q " < 0B@:
Open a form. $H Q " 0B@: Open a report. &H Q " @ 0B@> Customize the Switchboard. (H Q . Handle the case where the Switchboard Manager ) is not installed (e.g. Minimal Install). WZMAIN80.sbm_Entry ZB@B 8 F Command not available.A@6 g @ Update the form. , [ItemNumber] = 0 AND [Argument] = 'Default' ( " $ ( A@ Exit the application. *H Q A@D
Run a macro. ,H Q " 0B@F
Run code. .H Q " ZB@B # Any other command is unrecognized. P Unknown option. A@6 k & Close the recordset and the database. B@B B@B Hx s p 2h , If the action was cancelled by the user for - some reason, don't display an error message. " Instead, resume on the next line. 8 0 a ) There was an error executing the command. nA@6 Hp h h f ` X Attribut e VB_Nam e = "For m_Switch board"
Bas0{8 A791F19- 52A1-4BA A-8613-2 E281761FC1E}
|Cre atablTrue ]Predecla Id "@Expose Fals
@Temp lateDeriv%Custom izD$Option Comp @ DTv
P&* Sub Open(Ca ncel As Integer)
' Mini-e the d" window and tiPalizf.M2 ov o s pag at is ma$rknas2ef0ault "!Me.Filter [ItemNumber]0 A ND [ArLVAL Ȋ===== ͬ iGFl Detail FormHeader FormFooter m id_association_type d
id_association_type_Label id_association_type Label mͬ 6ô Bct2 FormHeader d
id_association_tyͬ /dhF2 C< FormHeader d
id_occurrence_type_Label id_occurrence_type Label d
name_Label name Label d
datatype_Label datatype Label Detail m id_occurrence_type m name o datatype FormFooter ͬ /dhF2 C< FormHeader d
id_occurrence_type_Label id_occurrence_type Label d
name_Label name Label d
datatype_Label datatype Label Detail m id_occurrence_type m name o datatype FormFooter ͬ 6ô Bct2 FormHeader d
id_association_type_Label id_association_type Label d
name_Label name Label d
role_type_1_Label role_type_1 Label d
role_type_2_Label role_type_2 Label Detail m id_association_type m name m role_type_1 m role_type_2
FormFooter ͬ iLPߓF FormHeader d
instanceOf_Label instanceOf Label d
name_Label name Label d
displayname_Label displayname Label d
sortname_Label sortname Label Detail m name m displayname m sortname FormFooter
id_topic instanceOf ͬ
]Eb iҘ Detail FormHeader FormFooter m last_name d
last_name_Label last_name Label m first_name d
first_name_Label first_name Label m date_of_birth d
date_of_birth_Label date_of_birth Label m salary d
salary_Label salary Label id_employee id_department LVAL ` 0=Bb
c5%e
g hi j,k\
(g^@topic
topic SubformArial d 2 e 12 bRcRf 5bg 2 3 7bch bcg h
MS Sans Serifi 1g hj 1g hk 1bcl 23 : bc g[m 4bg[ n 2cdh[ o 2ej[ p 5bcr 35cd z bci j
MS Sans Serif{ 5 bcJ
`b
FormHeader d 5U7`9 a9 b c instanceOf Label
instanceOf
DetachedLabelinstanceOf_Labeld 5U7`x a9 b c
name Labelname
DetachedLabel
name_Labeld 5U7`a9 b c displayname Label displayname
DetachedLabeldisplayname_Labeld 5U7`a9 b c sortname Labelsortname
DetachedLabelsortname_Label `q Detail m 7U`x a9 b c enamenamem 7U`a9 b c eB k displayname displaynamem 7U`a9 b c eB k sortnamesortname `
FormFooter 0=Bb
c e
g hYij k m1q\@employeeemployee SubformArial d 2 e 12 bRcRf 5bg 2 3 7bch bcg h
MS Sans Serifi 1g hj 1g hk 1bcl 23 : bc g[m 4bg[ n 2cdh[ o 2ej[ p 5bcr 35cd z bci j
MS Sans Serif{ 5 bcJ
`b
FormHeader d 5U7`9 a9 b c last_name Label last_name
DetachedLabellast_name_Labeld 5U7`x a9 b c first_name Label
first_name
DetachedLabelfirst_name_Labeld 5U7`a9 bc date_of_birth Label
date_of_birth
DetachedLabeldate_of_birth_Labeld 5U7`a9 b c salary Labelsalary
DetachedLabel salary_Label `q Detail m 7U`9 a9 b c ee last_name last_namem 7U`x a9 b c etk
first_name
first_namem 7U`a9 bc esk
date_of_birth
date_of_birthm 7U`a9 b c ek salarysalary `
FormFootertLVAL @ @ @ @ @ @ @ @ s s s s s s s s s
s s s s s s s s s s s s s! s" s# s$ s% s& s'
s(
s)
s* s+ s, s- s. y y
y
y
y y y y y y y
y y y
y y s s s s s s s
s s s s s |1q\@H `@ department< @v LWF000 @ z UI77++++++)
.
֖"_@_@ association_typeS @v LWF000n @w [O==111111/ . 嶸Ps\@&|G^@ association @ v LWF0004 @t VJ88,,,,,,* -ܸq\@-ܸq\@ UserDefined,,,,,,,,,,* . ,Ss\@?rc@ AccessLayout* @ u @ t E99-------+ @ Qq\@Qq\@ SysRel''''''''''% Qq\@Qq\@ Scripts((((((((((& 0 =Bb
ce
g hi
j -k/
#g^@
topic_type
topic_typeArial d 2 e 12 bRcRf 5bg 2 3 7bch bcg h
MS Sans Serifi 1g hj 1g hk 1bcl 23 : bc g[m 4bg[ n 2cdh[ o 2ej[ p 5bcr 35cd z bci j
MS Sans Serif{ 5 bcJ
`
FormHeader `. Detail m 7U`ar b c e namenamed 5U`9 ar bc
name Labeltopic type name
name_Labelp 3U`9 ab^csd
topic SubformForm.topic Subform
instanceOf
id_topic_type
topic_Subformd 5U`8 abac Label4topics `
FormFooterLVAL Q]u=Dq DC3BHp6 & bc@bc@ employee''''''''''' & bc@bc@ employee''''''''''' bc@bc@ department))))))))))) bc@ bc@ association_type/////////// ac@ bc@ association*********** ac@ac@ all_topics)))))))))))
ac@ac@ Admi( m 9
S department department & q employee employee t department_1 department q employee_1 employee sb occurrence occurrence D occurrence_type occurrence_type 'O topic topic WB topic_type topic_type ~ assocation_type assocation_type ~ s association association LVAL Q]u=Dq DC3B BOA '& bc@bc@ employee''''''''''' v"q\@dH;+q\@ departmeKKD = ValidationRule ValidationText Filter OrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden Description Format Caption InputMask DefaultValue Required AllowZeroLength DisplayControl
RowSourceType RowSource BoundColumn ColumnCount ColumnHeads ColumnWidths ListRows ListWidth LimitToList ? id_occurrence_type M
name 2
m datatype
o
Value List9 1 "Integer";"Float";"Date";"String";"Boolean";"URI"
1875
1875twip KKD L ValidationRule ValidationText Filter OrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden Description Format Caption InputMask DefaultValue Required AllowZeroLength DisplayControl
RowSourceType RowSource BoundColumn ColumnCount ColumnHeads ColumnWidths ListRows ListWidth LimitToList
DecimalPlaces :
id_occurrence 2
instanceOf n
0
o
Table/Querys k SELECT DISTINCTROW [occurrence_type].[id_occurrence_type], [occurrence_type].[name] FROM [occurrence_type];
0;1440
1440twip / id_topic 5
id_topic
o
Table/Queryi a SELECT DISTINCTROW [all_topics].[id], [all_topics].[type], [all_topics].[name] FROM [all_topics];
0;0;1441
4320twip Q resource
m ' ~ok\MżI:+' x $
$
#
#
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV$
$
$
#
#
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV$
$
$
#
#
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV$
$
$
#
#
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV$
$
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o
ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o m m ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o m g g ۇ O8V#jK`X~ZC[V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o Y LVAL Vi @ @ @ @ @ @ @ @ @ KKD FilterOn ColumnWidth ColumnOrder ColumnHidden Required AllowZeroLength DisplayControl FilterLookup
DecimalPlaces DefaultValue Z ItemText o
m b
Command 0
m e
ItemNumber 0
m Z Argument
m _
SwitchboardID 0
m KKD ValidationRule ValidationText Filter OrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden Description Format Caption InputMask DefaultValue Required AllowZeroLength DisplayControl :
id_topic_type M
name
m KKD L ValidationRule ValidationText Filter OrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden Description Format Caption
DecimalPlaces InputMask DefaultValue Required DisplayControl
RowSourceType RowSource BoundColumn ColumnCount ColumnHeads ColumnWidths ListRows ListWidth LimitToList AllowZeroLength 5 id_topic
instanceOf
0
o
Table/Query_ W SELECT DISTINCTROW [topic_type].[id_topic_type], [topic_type].[name] FROM [topic_type];
0;1440
1440twip M
name B
m T displayname ~
m Q sortname
m VC N
BDi
BlP2
SwitchboardID
ItemNumberItemTextCommandArgument
PrimaryKey a {q e X(Bc@X(Bc@ Switchboard Items22222222220 ڧq\@\K^@ association_type @ O ===1111111/ @ #g^@~+Nc@ topic_type @v LWF000 @ ~ UI77++++++) m1q\@hD `@ employee Subformv @| LWF000 @ } [O==111111/ b6s\@)_@ associations @v LWF000 x WK99------+ "_@R_@ association Subform @v LWF000 @ w ^R@@4444442 -ܸq\@-ܸq\@ SummaryInfoB @u 888,,,,,,,* @ is\@is\@ Reference4++++++++++) cq\@cq\@ Reference2++++++++++) a>\q\@a>\q\@ Reference1++++++++++) 8$q\@8$q\@ Reference**********( A
;+q\@A
;+q\@ departmentemployee33333333331 m >eqVq\@]q\@ topic_typel @ 777+++++++) @ g Zq\@
^@ topic @ 222&&&&&&&$ @ b eZ9s\@bx_@ occurrence_type @ <<<0000000. @ [ Giq\@C_@ occurrenceQ @ 777+++++++) @ / -ܸq\@-ܸq\@ MSysModules2----------+ , -ܸq\@-ܸq\@ MSysModules,,,,,,,,,,* LVAL gument'DC' jOn@ C`q
E /@@DC(urr@(@Up=A+e caCU>0fill@?,list of os@@/C = N z(Me!0Text], "" A#8lls
'@ D
C'! a%@V\&' TsnR. tons^ @zDqA"Ct con]But1B = 8)Dim dbsr@FRecor0dset stPrSQLA
SngGint8DCC' Set^0focufiw
C),6n hide a7`6 e@#
. You@n'tfield`bthg -! >C1].FC o6 = 2 To',("" &).Visi~+Label NRg ' !Ý& rs,f c#a2ivRIP 'd%a:H= oDbA\DE SELE CT * FROM []~& & " WHERdE > ID]=%a7Q ORDER BY] ;d =d.;A)a( Ā'Ifa-r@T` noŊ7(&\dis y a messa+ O0rwise, b2#V3 A-`(.EOF)nAYbJ Z"
͐"E"! a Whi (Not "EMe`$0^14?^G.Mq7Wend ɡiIfWtCl@!! reT6 5yD4w4. oF(uncrHQle^Click(@XxBtnXac`efU c`T{whe.nP'TA}cAed` 'AEAic s which ]ws 'nstantsd$w8ommP
Qpca n be exe c@qjCmdGoto;1I81AdA2Brow¢3?1Report@V4e5E@xitAppab= 6ORunMacro79ComBz' An error@$3spec`l৴#vErrDo#l i503OЫ!P(#H
p Gon&_/F"/Do# "g h5t
ha!ospondfd&&
_gVg[w["",] DyntK9 F"kfB`@~"íqEBiS9# [@bmaexr(B 32id< 5_NoM~_sgBox "#^!7S ding !.^I!J 1 A0 ICQSelePct C `!v[A] '@ Go to@Sor i$QC7q? 9U _B
aQOmہ/Im<
np
&K;, acE7
POdObc*SU_S4WI Argument ], acPre view
' Cust omize th e Switch@board.C ase conC 0) Th en MsgBox "Comm rTavailable. IGoTo 0 .' Updatform hMe.Filt er = "[I temNumber]0 AND [ 'Default' BCapA=@ Nz(hMe!BT H "L")% lO sˉExitaR A
H[Clo@seCurr Dpatab ga macroD MA Do@Av rst!GH LVAL OcodeC KMAny o r̃unre0cogn NEl seřUnknown oBd
End Sele~c C AWBiArdset TA{M7- .1cdbs
xButt~ gk_::A FuncK+ɰrr' i!a was cance{by us@]` ' s ome reas on, don' t display eb}mes s@ `ead,onB n@] lin=z=3n |"GC#}!?5%5`AanexecutingcC.", vbCritl .>Ifc
)0_ _ S R P _ 3 rU P YT !U IU U U 1 yb U U !V QV yV V X X Y 9A Y Y QZ Z Z Qb P yb a @ 4 J y )S @ 8 J y QS @ < aJ Y J 1 @ @ J y b @ D yI J p p p @ H Q 1Q @ L Q IQ @ P Q aQ @ T Q yQ @ X Q Q @ \ Q Q @ ` Q Q @ d Q Q @ h J y P ~ ~ ~ @ l J y !R @ p J y 9R @ t LVAL r J y aR @ x J y R @ | J y R @ J y R @ J y S { ? P
0
8 " $ h Yd:h %x
x
$ 4:D %QdoT%" $
, 4`#0
X /0x6 T4 L h $ 0 x d T 4 H .T:X %h
h
$ T
) hT ncP AfX%T kn#L*F<%h
h
$ T /L) hT5< AfX%T
kn#L*F<%h
h
$ T /L) hT5<
ndP? h" $
Qhx Cp Jlp *F,T:X %h
h
$ Ta< `1p) hT6 ,< lp *1p +h' %',%'<%lpx
Qht6 <, t
4 k 2: %T:X %h
h
$ T ) hT t
4 k Oc%T: <:X %t
$ <,%h
h
$ T ) hT6 <, Oc%T:
<:X %t
$ <,%h
h
$ T ) hT6 <, b : %t
$ %T:
<:X %t
$ <,%h
h
$ T ) hT6 <,
t
t
x
X 0 x p t $ L h T < , 0 < < C _ _ S R P _ 2 rU ( ` 0 &$ ) ` $ i ` , ` &/ p RLVAL ^R$z f3k;(_< x[3
tblIndexes.IndexName, g
tblTables.TableName+ g
$ @ g
tblTables
tblDatabaseTypeTables!!!
tblIndexes
G
ParamDatabaseTypeID O
G
N @ ' tblControlstblFields' @ , Name> @ o tblControls.ControlID- g tblFields tblControls G AddressTypeCode O G tblControls.Order) ' y @ ' tblControlstblControlProps1 @ 2& tblPropertiestblControlProps5 @ 4( tblFieldTypestblFields1 @ ." tblFieldstblControls' @ , tblTablestblControls' @ , tblFieldTypes.Format, g
tblControlProps.PropertyValue5 g tblProperties.PropertyName2 g tblFields.Capt # occurrence occurrence_type occurrence_typeoccurrence: @ 3 -!? occurrence.instanceOf)3 occurrence.resource'3 0 EEX E EEEEEEE E E E@ E EP E E` EEE LVAL i _ V B A _ P R O J E C T /! a^ * \ G { 0 0 0 2 0 4 E F - 0 0 0 0 - 0 0 0 0 - C 0 0 0 - 0 0 0 0 0 0 0 0 0 0 4 6 } # 3 . 0 # 9 # C : \ P r o g r a m F i l e s \ C o m m o n F i l e s \ M i c r o s o f t S h a r e d \ V B A \ V B A 3 3 2 . d l l # V i s u a l B a s i c F o r A p p l i c a t i o n s * \ G { 4 A F F C 9 A 0 - 5 F 9 9 - 1 0 1 B - A F 4 E - 0 0 A A 0 0 3 F 0 F 0 7 } # 8 . 0 # 0 # C : \ P R O G R A ~ 1 \ M I C R O S ~ 2 \ O f f i c e \ M S A C C 8 . O L B # M i c r o s o f t A c c e s s 8 . 0 O b j e c t L i b r a r y * \ G { 0 0 0 2 5 E 0 1 - 0 0 0 0 - 0 0 0 0 - C 0 0 0 - 0 0 0 0 0 0 0 0 0 0 4 6 } # 4 . 0 # 0 # C : \ P r o g r a m F i l e s \ C o m m o n F i l e s \ M i c r o s o f t S h a r e d \ D A O \ D A O 3 5 0 . D L L # M i c r o s o f t D A O 3 . 5 1 O b j e c t L i b r a r y * \ G { E A B 2 2 A C 0 - 3 0 C 1 - 1 1 C F - A 7 E B - 0 0 0 0 C 0 5 B A E 0 B } # 1 . 1 # 0 # C : \ W I N D O W S \ S y s t e m 3 2 \ s h d o c v w . d l l # M i c r o s o f t I n t e r n e t C o n t r o l s * \ G { F 5 0 7 8 F 1 8 - C 5 5 1 - 1 1 D 3 - 8 9 B 9 - 0 0 0 0 F 8 1 F E 2 2 1 } # 4 . 0 # 0 # C : \ W I N D O W S \ s y s t e m 3 2 \ m s x m l 4 . d l l # M i c r o s o f t X M L , v 4 . 0
G> V X T M
73e47b437 *D> 0 ف F o r m _ o c c u r r e n c e s
c3e47b500 *DY o
F o r m _ S w i t c h b o a r d
a3e47b468 *DK P $ p LVAL P 0 x A|ߺF&QL KI)[L3Mh R_|Co s 0 ,E S Access As call Case . Debug C Each D Else G End U For _ Goto ` If c In | Me name New Next Null On Select Set Sub Then True with VBA Win16~ Win32 Mac DAO tm-extension SHDocVw! Form_occurrence_type subformv _Evaluate Form
FormHeader
name_Label id_topic_Label&{
link_Label7 Detail2 id_topic
FormFooterT linkh Command7 Command7_Click Err_Command7_Clicki ScreenI PreviousControl SetFocus DoCmdƧ FindNextu Exit_Command7_Click MsgBoxR Erro Description
link_Click% datatype%? Label8, Click Forms link_BeforeUpdatek Cancel ControlsK Itemz _B_var_ifP
followlinks _B_var_followlink< FollowHyperlink- www
_B_var_www Application*
Form_Form16 Command0 Command0_ClickF[ Err_Command0_Click Exit_Command0_Click<" GetUserAddressE strInput Error_GetUserAddress> InputBox
Exit_GetUserAddress You couldu CallGetUserAddressc Number- Form_Load { ctl
_B_var_forjL froŏ
_B_var_froL
_B_var_ctl= FontU ForeColor _B_var_withY
FontUnderline] _B_var_On6
errhandler } selctg _B_var_selctTn _B_var_Error) MSXML2O Module1b DossierToXMLN xmlDoc Cr LVAL eateObject rootElementM
createElementH
nodCurrent, appendChildb
rstDossier Recordset rstTemp dossierr dbsǂ CurrentDbS
OpenRecordset| dbOpenSnapshot EOF i` Fields7 Count0v nodTxt 2 createTextNode ValueK nodElmN id_werknemer& IsNull id_werkgeverY MoveNextL! rstTemp2 nodCurrent2P ja ne Save
_B_var_Options ( ToXTMy7 _B_var_rootElement> setAttribute
_B_var_xmlDoc4B resource
DOMDocument40wg IXMLDOMElement
_B_var_Set httpg _B_var_nodCurrent]
_B_var_dbs?
_B_var_nodElmZ _B_var_i
_B_var_nodTxt _B_var_id_werkgever _B_var_rstTemp2p _B_var_nodCurrent2 _B_var_j
_B_var_dossieru _B_var_n _B_var_rstDossier _B_var_Debugۮ SQL"
topic_typec FROM~ topic
_B_var_Select'E
id_topic_type nodBaseName7 _B_var_nodBaseName displayname sortname%@ nodBaseNameStringh _B_var_id_topic_type _B_var_nodBaseNameStringZ _B_var_displayname _B_var_sortname-
nodVariant nodTemp-o _B_var_nodTemp0c
nodParameters _B_var_nodVariant0q _B_var_nodParametersw nodSIRef nodVariantName{L
nodResData`$ _B_var_nodSIRefP _B_var_nodVariantName _B_var_nodResDataʒ XTMO
_B_var_Newu pi^ IXMLDOMProcessingInstruction createProcessingInstructionk ISO MyEntityV createEntityReference0! ent݉
_B_var_entF
createNode1@ NODE_ELEMENTM seyt _B_var_seyt
K elm dom rootT prologg validateOnParseO loadXMLD
parseErrorvY reason LVAL vbCrLf rootElb
vbCritical+} documentElementE ( AddTopics: xo
nodInstanceOf nodTopicRef addOccurrences?7
rstTempOcc% topic_id\ occ_data
nodOccurrenceB nodResRef nodRes$ ( AddAssociations nodAssociation# nodMember nodRole
_B_var_prolog,
_B_var_rootEl _B_var_x _B_var_nodInstanceOf} _B_var_nodTopicRef_
_B_var_SQL3 _B_var_nodOccurrence _B_var_nodResRef8 _B_var_nodAssociations; _B_var_nodMemberr _B_var_nodRole debog _B_var_debog Right
_B_var_Right9 tmF_ tk _B_var_tm xlink> href Sort topicmapsG org core psi^ display operatm! xmlns rec re^ occurrence_type
SwitchboardID
ItemNumberhG ItemText Command] Argument= VerticalShadowBoxy Label2, Picture* Option1 Option2 Option3 Option4 Option5 Option6 Option7 Option8 HorizontalHeaderBox Label1, HorizontalDividingLine/ OptionLabel1q) OptionLabel2r) OptionLabel3s) OptionLabel4t) OptionLabel5u) OptionLabel6v) OptionLabel7w) OptionLabel8x) Form_Open- Filter; FilterOn& Form_Current Captionx Nzu^ FillOptions
conNumButtons rst strSQLF intOption8 Visible HandleButtonClickEx intBtn( conCmdGotoSwitchboard conCmdOpenFormAdd% conCmdOpenFormBrowse conCmdOpenReport conCmdCustomizeSwitchboardb conCmdExitApplication conCmdRunMacroM
conCmdRunCodew conErrDoCmdCancelled HandleButtonClick_Err
dbOpenDynaset
FindFirstM= NoMatch/3 OpenForm acAdd
OpenReport acPreviewo Run_ CloseCurrentDatabase3 Ru LVAL <
8 , x 8 )?,8,X,,,,@
+,K,c,s,, ,@,X,h,,8,8,8,8,8,+,K,c,s,,
2
2
2 topic_type.id_topictopictopic_type.instanceOf&topic_type.name topic_type.displaynametopic_type.sortname,,`,,
,{QZc@ ,,-+,- - K,- - c,- s,- ,- topic_type,,, ,,
^@!~sq_ctopic_type~sq_ctopic Subform, ,, @,, X,, h,, ,, ,@,X,h,, +,- -GK,- - c,-`2 s,-id_t c,-inst etopic +,, K,, c,, s,, ,, ,@,X,h,,,8,,__id_topic_type ,
,,
, ,@,X,p,,,X,
,X,
,X,
,X,
,X,
,X,
,X,
,X,
,X,
,X,
,X,
,X,
,X,
,X,
,X,
,X,
,X,
,X,
,X,
,X,
,X,
,X,
,X,
,X,
,X,
,X,
,X,
,X,
,X,
,X,,,H,0,, ,`, , , ,
, ,
, ,
|, ,,,P-, ,H, ,
, ,
,( ,
,X ,
, , ,
,
( ,
X ,<p,x,,,, , , ,( ,X , ,topic,,,PrimaryKey
id_topic_typeid_to LVAL i _ V B A _ P R O J E C T V X T M
53e47b572 *D> 0 ف F o r m _ o c c u r r e n c e s
c3e47b500 *DY o
F o r m _ S w i t c h b o a r d
83e47b666 *DK P & p LVAL nMacroX HandleButtonClick_Exitt Form_Switchboard Currente _B_var_ItemNumberҵ Collect _B_var_ItemText _B_var_CommandXa _B_var_Argument Form_occurrences@B l ?
K Y 6 d i r 0* pH d tm-exten sion < @
=
v G>" <V DAO> B D A O
*\G{ 00025E01- 0C
0046}#4. 0#0#C:\P rogram F iles\Common Micr osoft Sh`ared\ w350.DLL# 3.51 O bject Li`braryH SHDoc Vw> H D o c V w_u k_ EAB22AC0 -30C1-11CF-A7EB_ C05BAE0B }#1.1_WI NDOWS\Sy stem32\s hdocvw.dllPInter net Controls6 MSXML2> M S X M L 2 LlbLF5078F1 8-C55&D3 -89B9&F81FE221V&s&msxml4% , v@c "B V{XTM _VBA_MODULE2 U PB _@,OTU-E @ X1Bف ÔE ,B! "+B Fo rm_occur@rences oj
" (B S witchboa$rd< $ = _ _ S R P _ 0 O K)^ rU ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~> )BALjT6" a iO Form_occurrence_type subform XTM tm-extension F = C:\Program Files\Common Files\Microsoft Shared\VBA\VBA332.dll VBA
) Q ( J_N ?
& C:\PROGRA~1\MICROS~2\Office\MSACC8.OLB Access
A i 8 ^ F = C:\Program Files\Common Files\Microsoft Shared\DAO\DAO350.DLL DAO
1 Y LVAL H *0 [ C:\WINDOWS\System32\shdocvw.dll SHDocVw
a X Q ! C:\WINDOWS\system32\msxml4.dll MSXML2
A i h ToXTM AddTopics 1 m. 3)6{ O>` AddAssociations
& parser error ? { / [ Employee S id1 _ Department1 _ Assignment &>/'o zw Loading
< /> @ČF1 BJ4 e Date of birth- W Salary
Msxml2.DOMDocument.4.0 3)6{ O>`
Start Programj Sort name q 3)6{ O>` o Display name
VBA332.DLL h)aN ? " A SELECT 'topic_type_' & id_topic_type AS id, name FROM topic_type;
OpenRecordset+ S SELECT 'association_type_' & id_associat LVAL ion_type AS id, name FROM association_type; 2 WHERE topic.instanceOf = topic_type.id_topic_type; 0 \ SELECT DISTINCT 'role_type_' & role_type_1 AS id, role_type_1 AS name FROM association_type;0 \ SELECT DISTINCT 'role_type_' & role_type_2 AS id, role_type_2 AS name FROM association_type;
FROM topic, topic_type name FROM department; * P SELECT 'occurrence_type_' & id_occurrence_type AS id, name FROM occurrence_type;> y SELECT topic_type.name & '_' & topic.id_topic AS id, 'topic_type_' & topic_type.id_topic_type AS topic_type, topic.name, " topic.displayname, topic.sortname # B SELECT 'employee_' & id_employee AS id, 'employee' AS topic_type, 1 ^ first_name & ' ' & last_name AS name, last_name & ', ' & first_name AS sortname FROM employee;& H SELECT 'department_' & id_department AS id, 'department' AS topic_type, = SELECT 'association_type_' & association.instanceOf AS type, 7 'role_type_' & association_type.role_type_1 AS role_1, " association.member_1 AS member_1, 5 'role_type_' association_type.role_type_2 AS role_2, m. S m. Q m. ! association.member_2 AS member_2 # FROM association, association_type $ D WHERE association.instanceOf = association_type.id_association_type; SELECT 'assignment' AS type, 'department' AS role_1, End Program topic 3)6{ O>` 6 'department_' & department.id_department AS member_1,
'employee' AS role_2, 0 'employee_' & employee.id_employee AS member_2, FROM employee, department 5 WHERE department.id_department = employee.department;
C:\dev\tm.xtm
topic_type 0
instanceOf topicRef appendChild
xlink:href # setAttribute name baseName baseNameString displayname sortname variant
parameters #display #sor LVAL t variantName resourceData ; SELECT 'occurrence_type_' & occurrence.instanceOf AS type, & occurrence_type.datatype AS datatype, occurrence.resource AS resource ! FROM occurrence, occurrence_type WHERE occurrence.id_topic = ' ' AND ; occurrence.instanceOf = occurrence_type.id_occurrence_type; q m.
occurrence type datatype URI resource resourceRef k SELECT date_of_birth, salary FROM employee &KTK4.3 WHERE id_employee = ; 7 'role_type_' & association_type.role_type_2 AS role_2, association role_1 member roleSpec member_1 role_2 member_2 8 WHERE department.id_department = employee.id_department; / 'employee_' & employee.id_employee AS member_2 tʮG>2 K%J#`wG'#0@.YP X)!E\$xDR htIaY#P SC7 ?
FormFooter LC7 ? id_topic Detail @C7 ? name 31 ? Form
FormHeader AC7 ?
name_Label resource id_topic_Label datatype
link_Label
link_Click
h z?3Gr7 wN54N|l occurrence_type
d 5 SELECT topic_type.name & '_' & topic.id_topic AS id, $ D 'topic_type_' & topic_type.id_topic_type AS topic_type, topic.name, T P Save XTM file to:
Form_Form1 Form_Switchboard ǩ>bFG}17 'Kю6|K yRK.(a OLCM@YF BC7 ? VerticalShadowBox Label2 DC7 ? Picture EC7 ? Option1 Option2 Option3 Option4 Option5 Option6 Option7 Option8 HorizontalHeaderBox Label1 OptionLabel1 OptionLabel2 /LVAL ; ! C:\WINDOWS\system32\msxml4.dll MSXML2
A i h ToXTM AddTopics 1 m. 3)6{ O>` AddAssociations
& parser error OptionLabel3 OptionLabel4 OptionLabel5 OptionLabel6 OptionLabel7 OptionLabel8 Form_Open Form_Current FillOptions HandleButtonClick
, [ItemNumber] = 0 AND [Argument] = 'Default' ]协N ? ItemText tpY ? Option1 SetFocus Option Visible OptionLabel ! SELECT * FROM [Switchboard Items] AND [ItemNumber]=
, WHERE [ItemNumber] > 0 AND [SwitchboardID]=
SwitchboardID
ORDER BY [ItemNumber]; , There are no items for this switchboard page OptionLabel1 Caption
ItemNumber
Switchboard Items
[SwitchboardID]=
7 There was an error reading the Switchboard Items table. Command % [ItemNumber] = 0 AND [SwitchboardID]= Argument `GX GP WZMAIN80.sbm_Entry fĤIx 8<
Command not available. Unknown option. ) There was an error executing the command. {JEiTO OXZMb1 EA] iH%HxR GE N+
Form_occurrencesE _ _ S R P _ 1 rU ~ ~ ~ ~ ~ ~ ~ ~ ~ ~k
Y rstTemp root addOccurrences yI ( I 8 !J H aJ X J h YP x P Q Cancel intBtn; LVAL < B p E ~ x p \)?XEp E EE8 EH E
9EdEEEE EPEEEE@EpEEEE9EdEEEE
2
2
2
2 employee.occurrence_type.name,occurrence_type employee.occurrence.id_topic
occurrence!employee.occurrence_type.datatype,occurrence_type employee.occurrence.resource
occurrence employee.occurrence.instanceOfEEEE
E9rc@PE`E
(E8EEE
9E01+ dE01tmen E011 E01 E01 employeeEEEEoccurrence_type E E E E`Ebx_@
occurrence
E@
Ep
E E`EC_@)~sq_cemployee~sq_coccurrence_type subform`E EE PEE EE EE EE EPEEEEpE8E
EE
9E01 dE01depa eE01ee E011 E01 occurrence_type occurrence8EE )E` E YEh E Ep E Ex E E E EPEEEE 9E01
E01 occurrence_type 9E0
E E8
E EEE01 dE01 E01 occurrence E E dE( E E0 EEPEEH Ep EE__idH E
EE(E E@EXEpEEE E
E E
E E
E E
E E
E E
E E
E E
E E
E E
E E
E E
E E
E E
E E
E E
E E
E E
E E
E E
E E
E E
E E
E E
E E
E E
E E
E E
E E
E EE LVAL E EpE EE
EE
EE
EE
EE |E EHE EEEEȗ18EEx E|E 8E EHEE1EEE(EEXEEEE
E
E
(E
XEE<EEEEE@EEE(EXEEEEoccurrence_typeE EPrimaryKeyid_occurrence_type
occurrenceE
EEEPrimaryKeyid_topicid_occurrence_type
id_occurrence EEE E E@EE`E
PrimaryKey`EEv EEEv PE(E EEEsEEEEEEEEEEEEEEEEEEEEEEEEEEEEE E E E E PEEEEx Eoccurrence_type EEEEEEEE
occurrenceid_occurrence_typeEE EE
EEPEEEEEEEEE EEEid_occurrence_typeEE
EEEE Eid_occurrence_type E ( EP E, E
E
id_topicT E
H E [__id]| E E LVAL P 0 x A|ߺF&QL KI)[L3Mh R_|Co s 0 -F S Access As call Case . Debug C Each D Else G End U For _ Goto ` If c In | Me name New Next Null On Select Set Sub Then True with VBA Win16~ Win32 Mac DAO tm-extension SHDocVw! Form_occurrence_type subformv _Evaluate Form
FormHeader
name_Label id_topic_Label&{
link_Label7 Detail2 id_topic
FormFooterT linkh Command7 Command7_Click Err_Command7_Clicki ScreenI PreviousControl SetFocus DoCmdƧ FindNextu Exit_Command7_Click MsgBoxR Erro Description
link_Click% datatype%? Label8, Click Forms link_BeforeUpdatek Cancel ControlsK Itemz _B_var_ifP
followlinks _B_var_followlink< FollowHyperlink- www
_B_var_www Application*
Form_Form16 Command0 Command0_ClickF[ Err_Command0_Click Exit_Command0_Click<" GetUserAddressE strInput Error_GetUserAddress> InputBox
Exit_GetUserAddress You couldu CallGetUserAddressc Number- Form_Load { ctl
_B_var_forjL froŏ
_B_var_froL
_B_var_ctl= FontU ForeColor _B_var_withY
FontUnderline] _B_var_On6
errhandler } selctg _B_var_selctTn _B_var_Error) MSXML2O Module1b DossierToXMLN xmlDoc Cr LVAL eateObject rootElementM
createElementH
nodCurrent, appendChildb
rstDossier Recordset rstTemp dossierr dbsǂ CurrentDbS
OpenRecordset| dbOpenSnapshot EOF i` Fields7 Count0v nodTxt 2 createTextNode ValueK nodElmN id_werknemer& IsNull id_werkgeverY MoveNextL! rstTemp2 nodCurrent2P ja ne Save
_B_var_Options ( ToXTMy7 _B_var_rootElement> setAttribute
_B_var_xmlDoc4B resource
DOMDocument40wg IXMLDOMElement
_B_var_Set httpg _B_var_nodCurrent]
_B_var_dbs?
_B_var_nodElmZ _B_var_i
_B_var_nodTxt _B_var_id_werkgever _B_var_rstTemp2p _B_var_nodCurrent2 _B_var_j
_B_var_dossieru _B_var_n _B_var_rstDossier _B_var_Debugۮ SQL"
topic_typec FROM~ topic
_B_var_Select'E
id_topic_type nodBaseName7 _B_var_nodBaseName displayname sortname%@ nodBaseNameStringh _B_var_id_topic_type _B_var_nodBaseNameStringZ _B_var_displayname _B_var_sortname-
nodVariant nodTemp-o _B_var_nodTemp0c
nodParameters _B_var_nodVariant0q _B_var_nodParametersw nodSIRef nodVariantName{L
nodResData`$ _B_var_nodSIRefP _B_var_nodVariantName _B_var_nodResDataʒ XTMO
_B_var_Newu pi^ IXMLDOMProcessingInstruction createProcessingInstructionk ISO MyEntityV createEntityReference0! ent݉
_B_var_entF
createNode1@ NODE_ELEMENTM seyt _B_var_seyt
K elm dom rootT prologg validateOnParseO loadXMLD
parseErrorvY reason
ǭǭǭzzH b/Bc@b/Bc@ ~sq_fSwitchboard* @O ===1111111/ @ $/Bc@b/Bc@ Switchboard,,,,,,,,,,* X(Bc@)Bc@ Switchboard Items @ >>>22222220 @ ڧq\@\K^@ association_type @ O ===1111111/ @ #g^@~+Nc@ topic_type @v LWF000 @ ~ UI77++++++) m1q\@hD `@ employee Subformv @| LWF000 @ } [O==111111/ b6s\@)_@ associations @v LWF000 x WK99------+ "_@R_@ association Subform @v LWF000 @ w ^R@@4444442 -ܸq\@-ܸq\@ SummaryInfoB @u 888,,,,,,,* @ is\@is\@ Reference4++++++++++) cq\@cq\@ Reference2++++++++++) a>\q\@a>\q\@ Reference1++++++++++) 8$q\@8$q\@ Reference**********( A
;+q\@A
;+q\@ departmentemployee33333333331 m >eqVq\@]q\@ topic_typel @ 777++ Add occurrence typesoccurrence_type, Generate XTM file from database (needs MSXML 4.0)ToXTM?: Maintain employee dataemployee' Add topic types and topicstopic_type-# Add association typesassociation_type. Maintain departments and employessdepartment5+ MenuDefault
LVAL < ! x )?X!!(!!!!U
`;!c!!!!!0!X!x!!!!H!H!H!H!H!H!;!c!!!!!
2
2 department.id_employeeemployeedepartment.id_departmentdepartment.last_namedepartment.first_namedepartment.date_of_birthdepartment.salary !!!!
!Yc@
!(!me ;!01birt c!01p !01 !01 !01 !01 department!@!!
!!dH;+q\@$~sq_cdepartment~sq_cemployee Subform(! 0!! X!! x! ! !(! !0! !8!0!X!x!!!!;!01
c!01 Ń!01 $ !01 !01 !01 employee ;!! c!! !! !! !! !!0!X!x!!!!!!!__id_department !
!!! !@!X!p!!!(!
!(!
!(!
!(!
!(!
!(!
!(!
!(!
!(!
!(!
!(!
!(!
!(!
!(!
!(!
!(!
!(!
!(!
!(!
!(!
!(!
!(!
!(!
!(!
!(!
!(!
!(!
!(!
!(!
!(!!!!H!!
!`!
! !
!
!
!
!
! !
! |! !@!!1(!h !! !! !! !!(
!!X
!!h LVAL @ @
y y y y y y y
y y y
y y y y y y y# y$ y% 6 6 y& y y y y y y y y y y y y y y! y"
! !
!
!(
!X
!@!!!!!!h ! ! ! !(
!X
!
!employee! !0!@!PrimaryKey
id_department id-employeedepartmentemployee`!!v X!H!!!!s!!!!!!!!!!!!!!!!!!!!!!!!!!!!!0! (!@! !!!employee!!!!X!!!!!!P! `!h!t!
id_department!!
! [__id_department] !!!!!
!!!!!
id_department!!!@! !@!p!
! LVAL < H # x H )?
#H#X##+
### ### ### ###
2
2 employee.id_employeeemployeeemployee.last_nameemployee.first_name0#(###
(#,Yc@ 0#@#mploye#01!*#01 !#01@ iemployeeP##@# ( #(#dH;+q\@$~sq_cdepartment~sq_cid_employee @# ## ## ##[employee].[id_employee]#[employee].[last_name]# [employee].[first_name] # #01h ł*#01! #01 employee #@# #H# #P####
# #h # (#@#P#`#p##X#
#X#
#X#
#X#
#X#
#X#
#X#
#X#
#X#
#X#
#X#
#X#
#X#
#X#
#X#
#X#
#X#
#X#
#X#
#X#
#X#
#X#
#X#
#X#
#X#
#X#
#X#
#X#
#X#
#X###X# #
#( #` #( #
#( #
|# ##
#1@#
#
#8 #
#H #
#
#
#4 # # #
#
#
#( #employee@
#P
#`
#p
#PrimaryKey
id_department id-employeedepartmentemployee
##v #x### # s# #LVAL @ @ @
y$ y% 6 6 y& y y y y y y y y y y y y y y! y"
6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6
& 6 & 6 & 6
, 6 , 6 , 6 / 6 / 6 / 6 [ 6 [ 6 [ 6! b 6" b 6# b 6$ g 6% g g m m m s s s s s s s
s s s s s # # # # # # # # # # # # # # # # # # # # # # # # # # ## X###@##employee
PrimaryKey###X ### ####(#( # LVAL < Q @ % x @ l)? %@%%
%
% %#% % %% %%% % %#%
2 department.id_department
departmentdepartment.id_employeedepartment.name %%%%
(%,Yc@ 0%@%#%01, %01
#%014 #department%%% P
%(%dH;+q\@~sq_fdepartment @% %% %% %%%%% %01, %01 #%01 department %h% %p% #%x%%%%
%% % (%@%P%`%p%%%
%%
%%
%%
%%
%%
%%
%%
%%
%%
%%
%%
%%
%%
%%
%%
%%
%%
%%
%%
%%
%%
%%
%%
%%
%%
%%
%%
%%
%%%%P% %
%P
%`%P
% %P
%
|% %%( %01@% % %` %
%p % % %
%4 % % % % %
%P
%
departmentX %h %x %PrimaryKey
id_department
id_boss %%v %p%%%%s%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% %%SLVAL _ @ @ @
y y y y y y y y y y! y"
6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6
& 6 & 6 & 6
, 6 , 6 , 6 / 6 / 6 / 6 [ 6 [ 6 [ 6! b 6" b 6# b 6$ g 6% g g m m m s s s s s s s
s s s s s %8%
%department
PrimaryKey%
%% %%%%%%% %P
% LVAL @ @ @ @
!
6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 pic,,v ,,,,,s,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, X,,,0,
,topic,,,,,
,0,`,,,, ,, ,
id_topic_typeX,,,
, [__id_topic_type] \,(,0,p,|,
,,x,,h,
id_topic_type0,,,,,,, , B LVAL N N I < r , x l)?0 ,,, ,
,,,,,,,,
2 topic_type.id_topic_type
topic_typetopic_type.name ,,,,
,Zc@ ,,
,X,,-X, ,- ,topic_typeH,,8, H ,,]q\@~sq_ftopic_type , ,, ,,,, ,-X, ,- ,topic_type ,, ,,,,
, ,x
, ,@,H,P,X,`,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,,,,
, ,H ,` ,H ,
|,
,,
,-,, ,X
,,
,0
,
,, ,H ,
topic_type , ,PrimaryKey
id_topic_type8 ,,v @, ,0,, ,s , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,, ,,,, ,topic_type
PrimaryKey, ,@,h
,@,, ,,p,,,H ,
ǨǨǨǨ>- ' ,zhc@,zhc@ occurrence_type @| LWF000x @ ZN<<000000. % l' ,zhc@,zhc@ occurrence_type @| LWF000x @ ZN<<' ,zhc@,zhc@ - $ {c@G {c@ ~sq_foccurrence_type 3 * @)O MMMA5555553 ` , OAzc@OAzc@ ~sq_fassociation_typec 1 * @'O NNNB6666664 ` + \8rc@\8rc@ ~sq_femployee * @ O FFF:......, ` ' ,zhc@NMoc@ occurrence_type @| LWF000v @ ZN<<000000. Zc@Zc@ ~sq_ftopic_type * @ O HHH<000000. ` LVAL vbCrLf rootElb
vbCritical+} documentElementE ( AddTopics: xo
nodInstanceOf nodTopicRef addOccurrences?7
rstTempOcc% topic_id\ occ_data
nodOccurrenceB nodResRef nodRes$ ( AddAssociations nodAssociation# nodMember nodRole
_B_var_prolog,
_B_var_rootEl _B_var_x _B_var_nodInstanceOf} _B_var_nodTopicRef_
_B_var_SQL3 _B_var_nodOccurrence _B_var_nodResRef8 _B_var_nodAssociations; _B_var_nodMemberr _B_var_nodRole debog _B_var_debog Right
_B_var_Right9 tmF_ tk _B_var_tm xlink> href Sort topicmapsG org core psi^ display operatm! xmlns rec re^ occurrence_type
SwitchboardID
ItemNumberhG ItemText Command] Argument= VerticalShadowBoxy Label2, Picture* Option1 Option2 Option3 Option4 Option5 Option6 Option7 Option8 HorizontalHeaderBox Label1, HorizontalDividingLine/ OptionLabel1q) OptionLabel2r) OptionLabel3s) OptionLabel4t) OptionLabel5u) OptionLabel6v) OptionLabel7w) OptionLabel8x) Form_Open- Filter; FilterOn& Form_Current Captionx Nzu^ FillOptions
conNumButtons rst strSQLF intOption8 Visible HandleButtonClickEx intBtn( conCmdGotoSwitchboard conCmdOpenFormAdd% conCmdOpenFormBrowse conCmdOpenReport conCmdCustomizeSwitchboardb conCmdExitApplication conCmdRunMacroM
conCmdRunCodew conErrDoCmdCancelled HandleButtonClick_Err
dbOpenDynaset
FindFirstM= NoMatch/3 OpenForm acAdd
OpenReport acPreviewo Run_ CloseCurrentDatabase3 Ru LVAL nMacroX HandleButtonClick_Exitt Form_Switchboard Currente _B_var_ItemNumberҵ Collect _B_var_ItemText _B_var_CommandXa _B_var_Argument Form_occurrences@B Label22g l ?
K Y 6 d i r 0* pH d tm-exten sion < @
=
v G>" <V DAO> B D A O
*\G{ 00025E01- 0C
0046}#4. 0#0#C:\P rogram F iles\Common Micr osoft Sh`ared\ w350.DLL# 3.51 O bject Li`braryH SHDoc Vw> H D o c V w_u k_ EAB22AC0 -30C1-11CF-A7EB_ C05BAE0B }#1.1_WI NDOWS\Sy stem32\s hdocvw.dllPInter net Controls6 MSXML2> M S X M L 2 LlbLF5078F1 8-C55&D3 -89B9&F81FE221V&s&msxml4% , v@c "B V{XTM _VBA_MODULE2 U PB _@,OTU-E @ X1Bف ÔE ,B! "+B Fo rm_occur@rences oj
" (B S witchboa$rd< & = _ _ S R P _ 0 K)^ rU ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~1 .H6B4U9' a iO Form_occurrence_type subform XTM tm-extension F = C:\Program Files\Common Files\Microsoft Shared\VBA\VBA332.dll VBA
) Q ( J_N ?
& C:\PROGRA~1\MICROS~2\Office\MSACC8.OLB Access
A i 8 ^ F = C:\Program Files\Common Files\Microsoft Shared\DAO\DAO350.DLL DAO
1 LVAL Y H *0 [ C:\WINDOWS\System32\shdocvw.dll SHDocVw
a X Q ! C:\WINDOWS\system32\msxml4.dll MSXML2
A i h ToXTM AddTopics 1 m. 3)6{ O>` AddAssociations
& parser error ? { / [ Employee S id1 _ Department1 _ Assignment &>/'o zw Loading
< /> @ČF1 BJ4 e Date of birth- W Salary
Msxml2.DOMDocument.4.0 3)6{ O>`
Start Programj Sort name q 3)6{ O>` o Display name
VBA332.DLL h)aN ? " A SELECT 'topic_type_' & id_topic_type AS id, name FROM topic_type;
OpenRecordset+ S SELECT 'associa LVAL tion_type_' & id_association_type AS id, name FROM association_type; 2 WHERE topic.instanceOf = topic_type.id_topic_type; 0 \ SELECT DISTINCT 'role_type_' & role_type_1 AS id, role_type_1 AS name FROM association_type;0 \ SELECT DISTINCT 'role_type_' & role_type_2 AS id, role_type_2 AS name FROM association_type;
FROM topic, topic_type name FROM department; * P SELECT 'occurrence_type_' & id_occurrence_type AS id, name FROM occurrence_type;> y SELECT topic_type.name & '_' & topic.id_topic AS id, 'topic_type_' & topic_type.id_topic_type AS topic_type, topic.name, " topic.displayname, topic.sortname # B SELECT 'employee_' & id_employee AS id, 'employee' AS topic_type, 1 ^ first_name & ' ' & last_name AS name, last_name & ', ' & first_name AS sortname FROM employee;& H SELECT 'department_' & id_department AS id, 'department' AS topic_type, = SELECT 'association_type_' & association.instanceOf AS type, 7 'role_type_' & association_type.role_type_1 AS role_1, " association.member_1 AS member_1, 5 'role_type_' association_type.role_type_2 AS role_2, m. S m. Q m. ! association.member_2 AS member_2 # FROM association, association_type $ D WHERE association.instanceOf = association_type.id_association_type; SELECT 'assignment' AS type, 'department' AS role_1, End Program topic 3)6{ O>` 6 'department_' & department.id_department AS member_1,
'employee' AS role_2, 0 'employee_' & employee.id_employee AS member_2, FROM employee, department 5 WHERE department.id_department = employee.department;
C:\dev\tm.xtm
topic_type 0
instanceOf topicRef appendChild
xlink:href # setAttribute name baseName baseNameString displayname sortname variant
parameters LVAL #display #sort variantName resourceData ; SELECT 'occurrence_type_' & occurrence.instanceOf AS type, & occurrence_type.datatype AS datatype, occurrence.resource AS resource ! FROM occurrence, occurrence_type WHERE occurrence.id_topic = ' ' AND ; occurrence.instanceOf = occurrence_type.id_occurrence_type; q m.
occurrence type datatype URI resource resourceRef k SELECT date_of_birth, salary FROM employee &KTK4.3 WHERE id_employee = ; 7 'role_type_' & association_type.role_type_2 AS role_2, association role_1 member roleSpec member_1 role_2 member_2 8 WHERE department.id_department = employee.id_department; / 'employee_' & employee.id_employee AS member_2 tʮG>2 K%J#`wG'#0@.YP X)!E\$xDR htIaY#P SC7 ?
FormFooter LC7 ? id_topic Detail @C7 ? name 31 ? Form
FormHeader AC7 ?
name_Label resource id_topic_Label datatype
link_Label
link_Click
h z?3Gr7 wN54N|l occurrence_type
d 5 SELECT topic_type.name & '_' & topic.id_topic AS id, $ D 'topic_type_' & topic_type.id_topic_type AS topic_type, topic.name, T P Save XTM file to:
Form_Form1 Form_Switchboard ǩ>bFG}17 'Kю6|K yRK.(a OLCM@YF BC7 ? VerticalShadowBox Label2 DC7 ? Picture EC7 ? Option1 Option2 Option3 Option4 Option5 Option6 Option7 Option8 HorizontalHeaderBox Label1 OptionLabe LVAL g< l1 OptionLabel2 OptionLabel3 OptionLabel4 OptionLabel5 OptionLabel6 OptionLabel7 OptionLabel8 Form_Open Form_Current FillOptions HandleButtonClick
, [ItemNumber] = 0 AND [Argument] = 'Default' ]协N ? ItemText tpY ? Option1 SetFocus Option Visible OptionLabel ! SELECT * FROM [Switchboard Items] AND [ItemNumber]=
, WHERE [ItemNumber] > 0 AND [SwitchboardID]=
SwitchboardID
ORDER BY [ItemNumber]; , There are no items for this switchboard page OptionLabel1 Caption
ItemNumber
Switchboard Items
[SwitchboardID]=
7 There was an error reading the Switchboard Items table. Command % [ItemNumber] = 0 AND [SwitchboardID]= Argument `GX GP WZMAIN80.sbm_Entry fĤIx 8<
Command not available. Unknown option. ) There was an error executing the command. {JEiTO OXZMb1 EA] iH%HxR GE N+
Form_occurrences 56JK: d M5~zi?LV W-;llBӓb9q
@DH7a8 ͕H " * \ R f f f f * a 3 e 4 7 b 4 6 8 * \ R 2 * # 2 8 * \ R 2 * # 2 d * \ R 1 * # 2 e * \ R 1 * # 8 e * \ R 1 * # 8 f * \ R 1 * # 8 5 ( $ ` x |k p iH
` 0 0k ` k / / @ B x@ $ t` $ `p `H n ` N i i B i i @ B @" B @$ B @& B @( B @* B @, B @.H B @0 B ` x $ t( $ LVAL < El %
x D)?ElElHElPEl+
2EljElElElEl ElXElxElElEl@El@El@El@El@El2EljElElElEl
2 1Switchboard Items.SwitchboardID Switchboard Items Switchboard Items.ItemNumberSwitchboard Items.ItemTextSwitchboard Items.CommandSwitchboard Items.ArgumentElElElEl
El bc@ElEl 2El*/ jEl*/ h// El*/ El*/ El*/ Switchboard ItemsXElEl@El x ElEl)Bc@~sq_fSwitchboardEl ElEl XElEl xElEl ElEl ElEl ElXElxElElEl 2El*/ jEl*//
El*/ El*/ El*/ Switchboard Items 2El El jEl(El El0El El8El El@El ElXElxElElEl
El`El
El El@ElXElpElElElHEl
ElHEl
ElHEl
ElHEl
ElHEl
ElHEl
ElHEl
ElHEl
ElHEl
ElHEl
ElHEl
ElHEl
ElHEl
ElHEl
ElHEl
ElHEl
ElHEl
ElHEl
ElHEl
ElHEl
ElHEl
ElHEl
ElHEl
ElHEl
ElHEl
ElHEl
ElHEl
ElHEl
ElHEl
ElHElElElEl ElElx El Elx El Elx El
Elx El Elx El
|El El@ElEl,/El El El
El El
El El
ElH El
El El El
El El
H El<`ElhElpElxElEl El El El ElH Elx ElSwitchboard ItemsElPrimaryKeyElElvLVAL 5 * \ R 2 * # 5 * \ R 1 * # d * \ R 1 * # a * \ R 0 * # 2 * \ R 2 * # 2 b * \ R 1 * # 1 $ * \ R f f f f * c d 3 2 7 7 0 5 4 e p ? l hR0 hH h<` h>x h h@ h hn h hb
h(8 hpP p ( Zx h @ $ h h ` rP h h h
$ h8 h ! n h (, a $ h4 h8 h % (. $ ! n (0@ 8 ( h<X h h@p hB hF ! hH $ $ % hJ ( ( % h * * h hN , , hR 0 0 hT0 4 4 hXH 6 6 hZ8 8 4 $ 4 $ $ tP
$ @p $ d @ @ 2 ElElElEl`El`sEl`El`El`El`El`El`El`El`El`El`El`El`El`El`El`El`El`El`El`El`El`El`El`El`El`El`El`El`El0El HEl@El ElElPElSwitchboard Items
PrimaryKeyElPElEl
ElElEl`El@ElEl@ElpElx El %LVAL 1 N B@ {& bc@ bc@ ~sq_fSwitchboard1111111111/ {QZc@{QZc@ ~sq_ctopic_type~sq_ctopic Subform * @
O ZZZNBBBBBB@ ` ,Yc@,Yc@ ~sq_fdepartment * @O HHH<000000. ` ,Yc@,Yc@ ~sq_cdepartment~sq_cid_employee * @ 0 2 =Bb
c< e
g .Bc@Sw 0 2 =Bb
ce
g h iGj"k ,[ItemNumber] = 0 AND [Argument] = 'Default' .Bc@Switchboard Items Switchboard[Event Procedure][Event Procedure]Arial d 2 e 12 bRcRf bg 2 3 7bch bcg h
MS Sans Serif ` Detail d 5]8`8ae b:cd Label2 tm-extensionTimes New Romanh 1U`Yabcg
Option1=HandleButtonClick(1)Systemd 5U`abc OptionLabel1=HandleButtonClick(1)h 1U`YaQbcg
i Option2=HandleButtonClick(2)Systemd 5U`aQbc OptionLabel2=HandleButtonClick(2)h 1U`Yabcg
i Option3=HandleButtonClick(3)Systemd 5U`abc OptionLabel3=HandleButtonClick(3)h 1U`Yabcg
i Option4=HandleButtonClick(4)Systemd 5U`abc OptionLabel4=HandleButtonClick(4)h 1U`Ya=
bcg
i Option5=HandleButtonClick(5)Systemd 5U`a=
bc OptionLabel5=HandleButtonClick(5)h 1U`Ya bcg
i Option6=HandleButtonClick(6)Systemd 5U`a bc OptionLabel6=HandleButtonClick(6)h 1U`Ya
bcg
i Option7=HandleButtonClick(7)Systemd 5U`a
bc OptionLabel7=HandleButtonClick(7)h 1U`Ya)bcg
i Option8=HandleButtonClick(8)Systemd 5U`a)bc OptionLabel8=HandleButtonClick(8)d 58`a8 b:cd Label1 tm-extensionTimes New Romanf 3U5abZHorizontalDividingLineLVAL @k(x= Pyy L @ @ @ @ @ & bc@ bc@ ~sq_fSwitchboard* @O ===1111111/ @ {QZc@{QZc@ ~sq_ctopic_type~sq_ctopic Subform * @
O ZZZNBBBBBB@ ` ,Yc@,Yc@ ~sq_fdepartment * @O HHH<000000. ` ,Yc@,Yc@ ~sq_cdepartment~sq_cid_employee * @O XXXL@@@@@@> ` Yc@Yc@ ~sq_cdepartment~sq_cemployee Subform * @O ]]]QEEEEEEC ` $/Bc@b/Bc@ Switchboard,,,,,,,,,,* X(Bc@)Bc@ Switchboard Items @ >>>22222220 @ ڧq\@\K^@ association_type @ O ===1111111/ @ #g^@~+Nc@ topic_type @v LWF000 @ ~ UI77++++++) m1q\@hD `@ employee Subformv @| LWF000 @ } [O==111111/ b6s\@)_@ associations @v LWF000 x WK99------+ "_@R_@ association Subform @v LWF000 @ w ^R@@4444442 -ܸq\@-ܸq\@ SummaryInfoB @u 888,,,,,,,* @ is\@is\@ Reference4++++++++++) cq\@cq\@ Reference2++++++++ ͬ yRK.(a Detail SwitchboardID ͬ yRK.(a Detail SwitchboardID ItemNumber ItemText Command Argument d
Label2 h Option1 h
Option2 h Option3 h Option4 h
Option5 h Option6 h Option7 h Option8 d
Label1 f HorizontalDividingLine d
OptionLabel1 d
OptionLabel2 d
OptionLabel3 d
OptionLabel4 d
OptionLabel5 d
OptionLabel6 d
OptionLabel7 d
OptionLabel8 LVAL 0 $ J $ $ $ J@ $ p $ p x 0 @ x @H h @d @` T @D @4 @0 ( h H ` P 0 @x h @h X @T @ R " @P " ( @L @ < % 0 @8 , @ @ @ @ 0 H 8 ME " < B P 8
" : Y 0 P X " ` 6 h * 6 4 8 @ p . A " A LVAL
4 0 0 h * D J & + H : ` D < 2 8 @ O P & O p , b
,
( 8 B @ 8 H 2 8 0 @ P ` & p 4 8 0 * . @ F e p B B +
X
h x
" < 5
(
Y 0
P
h
Y p
I
"
4
0 ( X ` 2 O 8
Y 0 8 X ` h D *
+
(
, 0
`
p
2
4
( $ 0 @ H 8 + P x 0 6 Minimize the database window and initialize the form. < Move to the switchboard page that is marked as the default. , [ItemNumber] = 0 AND [Argument] = 'Default' ( ( l 4 Update the caption and fill in the list of options. " $ ( A@ l / Fill in the options for this switchboard page. LVAL # The number of buttons on the form. Z Z ( Z H Z h Z / Set the focus to the first button on the form, - and then hide all of the buttons on the form 9 but the first. You can't hide the field with the focus. "B@. Option $ ( OptionLabel $ ( . Open the table of Switchboard Items, and find * the first item for this Switchboard Page. $ . ! SELECT * FROM [Switchboard Items] ' , WHERE [ItemNumber] > 0 AND [SwitchboardID]= " ' ORDER BY [ItemNumber]; ' % . 3 If there are no options for this Switchboard Page, = display a message. Otherwise, fill the page with the items. ! , There are no items for this switchboard page "( a ! Option " $ ( OptionLabel " $ ( " OptionLabel " $ ( B@ h & Close the recordset and the database. B@B B@B l 2 This function is called when a button is clicked. + intBtn indicates which button was clicked. 1 Constants for the commands that can be executed. Z Z 0 Z H Z ` Z x Z Z Z An error that is special cased. Z Z Z 2@ - Find the item in the Switchboard Items table 1 that corresponds to the button that was clicked. $ . Switchboard Items 4 % . [SwitchboardID]= " AND [ItemNumber]= B@6 < If no item matches, report the error and exit the function. ! 8 7 There was an error reading the Switchboard Items table. A@6 B@B B@B s h x " LVAL Go to another switchboard. H Q % [ItemNumber] = 0 AND [SwitchboardID]= " ( Open a form in Add mode. "H Q " < 0B@:
Open a form. $H Q " 0B@: Open a report. &H Q " @ 0B@> Customize the Switchboard. (H Q . Handle the case where the Switchboard Manager ) is not installed (e.g. Minimal Install). WZMAIN80.sbm_Entry ZB@B 8 F Command not available.A@6 g @ Update the form. , [ItemNumber] = 0 AND [Argument] = 'Default' ( " $ ( A@ Exit the application. *H Q A@D
Run a macro. ,H Q " 0B@F
Run code. .H Q " ZB@B # Any other command is unrecognized. P Unknown option. A@6 k & Close the recordset and the database. B@B B@B Hx s p 2h , If the action was cancelled by the user for - some reason, don't display an error message. " Instead, resume on the next line. 8 0 a ) There was an error executing the command. nA@6 Hp h h f ` X Attribut e VB_Nam e = "For m_Switch board"
Bas0{8 A791F19- 52A1-4BA A-8613-2 E281761FC1E}
|Cre atablTrue ]Predecla Id "@Expose Fals
@Temp lateDeriv%Custom izD$Option Comp @ DTv
P&* Sub Open(Ca ncel As Integer)
' Mini-e the d" window and tiPalizf.M2 ov o s pag at is ma$rknas2ef0ault "!Me.Filter [ItemNumber]0 A ND [Argument'DC' jOn@ C`q
E /@@DC(urr@(@Up=A+e caCU>0fill@?,list of os@@/C = N z(Me!0Text], "" A#8lls
'@ D
C'! a%@V\&' TsnR. tons^ @zDqA"Ct con]But1B = 8)Dim dbsr@FRecor0dset stPrSQLA
SngGint8DCC' Set^0focufiw
C),6n hide a7`6 e@#
. You@n LVAL 'tfield`bthg -! >C1].FC o6 = 2 To',("" &).Visi~+Label NRg ' !Ý& rs,f c#a2ivRIP 'd%a:H= oDbA\DE SELE CT * FROM []~& & " WHERdE > ID]=%a7Q ORDER BY] ;d =d.;A)a( Ā'Ifa-r@T` noŊ7(&\dis y a messa+ O0rwise, b2#V3 A-`(.EOF)nAYbJ Z"
͐"E"! a Whi (Not "EMe`$0^14?^G.Mq7Wend ɡiIfWtCl@!! reT6 5yD4w4. oF(uncrHQle^Click(@XxBtnXac`efU c`T{whe.nP'TA}cAed` 'AEAic s which ]ws 'nstantsd$w8ommP
Qpca n be exe c@qjCmdGoto;1I81AdA2Brow¢3?1Report@V4e5E@xitAppab= 6ORunMacro79ComBz' An error@$3spec`l৴#vErrDo#l i503OЫ!P(#H
p Gon&_/F"/Do# "g h5t
ha!ospondfd&&
_gVg[w["",] DyntK9 F"kfB`@~"íqEBiS9# [@bmaexr(B 32id< 5_NoM~_sgBox "#^!7S ding !.^I!J 1 A0 ICQSelePct C `!v[A] '@ Go to@Sor i$QC7q? 9U _B
aQOmہ/Im<
np
&K;, acE7
POdObc*SU_S4WI Argument ], acPre view
' Cust omize th e Switch@board.C ase conC 0) Th en MsgBox "Comm rTavailable. IGoTo 0 .' Updatform hMe.Filt er = "[I temNumber]0 AND [ 'Default' BCapA=@ Nz(hMe!BT H "L")% lO sˉExitaR A
H[Clo@seCurr Dpatab ga macroD MA Do@Av rst!GHOcodeC KMAny o r̃unre0cogn NEl seřUnknown oBd
End Sele~c C AWBiArdset TA{M7- .1cdbs
xButt~ gk_::A FuncK+ɰrr' i!a was cance{by us@]` ' s ome reas on, don' t display eb}mes s@ `ead,onB n@] lin=z=3n |"GC#}!?5%5`AanexecutingcC.", vbCri LVAL tl .>Ifc
)0_ _ S R P _ 3 P rU YT !U IU U U 1 aa U U !V QV yV V X X Y 9A Y Y QZ Z Z 9a P aa O @ 4 Q IQ @ 8 Q aQ @ < Q yQ @ @ Q Q @ D Q Q @ H Q Q @ L Q Q @ P J y !R @ T J y 9R @ X J y aR @ \ J y R @ ` J y R @ d J y R @ h J y S @ l J y )S @ p J y QS @ t aJ Y J 1 @ x yI J p p p @ | J y P ~ ~ ~ @ Q 1Q x ? P
0
8 h cLVAL orN
`v X ` h o [ ) $ $ i i 8 i ` ( Lk
i i $ h Yd:h %x
x
$ 4:D %QdoT%" $
, 4`#0
X /0x6 T4 cR L h $ 0 x d T 4 H .T:X %h
h
$ T
) hT ncP AfX%T kn#L*F<%h
h
$ T /L) hT5< AfX%T
kn#L*F<%h
h
$ T /L) hT5<
ndP? h" $
Qhx Cp Jlp *F,T:X %h
h
$ Ta< `1p) hT6 ,< lp *1p +h' %',%'<%lpx
Qht6 <, t
4 k 2: %T:X %h
h
$ T ) hT t
4 k Oc%T: <:X %t
$ <,%h
h
$ T ) hT6 <, Oc%T:
<:X %t
$ <,%h
h
$ T ) hT6 <, b : %t
$ %T:
<:X %t
$ <,%h
h
$ T ) hT6 <,
t
t
x
X 0 x p t $ L h T < , 0 t t C _ _ S R P _ 2 rU ( ` 0 &$ ) ` $ i ` , ` &/ p LVAL i _ V B A _ P R O J E C T 1! a^ * \ G { 0 0 0 2 0 4 E F - 0 0 0 0 - 0 0 0 0 - C 0 0 0 - 0 0 0 0 0 0 0 0 0 0 4 6 } # 3 . 0 # 9 # C : \ P r o g r a m F i l e s \ C o m m o n F i l e s \ M i c r o s o f t S h a r e d \ V B A \ V B A 3 3 2 . d l l # V i s u a l B a s i c F o r A p p l i c a t i o n s * \ G { 4 A F F C 9 A 0 - 5 F 9 9 - 1 0 1 B - A F 4 E - 0 0 A A 0 0 3 F 0 F 0 7 } # 8 . 0 # 0 # C : \ P R O G R A ~ 1 \ M I C R O S ~ 2 \ O f f i c e \ M S A C C 8 . O L B # M i c r o s o f t A c c e s s 8 . 0 O b j e c t L i b r a r y * \ G { 0 0 0 2 5 E 0 1 - 0 0 0 0 - 0 0 0 0 - C 0 0 0 - 0 0 0 0 0 0 0 0 0 0 4 6 } # 4 . 0 # 0 # C : \ P r o g r a m F i l e s \ C o m m o n F i l e s \ M i c r o s o f t S h a r e d \ D A O \ D A O 3 5 0 . D L L # M i c r o s o f t D A O 3 . 5 1 O b j e c t L i b r a r y * \ G { E A B 2 2 A C 0 - 3 0 C 1 - 1 1 C F - A 7 E B - 0 0 0 0 C 0 5 B A E 0 B } # 1 . 1 # 0 # C : \ W I N D O W S \ S y s t e m 3 2 \ s h d o c v w . d l l # M i c r o s o f t I n t e r n e t C o n t r o l s * \ G { F 5 0 7 8 F 1 8 - C 5 5 1 - 1 1 D 3 - 8 9 B 9 - 0 0 0 0 F 8 1 F E 2 2 1 } # 4 . 0 # 0 # C : \ W I N D O W S \ s y s t e m 3 2 \ m s x m l 4 . d l l # M i c r o s o f t X M L , v 4 . 0
G> V X T M
73e47b437 *D> 0 ف 8 F o r m _ o c c u r r e n c e _ t y p e s u b f o r m
63e47b433 *D o
F o r m _ S w i t c h b o a r d
a3e47b468 *DK P $ p LVAL < < x x \)?` X h
5e Pp@@@5e
2
2
2
2 +employee.association.instanceOf association employee.association.member_1 employee.association.member_2%employee.association_type.role_type_1association_type%employee.association_type.role_type_2
\8rc@@P * 0
501 e01 @ 01 01 01 employeeassociation_type x P\K^@ association
`
P,3^@ ~sq_cemployee~sq_cassociationsP P p Pp,X0@ EpE501EREe01data e01reso e01inst e01ȗ1 association_type association0 )P YX y` h p Pp001E u01ype association_type P
X
501id]-Ee01 01X E Eassociation 5@ eH P Pph __idh
H @Xp
LVAL
| ` p1 H| PP 10x(
H
x
<HHxassociation_type8HPrimaryKeyid_association_type associationPrimaryKeyid_association_typeid_association H`
PrimaryKeyhv v x s 0 P X association
8@Pt
h [__id]
member_1p`
association_type
PrimaryKey
PrimaryKey
XLVAL d orvY reason vbCrLf rootElb
vbCritical+} documentElementE ( AddTopics: xo
nodInstanceOf nodTopicRef addOccurrences?7
rstTempOcc% topic_id\ occ_data
nodOccurrenceB nodResRef nodRes$ ( AddAssociations nodAssociation# nodMember nodRole
_B_var_prolog,
_B_var_rootEl _B_var_x _B_var_nodInstanceOf} _B_var_nodTopicRef_
_B_var_SQL3 _B_var_nodOccurrence _B_var_nodResRef8 _B_var_nodAssociations; _B_var_nodMemberr _B_var_nodRole debog _B_var_debog Right
_B_var_Right9 tmF_ tk _B_var_tm xlink> href Sort topicmapsG org core psi^ display operatm! xmlns rec re^ occurrence_type
SwitchboardID
ItemNumberhG ItemText Command] Argument= VerticalShadowBoxy Label2, Picture* Option1 Option2 Option3 Option4 Option5 Option6 Option7 Option8 HorizontalHeaderBox Label1, HorizontalDividingLine/ OptionLabel1q) OptionLabel2r) OptionLabel3s) OptionLabel4t) OptionLabel5u) OptionLabel6v) OptionLabel7w) OptionLabel8x) Form_Open- Filter; FilterOn& Form_Current Captionx Nzu^ FillOptions
conNumButtons rst strSQLF intOption8 Visible HandleButtonClickEx intBtn( conCmdGotoSwitchboard conCmdOpenFormAdd% conCmdOpenFormBrowse conCmdOpenReport conCmdCustomizeSwitchboardb conCmdExitApplication conCmdRunMacroM
conCmdRunCodew conErrDoCmdCancelled HandleButtonClick_Err
dbOpenDynaset
PrimaryKey P P LVAL < 8 x 8 )?8
a9ay0XpHHHH9ay
2
2
2 employee.last_nameemployeeemployee.first_nameemployee.date_of_birth*employee.salary department.name departmentid
\8rc@, s 901 \a01 y01 01 01 01 department dH;+q\@employee pdH;+q\@
~sq_femployee 0 X p 0Xp01x department 901:a01 y01 01 employee 9 a y 0Xpemployee id_employee
@Xp
H@ p
p
p p
p`|
HX1P
LVAL Y H *0 [ C:\WINDOWS\System32\shdocvw.dll SHDocVw
a X Q ! C:\WINDOWS | HXH 1@
P
@P
"employee_"
@ [employee]![id_employee]$pdepartmentPrimaryKey
id_departmentid_boss employee 0PrimaryKey
id_department id-employeedepartmentemployee Xp h p`
PrimaryKeyv XHv `s px
departmentX0employee
id_department(X
id_departmentX$
xD (h
id_department(P(p LVAL e_' & id_association_type AS id, name FROM association_type; 2 WHERE topic.instanceOf = topic_type.id_topic_type; 0 \ SELECT DISTINCT 'role_type_' & role_type_1 AS id, role_type_1 AS name FROM association_type;0 \ SELECT DISTINCT 'role_type_' & role_type_2 AS id, role_type_2 AS name FROM association_type;
FROM topic, topic_type name FROM department; * P SELECT 'occurrence_type_' & id_occurrence_type AS id, name FROM occurrence_type;> y SELECT topic_type.name & '_' & 0 =Bb
cn!e
g h ijY.k o ;s\@SELECT DISTINCTROW employee.last_name, employee.first_name, employee.date_of_birth, employee.salary, department.name, "employee_" & [employee]![id_employee] AS id FROM department INNER JOIN employee ON department.id_department = employee.id_department;employeeArial d 2 e 12 bRcRf 5bg 2 3 7bch bcg h
MS Sans Serifi 1g hj 1g hk 1bcl 23 : bc g[m 4bg[ n 2cdh[ o 2ej[ p 5bcr 35cd z bci j
MS Sans Serif{ 5 bcJ
`
FormHeader `F Detail
m 7U;`ar bc e last_name last_named 5U`9 ar bc last_name Label last namelast_name_Labelm 7U;`abc e k
first_name
first_named 5U`9 abc first_name Label
first namefirst_name_Labelm 7U;`abc e9k
date_of_birth
date_of_birthd 5U`9 abc date_of_birth Labeldate of birth date_of_birth_Labelm 7U;`aq bc e k salarysalaryd 5U7`I
aq bc salary Labelsalary salary_Labelm 7U;`abc e k namenamed 5U7`I
abc
name Labeldepartment name
name_Labelm 7U;`abc k Text10idd 5U7`I
abgc Label11idp 3U`8 azb!cd associationsForm.associationsmember_1idp 3U`8 a{
b cd occurrence_type subformForm.occurrencesid_topicidoccurrence_type_subformd 5U`< amb2
c Label18
associations:d 5U`8 a` b2c Label19 occurrences: `
FormFooterzLVAL Ȋ))) =Bb
c e
g hm i3 jz+k ;mc@association_typeassociation =Bb
ce
g h iDj(k1 ,zhc@occurrence_typeoccurrence_typeArial d 2 e 12 bRcRf 5bg 2 3 7bch bcg h
MS Sans Serifi 1g hj 1g hk 1bcl 23 : bc g[m 4bg[ n 2cdh[ o 2ej[ p 5bcr 35cd z bci j
MS Sans Serif{ 5 bcJ
`b
FormHeader d 5U7`9 a9 bc id_occurrence_type Labelid_occurrence_type
DetachedLabelid_occurrence_type_Labeld 5U7`a9 b c
name Labelna =Bb
ce
g h iDj(k1 ,zhc@occurrence_typeoccurrence_typeArial d 2 e 12 bRcRf 5bg 2 3 7bch bcg h
MS Sans Serifi 1g hj 1g hk 1bcl 23 : bc g[m 4bg[ n 2cdh[ o 2ej[ p 5bcr 35cd z bci j
MS Sans Serif{ 5 bcJ
`b
FormHeader d 5U7`9 a9 bc id_occurrence_type Labelid_occurrence_type
DetachedLabelid_occurrence_type_Labeld 5U7`a9 b c
name Labelname
DetachedLabel
name_Labeld 5U7`Va9 b c datatype Labeldatatype
DetachedLabeldatatype_Label `q Detail m 7U`9 a9 c eid_occurrence_typeid_occurrence_typem 7U`a9 b c e k namenameo 05UbScVd9 e f h n datatypedatatype
Value List1"Integer";"Float";"Date";"String";"Boolean";"URI"1875 `
FormFooter6LVAL Bg< OptionLabel2 OptionLabel3 OptionLabel4 OptionLabel5 OptionLabel6 OptionLabel7 OptionLabel8 Form_Open Form_Current FillOptions HandleButtonClick
, [ItemNumber] = 0 AND [Argument] = 'Default' ]协N ? ItemText tpY ? Option1 SetFocus Option Visible OptionLabel ! SELECT * FROM [Switchboard Items] AND [ItemNumber]=
, WHERE [ItemNumber] > 0 AND [SwitchboardID]=
SwitchboardID
ORDER BY [ItemNumber]; , There are no items for this switchboard page OptionLabel1 Caption
ItemNumber
Switchboard Items
[SwitchboardID]=
7 There was an error reading the Switchboard Items table. Command % [ItemNumber] = 0 AND [SwitchboardID]= Argument `GX GP WZMAIN80.sbm_Entry fĤIx 8<
Command not available. Unknown option. ) There was an error executing the command. {JEiTO OXZMb1 EA] iH%HxR GE N+
K _ _ S R P _ 1 rU ~ ~ ~ ~ ~ ~ ~ ~ ~ ~k
Y rstTemp root addOccurrences yI ( I 8 !J H aJ X J h YP x P Q Cancel intBtn; LVAL 5' @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ =Bb
c e
g hm i3 jz+k6 ;mc@association_typeassociation_typeArial d 2 e 12 bRcRf 5bg 2 3 7bch bcg h
MS Sans Serifi 1g hj 1g hk 1bcl 23 : bc g[m 4bg[ n 2cdh[ o 2ej[ p 5bcr 35cd z bci j
MS Sans Serif{ 5 bcʾ Switchboard Items all_topics Switchboard XTM 9 ' U S =Bb
c e
g hm i3 jz+k6 ;mc@association_typeassociation_typeArial d 2 e 12 bRcRf 5bg 2 3 7bch bcg h
MS Sans Serifi 1g hj 1g hk 1bcl 23 : bc g[m 4bg[ n 2cdh[ o 2ej[ p 5bcr 35cd z bci j
MS Sans Serif{ 5 bcJ
`b
FormHeader d 5U7`9 a9 bc id_association_type Labelid_association_type
DetachedLabelid_association_type_Labeld 5U7`ua9 bc
name Labelname
DetachedLabel
name_Labeld 5U7`a9 bc role_type_1 Label role_type_1
DetachedLabelrole_type_1_Labeld 5U7`a9 bc role_type_2 Label role_type_2
DetachedLabelrole_type_2_Label `q Detail m 7U`9 a9 bc eid_association_typeid_association_typem 7U`ua9 bc e k namenamem 7U`a9 bc e k role_type_1 role_type_1m 7U`a9 bc e k role_type_2 role_type_2 `
FormFooter LVAL i _ V B A _ M O D U L E T f|Mtf x O
m V k
o
SL S S <( <, < < < < < <$ <0 <4 <8 << < N 0 { 0 3 1 9 2 9 5 8 - 8 7 2 1 - 4 5 B E - 8 7 F F - 5 C 2 4 7 8 4 4 A F 5 2 } ` (
$ $ ` 0 $ $ D< ` @ $ a 3 0 $ $ y s $ ( R A $ X ~ 1 $ $ $ $ $ P $ $ $ $ $ h @ H $ $ $ $ 0 H $ x $ $ $ P g LVAL s @ @ @ @ @ @ @ @ @ @ ` 86 H x @ h h d @ T @ D @ 4 0 @ , O W ; C @ C : @ y s @ ; C @ R A @ 2 ; x x ( h ($ ME " p J ( 0 $ : X h 8 . u x 9 p (` *! ,B@. 0B@2 48 u 0 (( 8! :A@6 4 l x l x p @ datatype ! J% L uri F link ! J% L A@T g 8 l $ B 9 Bu a n link ! J% L link Could not follow URI: link ! J% L A@6 J% Lh 8! v Error 8! v , 8! : A@6 ( Attribut e VB_Nam e = "For m_occurr ence_typ@e subf \"D
Basf0 {0319295 8-8721-45BE FF-5 C247844AF52}
|Cre atablCTrue ]Predecla Id "@Expose Fals
@Temp lateDeriv%Custom izD$Option Comp @ DTv
P&* Sub link_Click()
On Error GoTo er rhandlerIf Me. Controls .Item("d 1")uri " Then F@ollowH r6 "), , C4ExitӁS
G: @"@+.Numberq 432B CM sgBox (" Could not fB$ URI`: " &V$DDE?BfCIH & ",Desc ribnd I0f
E_
gLVAL s 18R. % R. \ 18R. % R. 18R. % R. 18R. u u % R. X18R. * % R. 18R. % R. 18R. * % R. T18R. 0=Bb
c e
g
hijA(k[ b4_@SELECT DISTINCTROW occurrence_type.name, occurrence.id_topic, occurrence_type.datatype, occurrence.resource, occurrence.instanceOf FROM occurrence_type INNER JOIN occurrence ON occurrence_type.id_occurrence_type = occurrence.instanceOf;occurrence_type subformArial d 2 e 12 bRcRf 5bg 2 3 7bch bcg h
MS Sans Serifi 1g hj 1g hk 1bcl 23 : bc g[m 4bg[ n 2cdh[ o 2ej[ p 5bcr 35cd z bci j
MS Sans Serif{ 5 bcJ
`b
FormHeader d 5U7`x a9 b c id_topic Labelid_topic
DetachedLabelid_topic_Labeld 5U7`a9 b c
link Labelresource
DetachedLabel
link_Label `x Detail o 5U` bcx d9 e f h'i "";"";"";"";"";"";"10";"0"id_topicid_topic Table/QueryaSELECT DISTINCTROW [all_topics].[id], [all_topics].[type], [all_topics].[name] FROM [all_topics];0;0;1441m 7U` a8 ef k resourceresource[Event Procedure]o 05UbScd8 i n datatypedatatype
Value List="integer";"float";"date";"string";"boolean";"uri";"hyperlink"1875o 5U` bcodq hn
i n "";"";"";"";"10";"50"occurrence type
instanceOf Table/QuerykSELECT DISTINCTROW [occurrence_type].[id_occurrence_type], [occurrence_type].[name] FROM [occurrence_type];0;1440occurrence_type `
FormFooterLVAL N % R. <18R. % R. 18R. % R. 18R. 4 % R. 8 18R. % R. 18R. % R. 18R. % R. 4
18R. % R.
18R. * % R.
18R. * % R. 0 18R. * % R. 18R. % R. 18R. % R.x , 18R. % R. 18R. * % R.' 18R. * % R. (
18R. % R. |
18R. % R.p
18R. * % R.q $18R. * % R.s x18R. % R. 18R. ͬ X)!E\$xDR FormHeader d
id_topic_Label id_topic Label d
link_Label link Label Detail o id_topic m resource o datatype FormFooter o
occurrence_type occurrence type LVAL i _ V B A _ M O D U L E T f|Mtf x O
m V k
o
SL S S <( <, < < < < < <$ <0 <4 <8 << < N 0 { 0 3 1 9 2 9 5 8 - 8 7 2 1 - 4 5 B E - 8 7 F F - 5 C 2 4 7 8 4 4 A F 5 2 } ` (
$ $ ` 0 $ $ D< ` @ $ a 3 0 $ $ y s $ ( R A $ X ~ 1 $ $ $ $ $ P $ $ $ $ $ h @ H $ $ $ $ 0 H $ x $ $ $ P g LVAL s ` 86 H x @ h h d @ T @ D @ 4 0 @ , O W ; C @ C : @ y s @ ; C @ R A @ 2 ; x x ( h ($ ME " p J ( 0 $ : X h 8 . u x 9 p (` *! ,B@. 0B@2 48 u 0 (( 8! :A@6 4 l x l x p @ datatype ! J% L uri F link ! J% L A@T g 8 l $ B 9 Bu a n link ! J% L link Could not follow URI: link ! J% L A@6 J% Lh 8! v Error 8! v , 8! : A@6 ( Attribut e VB_Nam e = "For m_occurr ence_typ@e subf \"D
Basf0 {0319295 8-8721-45BE FF-5 C247844AF52}
|Cre atablCTrue ]Predecla Id "@Expose Fals
@Temp lateDeriv%Custom izD$Option Comp @ DTv
P&* Sub link_Click()
On Error GoTo er rhandlerIf Me. Controls .Item("d 1")uri " Then F@ollowH r6 "), , C4ExitӁS
G: @"@+.Numberq 432B CM sgBox (" Could not fB$ URI`: " &V$DDE?BfCIH & ",Desc ribnd I0f
E_
gLVAL so T T
2c ct
j O
IdParentIdNameType
DateCreate
DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtra setni T
Id Par 0=Bb
c e
g
hijA(k[ b4_@SELECT DISTINCTROW occurrence_type.name, occurrence.id_topic, occurrence_type.datatype, occurrence.resource, occurrence.instanceOf FROM occurrence_type INNER JOIN occurrence ON occurrence_type.id_occurrence_type = occurrence.instanceOf;occurrence_type subformArial d 2 e 12 bRcRf 5bg 2 3 7bch bcg h
MS Sans Serifi 1g hj 1g hk 1bcl 23 : bc g[m 4bg[ n 2cdh[ o 2ej[ p 5bcr 35cd z bci j
MS Sans Serif{ 5 bcJ
`b
FormHeader d 5U7`x a9 b c id_topic Labelid_topic
DetachedLabelid_topic_Labeld 5U7`a9 b c
link Labelresource
DetachedLabel
link_Label `x Detail o 5U` bcx d9 e f h'i "";"";"";"";"";"";"10";"0"id_topicid_topic Table/QueryaSELECT DISTINCTROW [all_topics].[id], [all_topics].[type], [all_topics].[name] FROM [all_topics];0;0;1441m 7U` a8 ef k resourceresource[Event Procedure]o 05UbScd8 i n datatypedatatype
Value List="integer";"float";"date";"string";"boolean";"uri";"hyperlink"1875o 5U` bcodq hn
i n "";"";"";"";"10";"50"occurrence type
instanceOf Table/QuerykSELECT DISTINCTROW [occurrence_type].[id_occurrence_type], [occurrence_type].[name] FROM [occurrence_type];0;1440occurrence_type `
FormFooterLVAL S S 2 ObjectIdSIDACM FInheritable bc
ObjectId s
Wizardss
k Database experts that ask you questions about the item you want to create, and then build the item for you.
T lA@ lA@ USysRegInfo @X 888,,,,,,,* @ JqlA@JqlA@ MSysModules2----------+ JqlA@JqlA@ MSysModules,,,,,,,,,,* lA@ڬlA@ cnf_tblStrings @X ;;;///////- @
jmA@LD@ cnf_modMain,,,,,,,,,,*
mA@mA@ cnf_sfrmResolve @ Z LWF000 @W ZN<<000000. `ymA@D@ cnf_frmResolve//////////-
HmA@D@ cnf_frmMain,,,,,,,,,,* 2mA@LD@ cnf_frmDesignErrors44444444442 @ mA@LD@ cnf_frmDataErrors22222222220 RnlA@RnlA@ UserDefined,,,,,,,,,,* RnlA@RnlA@ SummaryInfo @X 888,,,,,,,* @ 4MmA@%F /D@ AccessLayout* @ X @ W E99-------+ @ rlA@rlA@ SysRel''''''''''% rlA@rlA@ Scripts((((((((((& rlA@rlA@ Reports((((((((((& rlA@rlA@ Modules((((((((((& JqlA@JqlA@ Forms&&&&&&&&&&$ IHilA@IHilA@ MSysRelationships22222222220 IHilA@IHilA@ MSysQueries,,,,,,,,,,* IHilA@IHilA@ MSysACEs))))))))))' IHilA@IHilA@ MSysObjects,,,, ͬ X)!E\$xDR FormHeader d
id_topic_Label id_topic Label d
link_Label link Label Detail o id_topic m resource o datatype FormFooter o
occurrence_type occurrence type