Subject Conditional data in combo picklist
From Milind Nighojkar <milinigh@yahoo.com>
Date Tue, 04 Jan 2022 00:57:05 -0500
Newsgroups dbase.getting-started

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

Any suggeestions

Milind Nighojkar