Hi,
Back on APEX after awhile, I am using 5.0.1
It is fairly common in Oracle Forms to enter a product id or code in a column, have the database perform a query on that value
on a lookup table table and then display the looked up value (usually a product name or description) in another column in the form.
Is it possible to do this in APEX tabular form? ,i.e. just enter an item code and then have the item description displayed in another column
after an SQL Query.
The item description column in the tabular form is also a column in the table source for the form to make things easier.
The application is used by people who know these codes by heart and who don't want to access an LOV etc. as it slows their work.
They just want to input an item code,get the item description displayed in another column just for confirmation,or an error message if the item
code does not exist.
Grateful for any help,as I have searched but found no similar request elsewhere.
Regards
LD