I want when Page opens it should not show data in Sub Form . On click of button i want to refresh sub form with Data.
You need to use then a temporary table as the source of the subform and populate those values by action.
I agree with your first point . Can u provide some example how to do this point
populate those values by action. Will it has to be done in Main Form . I have Main Form & Sub Form . Currently what is happening Data automatically gets displayed in Sub Form .
I want when user press button then Data gets displayed in Sub Form.
Check Page 160 or 161, the subform is temporary and in this case it will populate the values using GetVATSpecification or SetVATSpecification, it does not do by the action but you need to apply that kind of logic in your scenario.
Populate the Temporary table on the action.
I have Location table as Main and Custom Table Issue Lines on Sub Form. I have set temporary table as the source of the subform
CDNLine is of Record Data Type with SubType Issue Lines.
I have written below code on Push of Button but not working
IF TEntry.FINDFIRST THEN REPEAT
Amount := 0;
IF TPLine.FINDFIRST THEN REPEAT
Amount += TPLine."Amount";
UNTIL TPLine.NEXT = 0;
IF Amount > 0 THEN BEGIN
IF CDNLine.FINDFIRST THEN BEGIN
CDNLine."Sale Amount" := Amount;
END ELSE BEGIN
EntryNo := EntryNo + 1;
CDNLine.VALIDATE("Sale Amount", Amount);
TempDate := TempDate + 1;
UNTIL TempDate > WORKDATE;
Business Applications communities