Linking tables

Wed, 29 Sep 2004 16:54:36 -0500

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_01C4A66E.E9BAE6D9
Content-Type: text/plain;
	charset="iso-8859-1"

Hi List,

I am using OpenVMS v7.3-2 and Quiz V7.10.G4.

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. 

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
75-261977			Victory Medical Services
75-261977	001		Dr. Franklin
75-261977	002		Dr. Garcia
and so on 

75-269999			Dr. Williams
75-269999	001		Dr. Williams

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.
                                              ^
*E* Expected:  <file>
>        TO TIN_NUM OF PRV ALIAS PRV1
         ^^

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,
-Kristina
Ext. 2459

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>Linking tables</TITLE>
</HEAD>
<BODY>

<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>

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.

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&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SUB TIN =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NAME
 75-261977&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Victory Medical =
Services
 75-261977&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
001&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
Dr. Franklin
 75-261977&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
002&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
Dr. Garcia
 and so on

75-269999&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dr. Williams
 75-269999&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
001&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
Dr. Williams

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:

<P><FONT SIZE=3D2>Access PRV viaindex PRV_KEY0.</FONT>
<BR><FONT =
SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
^</FONT>
<BR><FONT SIZE=3D2>*E* Expected:&nbsp; &lt;file&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TO =
TIN_NUM OF PRV ALIAS PRV1</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
^^</FONT>
</P>

Can someone tell me what the correct syntax is? Also, =
the other file I am linking to is a subfile, not a database =
table.

<P><FONT SIZE=3D2>Thanks,</FONT>
<BR><FONT SIZE=3D2>-Kristina</FONT>
<BR><FONT SIZE=3D2>Ext. 2459</FONT>
</P>
<BR>

</BODY>
</HTML>
------_=_NextPart_001_01C4A66E.E9BAE6D9--