How to create a data link between two tables at runtime

Lalaka

How to create a data link between Purchase Receipt Header and Purchase Invoice Header.
What I want is to retrieve a related record field (Vendor Invoice Number) in the Purchase Invoice Header while the Report is running from Purchase Receipt Header and Purchase Receipt Line.
Any help would be appreciated.
Thanks!

mohana_cse06

http://www.mibuso.com/forum/viewtopic.php?f=23&t=51347

sameerar

Write the code in Purchase Receipt Header Data item OnAfterget record.

PurchaseInvoiceHeader.Setrange("Order No".,Purchase receipt Header.Order No);
IF PurchaseInvoiceHeader.Find('-') Then
VendorInvoiceNumber := PurchaseInvoiceHeader."vendor Invoice No";


This is a sample Pseudo code. hope u can understand.