||Conditional data in combo picklist
Milind Nighojkar <firstname.lastname@example.org>
||Tue, 04 Jan 2022 00:57:05 -0500
Scenerio : In a grid form one of the column value is from combo. Picklist of this combo is from another database say B. Need picklist with condition say Status = 'WIP' . (Status is a field in the database B)
In form tried to give syntax
sql = 'select * from B.DBF where status = :m_status'
m_status is avariable which is passed as a parameter.
currently m_status is initialised in form_onOpen