report that uses several tables as a source of data

Modibo

hello I'm on a report that uses several tables as a source of data
I have a table like dataItems
I wanted to know how to use other tables without adding them as dataItems

suraj92291

adding as a Record variable ? I guess

Modibo

Yes,
exactly

TallyHo

Take a look here, this is basic stuff.
https://www.olofsimren.com/wp-content/uploads/2014/03/NAV-CAL-Programming-Guide-for-Microsoft-Dynamics-NAV.pdf

sjen

Go to global variables and declare your record and the variable and use it onaftergetrecord trigger.

For example, if you have a purchase line data item and you want the job record there, go to onaftergetrecord trigger.

CLEAR(Variable);
IF "Job No." <> ' ' THEN BEGIN
  Job.GET("Job No.");
  Variable := Job.fieldname;
END;