Re: LOV button on Oracle form

dandaman2234_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. Received on Thu Mar 20 2008 - 18:53:13 CDT