I have a main parameter screen with several parameters. The parameters are not populated on this screen, but by buttons that open a second window that contains a double list box. I used the GUI to develop these screens and embedded Javascript to pass selected values from the second window to the main window. Everything works and everything is kosher GUI wise.

I would like to now "chain" some of these parameters. Since the values are selected in a second window I'm having difficulty setting up the chaining.

Let's use a State-City example. These two parameters are on the main parameter screen. First I select some states. Then I'd like to select cities within the states I previously selected. These parameters are populated by the second windows.

In the second window, the double list box is populated by a dynamic external procedure. From the GUI interface I see no way to pass parameters to this dynamic external procedure. Using Javascript I have the list of previously selected states - I need to pass these to the dynamic external procedure that retrieves the cities.

The city double list box is populated via this call:

<data_info checkForDuplicateValues="0" sourcetype="typeFex" datatype="1" modifiedrequest="0" 
datasource="app/extract_city_filter.fex" displayfield="CITY" datafield="CITY" ibiapp_app="" 
IBIMR_domain="mrdomain/mrdomain.htm" IBIMR_folder="#citystate001">

I need to figure out how to pass the selected state values to extract_city_filter.fex OR how to apply them as a filter after all the data is returned but before it's displayed! Ajax?

I wouldn't have this problem if I wasn't constricted by the GUI, though I have managed to manipulate it quite a bit.

Any ideas welcome!

This message has been edited. Last edited by: Francis Mariani,

I think I've solved this. The buttons that open the second window execute a fex that has an HTMLFORM. I added code in this fex to create a FOCUS DB in FOCCACHE - this DB has the filters applied here. Then the HTML page uses this FOC DB instead of the original DB.

Now I have to make sure that a DB in FOCCACHE is unique per user.

Which it is, so good news!

The only problem I now have is that when I open the HTML page in Composer I get a pop-up error (actually 20 or so pop-up errors) stating the file cannot be found, I simply have to wait for the 20 pop-ups, then click OK one each of them. (!)

We just attended a class on HTML Composer. One neat trick he said to avoid popup is to go in tools, settings and uncheck Report and Graph Preview. I have been using HTML composer for 4 to 6 months now. I had also found this very annoying when you open the html page it tries to run the report. You can also use Simulated data.. That might help too.

DW_Dev, thanks - that fixed the issue with pop-up messages.