I'm relatively new to Powerbuilder and can't figure out how to
modify/link the SELECT/WHERE clause of a drop down datawindow edit
mask to a "key" column on a data entry datawindow. That is, I have
a data entry datawindow containing a "key" data column and a "code"
data column. The code data column is a DDDW. The DDDW is based on
a simple datawindow of
SELECT key, code, desc FROM codetable;
What I would like is to add a WHERE clause which specifies the "key"
to retrieve the code and desc for. Ideally, the key would be linked
to the "key" column on the data entry datawindow. Else I need to
update the WHERE clause each time the user changes it (is the
itemchanged event the appropriate place)?
Am I even using the correct approach?
Thanks for you help in advance,