Users pick a Vendor from a
Popup Key LOV (Displays description, returns key value) type field.
LOV_Vendors
select txtName, ID
from FAC_Vendors
order by 1
This works fine. However I want to only show in the POPUP, ACTIVE vendors as determined by LOV_Vendors_Active:
LOV_VENDORS_ACTIVE
select txtName, ID
from FAC_Vendors
where dteEffectiveEndDate > sysdate or dteeffectiveenddate is null
order by 1
I want to choose only active vendors for current invoices, but on old invoices where they already chose a vendor that is now inactive, I want to show the name of the inactive vendor on the form. Instead, if i use LOV_Vendors_Active, it shows the ID of the vendor rather than the name (of course it can't find it).
How can I use both these LOVs - one in the form and a different one in the Popup LOV?
thanks!