Hi Leo
Can someone please enlighten me on the sanity of this solution and best
way to achieve this? Alternatively I will have to confine the ranges if
IDs to be unique at each site.
Sanity & Paradox?
I think I need to change the primary key in the master file, and the
reference pointer in the detail file. I have;
MASTER ======= DETAIL
ID (I*) <----- ID
|______owner (I)
I want;
MASTER ======= DETAIL
SITE(A1*) <| ID
ID (I*) <|
|______owner (?)
Paradox enforces Master-Detail relationships thru Primary Key Encapsulation
ie The Detail table must contain all of the Master tables Primary Key (and
in the case of a 1:m relationship the Detail Table must also contain a Key
Break field within its Primary Key).
In your case above to achieve what you want the tables key structures would
be:-
1) In the Case of 1:1 Master Detail
MASTER = DETAIL
Site(A1*) = Site(A1*)
ID(I*) = ID(I*)
2) In the Case of 1:m Master Detail
MASTER = DETAIL
Site(A1*) = Site(A1*)
ID(I*) = ID(I*)
= KeyBreakField(S*)
regards Tim
begin 600 WINMAIL.DAT
M>)\^(BT2`0:0" `$```````!``$``0>0!@`(````Y 0```````#H``$(@ <`
M& ```$E032Y-:6-R;W-O9G0@36%I;"Y.;W1E`#$(`0V ! `"`````@`"``$$
MD 8`* $```$````,`````P``, (````+``\.``````(!_P\!````2P``````
M``"!*Q^DOJ,0&9UN`-T!#U0"`````&1A=&%B87-E0&1E;'!H:2YO<F<N;GH`
M4TU44 !D871A8F%S94!D96QP:&DN;W)G+FYZ```>``(P`0````4```!33510
M`````!X``S !````%P```&1A=&%B87-E0&1E;'!H:2YO<F<N;GH```,`%0P!
M`````P#^#P8````>``$P`0```!D````G9&%T86)A<V5 9&5L<&AI+F]R9RYN
M>B<``````@$+, $````<````4TU44#I$051!0D%314!$14Q02$DN3U)'+DY:
M``,``#D`````"P! .@$````"`?8/`0````0````````"Y#<!!( !`#,```!2
M13H@6T151RU$0ETZ("!H;W<@9&\@22!U<V4@<&%R861O>"!C;VUP;W-I=&4@
M:V5Y<P"K$ $%@ ,`#@```,\'"0`#``8`(0`J``4`. $!(( #``X```#/!PD`
M`P`&``\`,0`%`"T!`0F `0`A````04,X1C1#03!#-38Q1#,Q,3E%-3,P,$,P
M1$8R,C0U-D0`+ <!`Y &`"0%```4````"P`C```````#`"8```````L`*0``
M`````P`N```````#`#8``````$ `.0``O(&N<?6^`1X`< `!````,P```%)%
M.B!;1%5'+41"73H@(&AO=R!D;R!)('5S92!P87)A9&]X(&-O;7!O<VET92!K
M97ES```"`7$``0```!8````!OO5QKH&@3(^M8<41TYY3`,#?(D5M```>`!X,
M`0````4```!33510`````!X`'PP!````$@```'1I;4!T:&EN8VYZ+F-O+FYZ
M`````P`&$,5=3X4#``<0) ,``!X`"! !````90```$A)3$5/0T%.4T]-14].
M15!,14%3145.3$E'2%1%3DU%3TY42$5304Y)5%E/1E1(25-33TQ55$E/3D%.
M1$)%4U1705E43T%#2$E%5D542$E3/T%,5$523D%4259%3%E)5TE,3$@`````
M`@$)$ $```!^`P``>@,``"D'``!,6D9U'" 9I?\`"@$/`A4"I /D!>L"@P!0
M$P-4`@!C: K <V5T[C(&``;#`H,R`\8'$P*#,C,3#V8T`\4"`'!R-G$2(!.(
M-15L!K!S='1E;0* ?0J ",\)V3OQ&2\R-34"@ J!#;$+8.!N9S$P,Q0@"PH5
M4@4,`6,`0"!(:2!,A&5O"HML:3,V#?"O"U44(@P!%?!O& !C!4 U"H5#`Y%S
M`W >4&YETB +4&5A$? @"? ?0%QG:!@``Z '@" "(" 4=&@B$',`<&ET>3TC
M8&8CD00`(:$*0'1IHR-Q`'!D(&('D'0*A>1W820P=&\E4!&P")#6=B(0)((_
M$W!L& `$H-9A)1 G$&PD,$DF0 ,0GP,@$< G$B:@!:!N9@N >R<B(A!R'"$'
MD0:0"H5)3D0$(":1): @=0,`<7\*4"50!4 B4!&P(: D$&4^+@J/'3PM%081
M)!(F(()0"L!A9&]X/QY_SQ^/()PH@"2!;FLH<2(`_PF *3,1P"I1(Y,5\ =P
M"L#Y)#!K920P"X CDP# %_'W!< IH") +"53(Z$M%1DPUF8$D GP8R(1;PN
M-K+?-A4-L &0`Q$V\BXH<2CR`CLM%4U!4U1%4@0@/3OD($1%5$$$24PJQR H
M22HI\" @/"T]TCV@/BHK,"<M%3^//:!\7T#3;W?W(@`%P#U@*2T5,Q<F4 (P
M%SK_/ \O44E#L"A!,?D]@3Q\/C\\[#XB1> _+_M /T%$/T&],/\2U '02USO
M+>\O]B*1`A!R.* /T3:3O"U$.=09, M@)1)S))!B<"M1:')U+_ U94O5->%%
M.)!A4@!U470JD'TB$%0CL5#E`9$B0",P=?\7\"EB.>$E02C!)%,B$%!T]U3T
M!"!2BB@E8C854V B<<$D46$@,3IM44LCDWU0Y515& = (;!5J%+S0OT9,&$S
MX"F@*$ E@ /P,Z)U*I!T5ZLI+08JQ@.@>;<(85DT`:!O*10FQG<1P/\%0
M0K,CDU=5-=(7\%)0=R#0"' 'D7<(8%X1): Z^BU!S#$]D&"A(Z(A<%ED_UG@
M'?!6Y5#D0<Q#A R"0^#_:?-$?"S118-I^6MW*L<]8N]I\VGY;;1!S#)FGUGB
M9^__2SY.3VF/:I]KKVR_;<]NWY=Y;E,!78-&7?(H4V]>?1DP9PL1!" '87+U
M&%$``7^ ```#`! 0``````,`$1 `````0 `',. .4R]O];X!0 `(,. .4R]O
A];X!'@`]``$````%````4D4Z( `````#``TT_3<```&"
`
end
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
