asked on
Link single LOV values to different text items
Hi,
I have attached the layout of the form and Lov.
The LOV is retrieving the column values separated by a comma.
Now, when I select a record in LOV then it should place the column values in the respective text fields.
For example,
AMERIPRISE TRUST COMPANY -> Payee Org1
70100 ESIUGOUGBI GGSESGGEO GTU->1st Address Line
null-> 2nd Address Line
MINNEAPOLIS->City
MN->State
55474->Zipcode
US->Country
How can I do this?
Also, how do I assign the combination of keys shift+5 to display this LOV?
LOV.bmp
Form.bmp
I have attached the layout of the form and Lov.
The LOV is retrieving the column values separated by a comma.
Now, when I select a record in LOV then it should place the column values in the respective text fields.
For example,
AMERIPRISE TRUST COMPANY -> Payee Org1
70100 ESIUGOUGBI GGSESGGEO GTU->1st Address Line
null-> 2nd Address Line
MINNEAPOLIS->City
MN->State
55474->Zipcode
US->Country
How can I do this?
Also, how do I assign the combination of keys shift+5 to display this LOV?
LOV.bmp
Form.bmp
Oracle DatabaseMySQL ServerMicrosoft SQL Server
Last Comment
flow01
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
If your record-group and lov don't change you don't need the build-in for the recordgroup,
for creating and mapping a LOV the don't exist build-in to do it dynamically so do it fixed:
select the LOV entry in your forms-builder , hit the + to add a new LOV and use the wizard:
enter the query and after selecting the columns on the next page assign the columns to the forms-items (that you have created first).
Assigning return-items afterwards can be done at the property sheet of the LOV (column mapping properties).
Once done you can (if necessary to change the underlying sql-query of a record-group) change it at runtime by the populate_group function . (example in the oracle forms builder help in the create_group_from_query).
for creating and mapping a LOV the don't exist build-in to do it dynamically so do it fixed:
select the LOV entry in your forms-builder , hit the + to add a new LOV and use the wizard:
enter the query and after selecting the columns on the next page assign the columns to the forms-items (that you have created first).
Assigning return-items afterwards can be done at the property sheet of the LOV (column mapping properties).
Once done you can (if necessary to change the underlying sql-query of a record-group) change it at runtime by the populate_group function . (example in the oracle forms builder help in the create_group_from_query).
I tried the 2nd solution and it worked fine. Thank u for that.
Now I have same thing but I have to create the record group using the create_group_with_query or populate_group_with_query.
Can you give me an example code of how I can create the record group using this function and the same query you mentioned and insert rows into the record group.
Then assign this record group to a new LOV and then map the corresponding column values in the LOV to their respective text items. LOV should consist of the cols (org, al1, al2, city, state, zipcode, country).
Can you please help me with this?