I have a html form created with html layout painter that loads three combo boxes with a procedure.

the following code is in the procedure:

TABLE FILE V_1040_AGG_COL
PRINT
FED_NAME
FORM_NAME
COL_DESC
BY FED_NAME
BY FORM_NAME
BY COL_DESC
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT XML



I allow webfocus to create the controls FED_NAME FORM_NAME, COL_DESC

the same procedure is specified for loading all three controls.

I click on three objects in order FED_NAME FORM_NAME, COL_DESC and
click the add to chain button.

When I run the html the data from the second column is added in all 3 controls.

The generated HTML is below. This exact technique works in 7.6

Does this technique work in 7.13 ?

<SELECT id=combobox2 style="Z-INDEX: 40; LEFT: 300px; WIDTH: 150px; POSITION: absolute; TOP: 130px; HEIGHT: 22px" tabIndex=40 size=1 name=FED_NAME sourcetype="typeFex" datafieldtype="PACKED" datatype="1" requiredfield="58827720" datasource="app/1040aggr.fex" operation="NONE" addalloption="0" datafield="ADDL_CHILD_TAX_CREDIT_AMT" displayfield="ADDL_CHILD_TAX_CREDIT_AMT" accept="0" IBIMR_folder="#individuald5" ibiapp_app chainnumber="0" inchainindex="1" cacheruntimedata="0" newchainnumber="0">
</SELECT> 
<SELECT id=combobox3 style="Z-INDEX: 41; LEFT: 300px; WIDTH: 150px; POSITION: absolute; TOP: 160px; HEIGHT: 22px" tabIndex=41 size=1 name=FORM_NAME sourcetype="typeFex" datafieldtype="PACKED" datatype="1" requiredfield="58827720" datasource="app/1040aggr.fex" operation="NONE" addalloption="0" datafield="ADDL_CHILD_TAX_CREDIT_AMT" displayfield="ADDL_CHILD_TAX_CREDIT_AMT" accept="0" IBIMR_folder="#individuald5" ibiapp_app chainnumber="0" inchainindex="2" cacheruntimedata="0" newchainnumber="0">
</SELECT> 
<SELECT id=combobox5 style="Z-INDEX: 42; LEFT: 300px; WIDTH: 150px; POSITION: absolute; TOP: 190px; HEIGHT: 22px" tabIndex=42 size=1 name=COL_DESC sourcetype="typeFex" datafieldtype="PACKED" datatype="1" requiredfield="58827720" datasource="app/1040aggr.fex" operation="NONE" addalloption="0" datafield="ADDL_CHILD_TAX_CREDIT_AMT" displayfield="ADDL_CHILD_TAX_CREDIT_AMT" accept="0" IBIMR_folder="#individuald5" ibiapp_app chainnumber="0" inchainindex="3" cacheruntimedata="0" newchainnumber="0">
</SELECT> 

Secret,

The important piece of code is this -

datafield="ADDL_CHILD_TAX_CREDIT_AMT" displayfield="ADDL_CHILD_TAX_CREDIT_AMT"

You will notice that it is the same for all three combos thus giving you the same output in all three.

Another important piece are the chainnumber and inchainindex attriubutes and these should be accompanied by a section of javascript that is usually added after the body end tag. The values given in your sample look perfectly OK though.

So if the data in your combos are meant to be different then I would suggets you take a look at the datafield and displayfield attributes.

T

p.s. add line feeds within your code above so that we don't have to keep scrolling!

Tony:

Thank you for responding. The column ADDL_CHILD_TAX_CREDIT_AMT is no where in my request so I don't know where it came from.

I tried changing it to the columns in the request , that didn't work.

What is suppposed to be in the data field and display options ? The code generator did not populate them correctly.

Secret, When I populate a control from a procedure I always use seperate procedures for each control. I do not know if you can use 1 procedure for all three.

PROCEDURE 1:

TABLE FILE V_1040_AGG_COL
SUM
FED_NAME
BY FED_NAME
ON TABLE PCHOLD FORMAT XML
END

PROCEDURE 2:
TABLE FILE V_1040_AGG_COL
SUM
FORM_NAME
BY FORM_NAME
WHERE FED_NAME EQ '&FED_NAME';
ON TABLE PCHOLD FORMAT XML
END

PROCEDURE 3:
TABLE FILE V_1040_AGG_COL
PRINT
COL_DESC
BY COL_DESC
WHERE FED_NAME EQ '&FED_NAME';
WHERE FORM_NAME EQ 'FORM_NAME';
ON TABLE PCHOLD FORMAT XML
END

Hope this helps