LINKING TABLES

Kristina Carlton Kristina.Carlton@JICompanies.com
Tue, 16 Nov 2004 15:34:21 -0600 

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C4CC24.0A9E5772
Content-Type: text/plain;
	charset="iso-8859-1"

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
 

------_=_NextPart_001_01C4CC24.0A9E5772
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">


<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 9">
<meta name=3DOriginator content=3D"Microsoft Word 9">
<link rel=3DFile-List href=3D"cid:filelist.xml@01C4CBF1.BE74D0A0">
<!--[if gte mso 9]><xml>
 <o:OfficeDocumentSettings>
  <o:DoNotRelyOnCSS/>
 </o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <w:WordDocument>
  <w:View>Normal</w:View>
  <w:Zoom>0</w:Zoom>
  <w:DocumentKind>DocumentEmail</w:DocumentKind>
  <w:EnvelopeVis/>
  <w:DrawingGridHorizontalSpacing>2.15 =
pt</w:DrawingGridHorizontalSpacing>
  <w:DrawingGridVerticalSpacing>1.45 pt</w:DrawingGridVerticalSpacing>
  =
<w:DisplayVerticalDrawingGridEvery>2</w:DisplayVerticalDrawingGridEvery>=

 </w:WordDocument>
</xml><![endif]-->
<style>
<!--
 /* Font Definitions */
