Re: record group and LOV based on a single record

Try something like this:

SELECT field_a
FROM table_a
WHERE PK = :GLOBAL.company_name
UNION
SELECT field_b
FROM table_a
WHERE PK = :GLOBAL.company_name
UNION
SELECT field_c
FROM table_a
WHERE PK = :GLOBAL.company_name;

You will have to standardize the datatype and field length of the three fields (if they are not identical already), and load your company name into a global before invoking the LOV (at least I've never been able to get a Record List with a variable in the WHERE clause to work with anything other than a :GLOBAL), but it should give you the desired result.

In article <Mq%O3.1248$pJ3.87002_at_news.flash.net>,   "Brian Howard" <bkhoward_at_flash.net> wrote:
> I am having trouble with one of my requirements. I have a table with
several
> fields in it, let's say:
>
> Table A
> PK
> Field A
> Field B
> Field C
>
> I need to be able to pull a list of values based upon a single record
in
> this table. Let's say that I need the record for PK ('XYZ Company'),
I then
> need to pull a list of values which include Field A, Field B, & Field
C. How
> can this be done. Please explain.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 20 1999 - 12:04:25 CEST