Hello,
I created a new button "closing order" in the module 'production control' -> production order-> master production order in the form "bfpprodmastertable" then I created a new table named "DemordredefermetureLineTable" which includes a created field named "DemSize".
My goal is when I select a main production order and a sub-row of the "bfpTmpProdMasterTable" table there are lines in the production order which include the "inventsizeid" field from the "inventdim" table which is linked to the "prodtable" table by "inventdimid" I want to display the list of values of the field "inventsizeid" of table "inventdim" of principal the row that I have selected in production order in my new form . For example, when I click on the button" close order "the list of values of" inventsizeid "linked to the row that I have selected in the table will be displayed in my "" field in my new "demordredefermetureLineTable" table. I tried this code but it shows me only
one line which fileld has "inventsizeid" despite there being for example three lines in the "inventdim" table of the form "bfpprodmastertable".
I need help plz:
[DataSource]
class DEMOrdredefermetureLineTable
{
///
///
///
///
public int active()
{
int ret;
ret = super();
FormRun formrun=element.args().caller();
bfpTmpProdMasterTable bfpTmpProdMasterTable =formrun.dataSource("bfpProdMasterTableTmp").cursor() as bfpTmpProdMasterTable;
InventDim InventDim1;
DEMOrdredefermetureLineTable dEMOrdredefermetureLineTable1;
ProdTable ProdTable;
ttsbegin;
while select ProdTable where ProdTable.bfpprodmasterId==bfpTmpProdMasterTable.prodmasterId
{
select InventDim1 where InventDim1.inventdimId == ProdTable.InventDimId;
dEMOrdredefermetureLineTable1.DEMSize=InventDim1.InventSizeId ;
dEMOrdredefermetureLineTable1.doUpdate()
}
ttscommit;
return ret;
}
}
