I have the following code where I am joining address book master (F0101) to get the description for one field.

I have another field I need to get the description for..how can I do another lookup to F0101 to get a different row's ABALPH value? I need to do a lookup for TLAN8 = ABAN8.

JOIN TLURAB IN F554852 TO ABAN8 IN F0101 AS J1


TABLE FILE F554852
PRINT
TLDOCO
TLURRF
TLLITM
TLSHFT
TL$SGC
ABALPH AS 'Inspector ID'
TLDGL
TL$MCH
TLLOTS
TLRCD
TLTRQT
TLDOC
TLCRDJ
TLTDAY
BY TL$MCH NOPRINT
BY TLLOTS NOPRINT
BY TLDOCO NOPRINT
BY TLSHFT NOPRINT
WHERE....

This message has been edited. Last edited by: <Kathryn Henning>,

Use TAGs.

JOIN TLURAB IN F554852 TO ABAN8 IN F0101 TAG IID AS J1
JOIN TLAN8  IN F554852 TO ABAN8 IN F0101 TAG TLN AS J1

TABLE FILE F554852
PRINT 
IID.ABALPH AS 'Inspector ID'
TLN.ABALPH AS 'TLAN8'

Except that you need to name the joins differently. So:

JOIN TLURAB IN F554852 TO ABAN8 IN F0101 TAG IID AS J1
JOIN TLAN8  IN F554852 TO ABAN8 IN F0101 TAG TLN AS J2

Ooh,

Schoolboy error.

Eek, well spotted.

The perils of typing and not testing.

or use the DB_LOOKUP function and go home early.

Have you used DB_LOOKUP much ?

Hows the performance ?

I could never find a use for DB_LOOKUP and if you are processing thousands of record, seems it would be extremely slow. Also, just as a question, why can't FOCUS data sources be used? From the documentation, "The lookup file can be any non-FOCUS data source..."

i use db_lookup all the time, everytime i need a field description for a field code.
simplifies life. i never measured performance differences, never was an issue.

Waz, thanks, it works!

Josh,

Please edit your first post in this thread and add [CLOSED] or [SOLVED] to the title