How to Access a field in another table

Lalaka

Hi!

I have a requirement where I need to access a table field in a table which is not included in the reports data item.

I have few options to do this.

Create a Record variable of the sub-type which is the external table and access that variable and iterate through values with SETRANGE, SETFILTER etc.
Create a temporary table write data to it and retrieve it from there
Access the required field during the run-time.

What is the most recommended option?



PS:

I have to look for Vendor Invoice No in Purchase Order Table, But only Purchase Receipt Header and Purchase Receipt Line is used in the report.

mohana_cse06

Use option 1

Lalaka

mohana_cse06 wrote:

Use option 1

How about the 3rd Option! Will it be efficient if I retrieve them during run-time

mohana_cse06

What exactly you mean by option 3?

Even option one can be performed at run time..

Lalaka

mohana_cse06 wrote:

What exactly you mean by option 3?

Even option one can be performed at run time..

Yeah I got it! Sorry! :oops:

Thanks for the reply!