@font-face
	{font-family:"Century Gothic";
	panose-1:2 11 5 2 2 2 2 2 2 4;
	mso-font-charset:0;
	mso-generic-font-family:swiss;
	mso-font-pitch:variable;
	mso-font-signature:647 0 0 0 159 0;}
 /* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{mso-style-parent:"";
	margin:0in;
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:9.0pt;
	mso-bidi-font-size:12.0pt;
	font-family:"Century Gothic";
	mso-fareast-font-family:"Times New Roman";
	mso-bidi-font-family:"Courier New";}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
	{margin:0in;
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:9.0pt;
	mso-bidi-font-size:12.0pt;
	font-family:"Century Gothic";
	mso-fareast-font-family:"Times New Roman";
	mso-bidi-font-family:"Courier New";}
p
	{margin-right:0in;
	mso-margin-top-alt:auto;
	mso-margin-bottom-alt:auto;
	margin-left:0in;
	mso-pagination:widow-orphan;
	font-size:12.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:"Times New Roman";}
span.EmailStyle15
	{mso-style-type:personal-compose;
	mso-ansi-font-size:9.0pt;
	mso-ascii-font-family:"Century Gothic";
	mso-hansi-font-family:"Century Gothic";
	mso-bidi-font-family:Arial;
	color:#333399;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;
	mso-header-margin:.5in;
	mso-footer-margin:.5in;
	mso-paper-source:0;}
div.Section1
	{page:Section1;}
-->
</style>
</head>

<body lang=3DEN-US style=3D'tab-interval:.5in'>

<div class=3DSection1>

<p style=3D'margin-right:.5in'><font size=3D1 color=3Dblue =
face=3D"Century Gothic"><span
style=3D'font-size:9.0pt;mso-bidi-font-size:10.0pt;font-family:"Century =
Gothic";
color:blue'>Hi List,</span></font><font size=3D1 color=3Dblue =
face=3D"Century Gothic"><span
style=3D'font-size:9.0pt;mso-bidi-font-size:12.0pt;font-family:"Century =
Gothic";
color:blue'> <o:p></o:p></span></font></p>

<p style=3D'margin-right:.5in'><font size=3D1 color=3Dblue =
face=3D"Century Gothic"><span
style=3D'font-size:9.0pt;mso-bidi-font-size:10.0pt;font-family:"Century =
Gothic";
color:blue'>I am using OpenVMS v7.3-2 and Quiz =
V7.10.G4.</span></font><font
size=3D1 color=3Dblue face=3D"Century Gothic"><span =
style=3D'font-size:9.0pt;
mso-bidi-font-size:12.0pt;font-family:"Century Gothic";color:blue'> =
<o:p></o:p></span></font></p>

<p style=3D'margin-right:.5in'><font size=3D1 color=3Dblue =
face=3D"Century Gothic"><span
style=3D'font-size:9.0pt;mso-bidi-font-size:12.0pt;font-family:"Century =
Gothic";
color:blue'>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.<o:p></o:p></span></font></p>

<p style=3D'margin-right:.5in'><font size=3D1 color=3Dblue =
face=3D"Century Gothic"><span
style=3D'font-size:9.0pt;mso-bidi-font-size:12.0pt;font-family:"Century =
Gothic";
color:blue'>This is my access statement:<o:p></o:p></span></font></p>

<p style=3D'margin-right:.5in'><font size=3D1 color=3D"#333399" =
face=3D"Century Gothic"><span
style=3D'font-size:9.0pt;mso-bidi-font-size:12.0pt;font-family:"Century =
Gothic";
color:#333399'>ACC *DKF1:[DW]DWDTL ALIAS DWDTL LINK DOCUMENT_NUM OF =
DWDTL <span
style=3D"mso-spacerun: yes">&nbsp;</span>TO DOCUMENT_NUM OF =
DTL</span></font><font
size=3D1 color=3D"#333399" face=3D"Century Gothic"><span =
style=3D'font-size:9.0pt;
mso-bidi-font-size:12.0pt;font-family:"Century Gothic";color:#333399;
mso-color-alt:windowtext'><o:p></o:p></span></font></p>

<p style=3D'margin-right:.5in'><font size=3D1 color=3Dblue =
face=3D"Century Gothic"><span
style=3D'font-size:9.0pt;mso-bidi-font-size:12.0pt;font-family:"Century =
Gothic";
color:blue'>And the resulting error =
message:<o:p></o:p></span></font></p>

<p style=3D'margin-right:.5in'><font size=3D1 color=3D"#333399" =
face=3D"Century Gothic"><span
style=3D'font-size:9.0pt;mso-bidi-font-size:12.0pt;font-family:"Century =
Gothic";
color:#333399'>*E* Item(s) DOCUMENT_NUM not defined as an index of =
DTL.</span></font><font
size=3D1 color=3D"#333399" face=3D"Century Gothic"><span =
style=3D'font-size:9.0pt;
mso-bidi-font-size:12.0pt;font-family:"Century Gothic";color:#333399;
mso-color-alt:windowtext'><o:p></o:p></span></font></p>

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D1 =
color=3Dblue
face=3D"Century Gothic"><span =
style=3D'font-size:9.0pt;color:blue'><span
style=3D'mso-bidi-font-size:12.0pt'>Can someone point out what I am =
doing wrong?<o:p></o:p></span></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D1 =
color=3Dblue
face=3D"Century Gothic"><span =
style=3D'font-size:9.0pt;color:blue'><![if =
!supportEmptyParas]>&nbsp;<![endif]></span><o:p></o:p></font></span></p>=


<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D1 =
color=3Dblue
face=3D"Century Gothic"><span =
style=3D'font-size:9.0pt;color:blue'><span
style=3D'mso-bidi-font-size:12.0pt'>Thanks,<o:p></o:p></span></span></fo=
nt></span></p>

<p class=3DMsoAutoSig><!--[if supportFields]><font color=3Dblue><span=20
style=3D'color:blue'><span =
style=3D'mso-element:field-begin'></span><span=20
style=3D"mso-spacerun: yes">&nbsp;</span>AUTOTEXTLIST \s &quot;E-mail=20
Signature&quot; <span =
style=3D'mso-element:field-separator'></span></span></font><![endif]--><=
font
color=3Dblue><span style=3D'color:blue'>Kristina =
Carlton<o:p></o:p></span></font></p>

<p class=3DMsoAutoSig><font size=3D1 color=3Dblue face=3D"Century =
Gothic"><span
style=3D'font-size:9.0pt;color:blue'><span =
style=3D'mso-bidi-font-size:12.0pt'>Senior
Programmer/Analyst<o:p></o:p></span></span></font></p>

<p class=3DMsoAutoSig><font size=3D1 color=3Dblue face=3D"Century =
Gothic"><span
style=3D'font-size:9.0pt;color:blue'><span =
style=3D'mso-bidi-font-size:12.0pt'>The
JI Companies<o:p></o:p></span></span></font></p>

<p class=3DMsoAutoSig><font size=3D1 color=3Dblue face=3D"Century =
Gothic"><span
style=3D'font-size:9.0pt;color:blue'><span =
style=3D'mso-bidi-font-size:12.0pt'>512.427.2459<o:p></o:p></span></span=
></font></p>

<p class=3DMsoAutoSig><font size=3D1 color=3Dblue face=3D"Century =
Gothic"><span
style=3D'font-size:9.0pt;color:blue'><span =
style=3D'mso-bidi-font-size:12.0pt'>kristina.carlton@jicompanies.com<o:p=
></o:p></span></span></font></p>

<p class=3DMsoNormal><!--[if supportFields]><font color=3Dblue><span=20
style=3D'color:blue'><span =
style=3D'mso-element:field-end'></span></span></font><![endif]--><font
color=3D"#333399"><span style=3D'color:#333399'><![if =
!supportEmptyParas]>&nbsp;<![endif]></span></font><font
color=3D"#333399"><span =
style=3D'color:#333399;mso-color-alt:windowtext'><o:p></o:p></span></fon=
t></p>

</div>

</body>

</html>

------_=_NextPart_001_01C4CC24.0A9E5772--