Linking tables

[brian_matthewsbrian matthews]

sorry Kristina, I missed the data example.


>From: Kristina Carlton <Kristina.Carlton@JICompanies.com>
>To: powerh-l@lists.sowder.com
>Subject: Linking tables
>Date: Wed, 29 Sep 2004 16:54:36 -0500
>
>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
>
>

_________________________________________________________________
Express yourself with cool new emoticons http://www.msn.co.uk/specials/myemo