That one is easy to remedy ...
1) Add the same CITY column to your Form or Report
2) Create a new DW object that retrieves CITY information based on
Country='Canada'
3) Add an Expression to the original City column for its "Visible" property.
if ( contact_country = 'CA', 0, 1)
4) Add an Expression to the second instance of the City column for its
"Visible" property.
if ( contact_country = 'CA', 1, 0)
5) Move the 2nd City column over top of the 1st instance on your Report or
Form.
Now when you run .. if the user sees Canada on the contact list - only
Canadian cities appear in the DD.
FYI: There are more innovative ways to control this as well.
Note: If you have PowerBuilder around - creating a global function to source
the city information for a computed column works "kool" too! :-)
Post by Terry Dykstra [TeamSybase]Most definitely not! Chris, you missed the point of the question. In
InfoMaker you cannot make one column dependent on another column. So if
the user selects AB from the province/state dropdown list, there is no way
that you can then limit the dropdown for the city column to show only
Calgary, Edmonton (cities in AB).
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
http://my.isug.com/cgi-bin/1/c/submit_enhancement
Hi Lisa;
Most definitely .. that is referred to as a "Dropdown DataWindow" - in
IM we could also refer to that as a Dropdown Report. The implementation
is via the Edit Style on the column where the data look-up is required. I
have attached a few examples (screen shots) from IM 12 that I am beta
testing. Even though this is the latest version of IM - your version
should be the same as far as the IDE and dropdown features are concerned.
1) Create a "Tabular" report with the column(s) you require for the list
when the data drop is activated.
2) Create a new Report or Form that requires the data look-up
3) Select the Edit TAB and the Edit Style of "DropDownDW"
4) In the DDDW style - select the report you created from step #1
5) Map the columns you require for the display (and updating if in a
Form).
6) Run the Report or Form and test out the dynamic data look-up!
HTH
Note: See attached ...
--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com
Post by unknownUsing Infomaker 10.5 - Is there a way to create a drop down
menu, that will be dynamic.
Data from one table is pulled to display a category, and
based on that selection - can we dynamically display data in
another drop down? (that's selected from a reference table)?
Thank you