I have a similar application and I found it easier to create a user (or
application) scope variable that contains the team names. The search action
brings back the participants in a game and I use the following to display
their team name:
<@ASSIGN NAME="la_temphometeam" VALUE=<@FILTER ARRAY="ua_teams"
EXPR="#1 =
<@COLUMN M_Team1>"> SCOPE="LOCAL">
<@VAR NAME=local$la_temphometeam[1,2]>
<@ASSIGN NAME="la_tempvisitingteam" VALUE=<@FILTER ARRAY="ua_teams"
EXPR="#1 = <@COLUMN M_Team2>"> SCOPE="LOCAL">
<@VAR NAME=local$la_tempvisitingteam[1,2]>
Hope this helps,
Steve Smith
Oakbridge Information Solutions
Office: (519) 624-4388
GTA: (416) 606-3885
Fax: (519) 624-3353
Cell: (416) 606-3885
Email: [EMAIL PROTECTED]
Web: http://www.oakbridge.ca
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Fogelson, Steve
> Sent: December 9, 2002 6:42 PM
> To: Multiple recipients of list witango-talk
> Subject: Witango-Talk: Database View
>
>
> I use R:Tango 2000 on a Windows 2K server.
>
> I have 2 tables as follows:
>
> Table - Teams
> Fields - T_ID, T_Name
>
> Table - Matches
> Fields - M_ID, M_Team1, M_Team2
>
> M_Team1 & M_Team2 relate to T_ID in Teams. I want to do a search action of
> records in table Matches "joining" T_Name.
>
> In the search action, I list the following under "join"
>
> Match.Team1=Teams.T_ID
> Match.Team2=Teams.T_ID
>
> What do I list under "select" to get both names?
>
> Hope this makes sense.
>
> Thanks
>
> Steve Fogelson
> Internet Commerce Solutions
> ________________________________________________________________________
> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
> with unsubscribe witango-talk in the message body
>
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
