Linking tables
David Morrison - Corporate
dmorrison@mcbrideelectric.com
Wed, 29 Sep 2004 15:07:50 -0700
This is a multi-part message in MIME format.
------_=_NextPart_001_01C4A670.C28C7770
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Kristina,
=20
I'd specify the linkage fields:
=20
ACCESS PRV &
LINK field1 OF PRV, &
field2 OF PRV &
TO field1, field OF PRV ALIAS PRV1 OPTIONAL
=20
CHOOSE VIAINDEX PRVINDEX
=20
David Morrison
McBride Electric
=20
-----Original Message-----
From: powerh-l-admin@lists.sowder.com =
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Kristina Carlton
Sent: Wednesday, September 29, 2004 2:55 PM
To: powerh-l@lists.sowder.com
Subject: Linking tables
Hi List,=20
I am using OpenVMS v7.3-2 and Quiz V7.10.G4.=20
My intention is to link to a table twice but link on different fields. =
The table is self-referencing and contains physician information. Each =
physician has a tin (FEIN) and a sub tin (provider within a facility). =
If the physician works for a clinic he would be listed with the clinic's =
tin plus a sub tin, but the name field would contain his name. The =
clinic has no sub tin.=20
In the case of a physician having his own practice he would be listed =
twice with the same tin, but once without a sub tin and once with a sub =
tin. Each record will have the same name. This would look as follows:
TIN SUB TIN NAME=20
75-261977 Victory Medical Services=20
75-261977 001 Dr. Franklin=20
75-261977 002 Dr. Garcia=20
and so on=20
75-269999 Dr. Williams=20
75-269999 001 Dr. Williams=20
I need to link to this file twice in order to get the physician's name =
as well as the clinic name and also to determine if it is a clinic or an =
individual. The physician file (PRV) has a combo key on tin/sub tin. The =
file I am linking to has tin and sub tin as well. I want to link to it =
once by tin and sub tin and that part is no problem. However, when I =
attempt to link to it again (giving an alias) with tin only, I get the =
following error message:
Access PRV viaindex PRV_KEY0.=20
^=20
*E* Expected: <file>=20
> TO TIN_NUM OF PRV ALIAS PRV1=20
^^=20
Can someone tell me what the correct syntax is? Also, the other file I =
am linking to is a subfile, not a database table.
Thanks,=20
-Kristina=20
Ext. 2459=20
------_=_NextPart_001_01C4A670.C28C7770
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>Linking tables</TITLE>
<META content=3D"MSHTML 6.00.2800.1458" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D118050622-29092004><FONT color=3D#0000ff=20
size=3D2>Kristina,</FONT></SPAN></DIV>
<DIV><SPAN class=3D118050622-29092004><FONT color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D118050622-29092004><FONT color=3D#0000ff size=3D2>I'd =
specify the=20
linkage fields:</FONT></SPAN></DIV>
<DIV><SPAN class=3D118050622-29092004><FONT color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D118050622-29092004><FONT color=3D#0000ff =
size=3D2>ACCESS PRV=20
&</FONT></SPAN></DIV>
<DIV><SPAN class=3D118050622-29092004><FONT color=3D#0000ff =
size=3D2> LINK=20
field1 OF PRV, &</FONT></SPAN></DIV>
<DIV><SPAN class=3D118050622-29092004><FONT color=3D#0000ff=20
size=3D2> =
field2 OF=20
PRV &</FONT></SPAN></DIV>
<DIV><SPAN class=3D118050622-29092004><FONT color=3D#0000ff =
size=3D2> =20
TO field1, field OF PRV ALIAS PRV1 =
OPTIONAL</FONT></SPAN></DIV>
<DIV><SPAN class=3D118050622-29092004><FONT color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D118050622-29092004><FONT color=3D#0000ff =
size=3D2>CHOOSE VIAINDEX=20
PRVINDEX</FONT></SPAN></DIV>
<DIV><SPAN class=3D118050622-29092004><FONT color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D118050622-29092004><FONT color=3D#0000ff =
size=3D2>David=20
Morrison</FONT></SPAN></DIV>
<DIV><SPAN class=3D118050622-29092004><FONT color=3D#0000ff =
size=3D2>McBride=20
Electric</FONT></SPAN></DIV>
<DIV><SPAN class=3D118050622-29092004><FONT color=3D#0000ff=20
size=3D2> </FONT></SPAN></DIV>
<BLOCKQUOTE>
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B>=20
powerh-l-admin@lists.sowder.com =
[mailto:powerh-l-admin@lists.sowder.com]<B>On=20
Behalf Of </B>Kristina Carlton<BR><B>Sent:</B> Wednesday, September =
29, 2004=20
2:55 PM<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> =
Linking=20
tables<BR><BR></FONT></DIV>
<P><FONT size=3D2>Hi List,</FONT> </P>
<P><FONT size=3D2>I am using OpenVMS v7.3-2 and Quiz V7.10.G4.</FONT> =
</P>
<P><FONT size=3D2>My intention is to link to a table twice but link on =
different=20
fields. The table is self-referencing and contains physician =
information. Each=20
physician has a tin (FEIN) and a sub tin (provider within a facility). =
If the=20
physician works for a clinic he would be listed with the clinic's tin =
plus a=20
sub tin, but the name field would contain his name. The clinic has no =
sub tin.=20
</FONT></P>
<P><FONT size=3D2>In the case of a physician having his own practice =
he would be=20
listed twice with the same tin, but once without a sub tin and once =
with a sub=20
tin. Each record will have the same name. This would look as=20
follows:</FONT></P>
<P><FONT size=3D2>TIN =20
SUB TIN=20
NAME</FONT> <BR><FONT=20
size=3D2>75-261977 =20
=20
Victory Medical =
Services</FONT>=20
<BR><FONT size=3D2>75-261977 =20
001 =
Dr.=20
Franklin</FONT> <BR><FONT =
size=3D2>75-261977 =20
002 =
Dr.=20
Garcia</FONT> <BR><FONT size=3D2>and so on </FONT></P>
<P><FONT size=3D2>75-269999 =20
=20
Dr. Williams</FONT> =
<BR><FONT=20
size=3D2>75-269999 =20
001 =
Dr.=20
Williams</FONT> </P>
<P><FONT size=3D2>I need to link to this file twice in order to get =
the=20
physician's name as well as the clinic name and also to determine if =
it is a=20
clinic or an individual. The physician file (PRV) has a combo key on =
tin/sub=20
tin. The file I am linking to has tin and sub tin as well. I want to =
link to=20
it once by tin and sub tin and that part is no problem. However, when =
I=20
attempt to link to it again (giving an alias) with tin only, I get the =
following error message:</FONT></P>
<P><FONT size=3D2>Access PRV viaindex PRV_KEY0.</FONT> <BR><FONT=20
=
size=3D2> &nbs=
p;  =
; =
=20
^</FONT> <BR><FONT size=3D2>*E* Expected: <file></FONT> =
<BR><FONT=20
size=3D2>> TO TIN_NUM OF =
PRV ALIAS=20
PRV1</FONT> <BR><FONT =
size=3D2> =20
^^</FONT> </P>
<P><FONT size=3D2>Can someone tell me what the correct syntax is? =
Also, the=20
other file I am linking to is a subfile, not a database =
table.</FONT></P>
<P><FONT size=3D2>Thanks,</FONT> <BR><FONT size=3D2>-Kristina</FONT> =
<BR><FONT=20
size=3D2>Ext. 2459</FONT> </P><BR></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C4A670.C28C7770--