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.

Cheers

Dan

dandaman2234 (AT) yahoo (DOT) 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.

dandaman2234 (AT) yahoo (DOT) 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.

dandaman2234 (AT) yahoo (DOT) 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.

dandaman2234 (AT) yahoo (DOT) 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.

On Mar 20, 11:53*pm, yf... (AT) vtn1 (DOT) victoria.tc.ca (Malcolm Dew-Jones)
wrote:
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

On Mar 20, 11:53*pm, yf... (AT) vtn1 (DOT) victoria.tc.ca (Malcolm Dew-Jones)
wrote:
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

On Mar 20, 11:53*pm, yf... (AT) vtn1 (DOT) victoria.tc.ca (Malcolm Dew-Jones)
wrote:
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

On Mar 20, 11:53*pm, yf... (AT) vtn1 (DOT) victoria.tc.ca (Malcolm Dew-Jones)
wrote:
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