Re: list of values

If your purpose is to allow the users to select one or more label sets to print, you might want to consider a different implementation, such as displaying the contents of each of the label name fields as an item, creating a 2 button radio group for each item (YES NO) and a single push button to print the item(s) checked YES. Result would look something like the "Rate It" area on Deja's page. Just a thought...

In article <37FBB5D3.F127E820_at_creditwatch-inc.com>,   Brian Howard <bh_at_creditwatch-inc.com> wrote:
> I need some info and expertise. I have a table that has several fields
> in it which name different labels for a client. I want a list of
values
> which will pull up all those fields into it even though they all
belong
> to the same record. I need to be able to hit the list of values key
and
> have all the values in all the wanted fields of the same record
> displayed. If they were in different records this would just be
> standard. The record group would look something like:
>
> select label from clients
> where clt_id = :accounts.clt_clt_id
>
> but what I really want to do is
>
> select brk_comm_lbl,spc_comm1_lbl, spc_comm2_lbl from clients
> where clt_id = :accounts.clt_clt_id
>
> with each of these values being a choice in the list of values. How
can
> I do this?
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 12 1999 - 11:55:06 CEST