Re: Oracle developer 2000 - forms

Create a query for a record group like:
select doctor_id, doctor_name
from doctors
order by 2

Then, in the record group, make the column width for the id 0, but map it to the doctor_id column. Make doctor_id non-display. That's about it.

"gRETH" <BG908_at_GRE.AC.UK> wrote in message news:9IHS5.16969$_h.81988_at_NewsReader...
> I am new to developer 2000, and have a few questions.
>
> When creating a combo box - i need to display a list of values obtained
 from
> another table - then display theese values.
>
> for example i want to display a list of doctors in a combo box from the
> doctors table, but i when the doctor is selected i want the doctor id to
 be
> stored without the user seeing it. - like in MS access
>
> Also i need to know the code for commiting a record to the db.
>
> Many thanks
> Gareth
> Gareth.burgess_at_btinternet.com
>
>
>
>
Received on Sun Dec 03 2000 - 05:05:58 CET