Re: LOV button on Oracle form

On Mar 20, 11:53 pm, yf..._at_vtn1.victoria.tc.ca (Malcolm Dew-Jones) wrote:
> dandaman2..._at_yahoo.co.uk wrote:
>
> : Hi
>
> : I'm currently trying to build a database in oracle for a made up
> : scenario for a University assignment. On one of the forms there is a
> : field called 'Region of UK' which the user would choose from a list of
> : values. This list corresponds with another table that I have created.
> : I have managed to make a button that once pressed a list of all the
> : regions available appears in a little box. The problem I'm having is
> : making the selected value e.g. the user selects 'EAST MID' appear in
> : the field region of uk.
>
> : Can anyone help or give me some advise on where I might be going
> : wrong.
>
> You make a record group that has the query.
>
> Then you make an LOV that uses the record group.
> Select the LOV and right click to get the Properties dialog.
>
> The LOV properties dialog has a property called "Column Mapping
> Properties", so click in the value column of that to get the LOV COlumn
> Mapping dialog.  In that dialog you put the column name from the record
> group, and use the [Browse...] button to select which item in the form
> gets populated from that column of the record group.
>
> Press the Help button for more details.

Cheers for the reply. Finally got the button to work. In the column mapping window I configured the return item to be the region of UK field.
Work fine now.

Cheers again.

Dan Received on Wed Mar 26 2008 - 06:20:33 CDT