By Fredrick - Wed Apr 24, 2019 7:02 am
- Wed Apr 24, 2019 7:02 am
#824097
Hell PM Experts,
I have a GRID embedded in dynaform, I have set dependent field to pull price from of item selected in dropdown (independent field) but the price does not show immediately on change of dropdown variable/item, see below; I want to get Unit Price of item selected in PartNumber...both are in same PM table
<PartNumber type="dropdown" required="1" readonly="0" optgroup="0" dependentfields="" defaultvalue="--" mode="edit" sqlconnection="workflow" resizable="0"><![CDATA[SELECT MERAKIPN, MERAKIPN FROM PMT_T4GMERAKIEQUIPMENT WHERE STATUS=1 ORDER BY MERAKIPN ASC
]]><en>Meraki Part Number and Description
<option name="">-Select Meraki Part Number Description</option></en></PartNumber>
<UnitPriceList type="text" maxlength="64" validate="Real" mask="###,###,###,###.##" required="0" readonly="0" dependentfields="PartNumber,Description" size="10" mode="edit" sqlconnection="workflow" resizable="0" optgroup="0"><![CDATA[ SELECT UNITPRICE, UNITPRICE FROM PMT_T4GMERAKIEQUIPMENT WHERE MERAKIPN = "@#PartNumber"]]>
<en>Unit Price</en>
</UnitPriceList>
I have a GRID embedded in dynaform, I have set dependent field to pull price from of item selected in dropdown (independent field) but the price does not show immediately on change of dropdown variable/item, see below; I want to get Unit Price of item selected in PartNumber...both are in same PM table
<PartNumber type="dropdown" required="1" readonly="0" optgroup="0" dependentfields="" defaultvalue="--" mode="edit" sqlconnection="workflow" resizable="0"><![CDATA[SELECT MERAKIPN, MERAKIPN FROM PMT_T4GMERAKIEQUIPMENT WHERE STATUS=1 ORDER BY MERAKIPN ASC
]]><en>Meraki Part Number and Description
<option name="">-Select Meraki Part Number Description</option></en></PartNumber>
<UnitPriceList type="text" maxlength="64" validate="Real" mask="###,###,###,###.##" required="0" readonly="0" dependentfields="PartNumber,Description" size="10" mode="edit" sqlconnection="workflow" resizable="0" optgroup="0"><![CDATA[ SELECT UNITPRICE, UNITPRICE FROM PMT_T4GMERAKIEQUIPMENT WHERE MERAKIPN = "@#PartNumber"]]>
<en>Unit Price</en>
</UnitPriceList>