using select in filter (AREV Specific)
At 21 MAR 1998 09:23:49AM Guido Massaro wrote:
I hope someone could tell me how to make a select in a filter.
I like to select a table and use 1 fieldname, then i want to go an other table and select an other fieldname. That selection criteria is what i want to use.
Help, i'm just beginning with this .
At 21 MAR 1998 03:29PM Aaron Kaplan wrote:
Not sure what you mean. You can
SELECT SOMEFILE WITH FIELD1 EQ 'ABC'and get an active select list.
You could then take this active list and apply it to another file by just issuing
SELECT ANOTHERFILE WITH FIELD2 < 500right after the first one.
This only works if the same keys are in both files since it uses the saved list from the first file to work on the second.
At 26 MAR 1998 03:03AM Ivanka Markun wrote:
Do you, per chance, want information on a report which
resides in two different tables? Your "select" can
specify only one table, as Mr. Kaplan stated. But you
can create a symbolic field using the XLATE function to
retrieve the info from the second table. This can be done
if Table1 has a field which corresponds to the Key to
Table2.
For example: To retrieve LAST.NAME from the CLIENT table
without getting out of the POLICY table:INSURANCE.POLICY={POLICY.NO} *the key to the POLICY table
CLIENT.NO={CLIENT.NO} * POLICY field with client no.
NAME=XLATE('POLICY',CLIENT.NO,client.field,'X')
@ANS=NAME