APEX

All,

I'm anticipating a requested change to one of my tabular forms that may head me down the path of trying to filter a popup LOV's SQL by a value. Effectively this is a cascading LOV which Apex does support (I am on version 4.x) but only for page items. For tabular form items, I can't see how to do this.

The background is that I have a tabular form with part numbers and a vendor ID (currently as a select-list, and on change of the part number I currently successfully repopulate the select-list of vendor IDs to only vendors for that part). I anticipate the user will want to change this to be a popup LOV so they can either still choose from a list of values or manually type into the field if they already know the value.

While everything is working fine as a select-list, I am stumped on how one would do this with a popup LOV.

Challenges that I foresee:

1. It seems that popup LOVs in general, if dependent on some value as a cascading LOV, filter their values only when the popup LOV is executed at runtime. Therefore, unlike the driving field (part number in my case) triggering, via onchange, code that repaints the LOV values in a select-list, a popup LOV instead would be unaffected by the onchange on part number and instead when the LOV is invoked, this is when the part number field should be evaluated to filter the values in the LOV SQL.

2. Focus is not required in a popup LOV field...by that I mean that you can click on a popup LOV button to invoke it without your cursor being in the corresponding field. You also don't even need to be on the same row. Therefore, I am not sure how I would even know what row I'm on in the tabular form to reliably somehow pass the part number from the correct row to the popup's SQL somehow.

3. The popup LOV button itself has no internal HTML ID associated with it, so I can't even really trigger something from that being pressed to tell what row I'm on in order to then find the part number on the row I'm on.

Anyway, has anyone managed to successfully define a cascading LOV in v4 on a tabular form that is a popup LOV? Ideas or examples?