Running forms on temporary tables

Mauddib

I am designing a report that reconstructs old purchase orders by adding together all the purchase receipts and constructing a single purchase order. The report then reports on this table.

To test this I would like to see the contents of the tables I have created, which are temporary tables declared in my GLobal Variables of Type Purchase Order Header and Purchase Order Lines.

How do i go about running code that will run either of these tables, showing me the contents in the same way as running the normal tables.

GaMBe

DenSter

You should archive your purchase orders instead, and add access to them from the regular Navision menus. It's much easier to accomplish, and that way you have copies of the actual document instead of trying to piece them back together.

ara3n

FORM.RUNMODAL(FormID,TempRecord);
And I agree with Denster, You can use Archiving.

Mauddib

Possibly correct, but at the same time there is years of receipts which havent arhived purchase orders so either way ill have to reconstruct them, either in the report, or as a once off populate of the archive table.

THanks for the help lads,

GaMBe