How to Access a field in another table

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.