In page bring the data from multiple(two) table.

hi experts ,
Actually I did not work on page so I made a page in it relate to sales invoice header table ,data of this table is correct
on the page but now I want to bring the sell to customer name from the header table on the page so how it will come on the page and
which trigger have to use for code .
please share your feedback.
thanks in advance.

welcome to DUG

sell to customer name field is already available in Sales Invoice Header table.

You just need to add it in Page.

thank you Mohana sir ,

thanks for the reply,
Actually first I made a page which bring data from sales invoice line table and show successfully but now I want add one more field sell to customer name
form sales invoice header table.
when i add these field and run then sell to customer name field shows blank and other field show data successfully which relates to sales invoice line table.

How did you add?

sir actually i have created variable of record type of sales invoice header in the global variable and then by assist button i add like this SalesInvoiceHeader.“Sell-to Customer Name” in the source expression .

sir actually i have created variable of record type of sales invoice header and then by assist button i add like this SalesInvoiceHeader.“Sell-to Customer Name” in the source expression .

You just have to add one line of code in OnAfterGetRecord() trigger of Page.

IF SalesInvheader.GET(“Document No.”) THEN;

where SalesInvheader is variable which you have added.

Thank you sir problem solved [:D]

Welcome

Please don’t forget to verify the solution(s) which solved your problem(s)