Show data in field

(0) Share

Report

Posted on by fathin

Hi All,

I got customize field in SalesEditLineForm which is TransportCompany, VehicleNo, DriverName and I/C Number. This field is from SalesParmUpdate where the EDT is set to LorryRef. I got LorryRef table which is store all the lorry information including RefNo. Another customize field on SalesTable where user select RefNo for the transportation. The question is how do I show the transportation information to the SalesEditLineForm based on selected information from the SalesTable.

select SalesId from SalesParmTable;

if (SalesParmTable.SalesId)
{

select RefNo from salesTable
where SalesParmUpdate.LorryRef == salesTable.RefNo;

if (SalesParmUpdate.LorryRef)
{
SalesParmUpdate.TransportCompany = lorryRef.TransportCompany;
SalesParmUpdate.VehicleNo = lorryRef.LorryNo;
SalesParmUpdate.DriverName = lorryRef.DriverName;
SalesParmUpdate.IcNo = lorryRef.ICNo;
}

}

but it dind't work. Thank you in advance.

*This post is locked for comments

All responses (1)

Answers (0)

fathin 55 on at

Like (0)

Report

RE: Show data in field

I already solved this problem, put the code in run method which is it generate the salesId over there. Problem solved!