LINKING TABLES

Tue, 16 Nov 2004 16:57:28 EST

-------------------------------1100642248
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit

Kristina,

By dictionary file, I assume that you mean an RMS file.  IIRC, you cannot 
link on a non-indexed field to anything other than a relational table.

jb

In a message dated 11/16/2004 3:41:51 PM Central Standard Time, 
Kristina.Carlton@JICompanies.com writes:
Hi List, 
I am using OpenVMS v7.3-2 and Quiz V7.10.G4. 
A while back I had trouble linking tables and got some help from this list. 
Everything has been working great, but today I ran into a problem again. My 
attempt is to access a subfile, then link it to a dictionary file via one field, 
which is not indexed.
This is my access statement:
ACC *DKF1:[DW]DWDTL ALIAS DWDTL LINK DOCUMENT_NUM OF DWDTL  TO DOCUMENT_NUM 
OF DTL
And the resulting error message:
*E* Item(s) DOCUMENT_NUM not defined as an index of DTL.
Can someone point out what I am doing wrong?

Thanks,
Kristina Carlton
Senior Programmer/Analyst
The JI Companies
512.427.2459
kristina.carlton@jicompanies.com

-------------------------------1100642248
Content-Type: text/html; charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

<HTML xmlns:o =3D "urn:schemas-microsoft-com:office:office"><HEAD>
<META charset=3DUS-ASCII http-equiv=3DContent-Type content=3D"text/html; cha=
rset=3DUS-ASCII">
<META content=3D"MSHTML 6.00.2900.2180" name=3DGENERATOR></HEAD>
<BODY style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #fffff=
f">
<DIV>
<DIV>Kristina,</DIV>
<DIV>&nbsp;</DIV>
<DIV>By dictionary file, I assume that you mean an RMS file.&nbsp; IIRC, you=
 cannot link on a non-indexed field to anything other than a relational tabl=
e.</DIV>
<DIV>&nbsp;</DIV>
<DIV>jb</DIV>
<DIV>&nbsp;</DIV>
<DIV>In a message dated 11/16/2004 3:41:51 PM Central Standard Time, Kristin=
a.Carlton@JICompanies.com writes:</DIV>
<BLOCKQUOTE style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: blue=20=
2px solid">
Hi List, <o:p></o:p>
I am using OpenVMS v7.3-2 and Quiz V7.10.G4.<FONT=20=
color=3Dblue size=3D1> <o:p></o:p><=
/P>
A while back I had trouble linking tables and got some help from=
 this list. Everything has been working great, but today I ran into a proble=
m again. My attempt is to access a subfile, then link it to a dictionary fil=
e via one field, which is not indexed.<o:p></o:p>
This is my access statement:<o:p></o:p>
ACC *DKF1:[DW]DWDTL ALIAS DWDTL LINK DOCUMENT_NUM OF DWDT=
L &nbsp;TO DOCUMENT_NUM OF DTL</SPA=
N><o:p></o:p>
And the resulting error message:<o:p></o:p>
*E* Item(s) DOCUMENT_NUM not defined as an index of DTL.<=
/SPAN><o:p></o:p>
=
Can someone point out what I am doi=
ng wrong?<o:p></o:p>
=
&n=
bsp;<o:p></o:p>
=
Thanks,<o:p></o:p></S=
PAN>
Kristina Carlton<o:p></o:p>
Senior Programmer/Analyst<o:p></o:p></FO=
NT>
The JI Companies<o:p></o:p>
512.427.2459<o:p></o:p>
<S=
PAN style=3D"FONT-SIZE: 9pt; COLOR: blue">kristina.carlton@jicompanies.com</BLOCKQUO=
TE></DIV>
<DIV></DIV></BODY></HTML>

-------------------------------1100642248--