Linked Comboboxes in a Editor Grid

Published by: jane 2009-01-07

Hi all.

Programming in JPL (Application Development)::
You can also create library modules directly in the editor workspace. For example, if a grid widgets Entry Function property contains the string
http://www.prolifics.com/docs/panther4.6/html/dev_html/progjpl.htmHOME

I ran into a big problem regarding the logic behind the linked comboboxes behaviour.

Basing one combo box on another - Access - Microsoft Office Online::
and drag below the two combo boxes inside the design grid of the form to create the text box. box is one that is not linked to a field in a table or
http://office.microsoft.com/en-us/access/HA011730581033.aspxHOME

Rent A Coder - Membership::
be provided in a grid. Clicking on the grid should display full note with Either an Add or Edit selection should cause the comboboxes to be populated from
http://www.rentacoder.com/RentACoder/misc/BidRequests/Showp?lngBidRequestId=1077601HOME

Here's a little example (American way):

editorGrid with 2 columns: "state" and "city".
State is a combobox loading its data from a db. It's a collection of ID and Value.
City is a combobox related to State. Its data (loaded from a db) is in form of: ID, IDState and Value. But City table is very huge (say 10000+ records).
What I want is a common task: linked the two comboboxes!

Reading many posts I've made a solution:
Load both datastores before render the grid and then use the ds.filter() on State's select handler.

vbAccelerator - Using Editable in SGrid 2::
and combo boxes for editing, and finally describes implementing check Fired when the grid detects that it should leave edit mode for a cell but before
http://www.vbaccelerator.com/home/VB/Code/Controls/S_Grid_Editable_Mode/article.aspHOME

ZK Live Demo::
Inputs. Layout and Windows. Grids and Trees. Toolbar and WYSIWYG Editor. Comboboxes. Bandboxes. Radio and Checkboxes. Buttons. Creating Window: Hello World
http://www.zkoss.org/zkdemo/userguideHOME

That works, of course.
But it takes to long to retrieve all the data from the City db (10.000+).

~o)
So I thinked another solution.
The server returns the value (not the ID) of the City field in order to populate the grid.
So user views the exact cities value in the grid.
When he/she edits the State combobox, I've attached an event that does a "ds_city.load(params:{IDState=xxx})", so when he/she clicks on the City value I can render a combobox based on the ds_city.
It works correctly.
The issue is that this solution may call the "ds_city.load()" several times if the user edits many records.

So I ask you: which is the best one?
Have you got another solution?
:-/

Thanks

PS: I hope I've explained it clearly. If not, tell me.

Where's The Advantage In Windows Genuine Advantage?
Stocks Bounce After S&P Joins Bear Market

More Infomation In The polala.com

#If you have any other info about this subject , Please add it free.#