Matching with 2 different tables

(0) Share

Report

Posted on by Jade Ng

227

Hi all,

Is it possible to capture the data from 2 different tables?

I now have the table of Sales Lines (table id 36) and table of Pro.Order Line (table id 5406), actually I want to capture the data from table Pro.Order Line (field: Production Order No.).

But I have faced one problem is that, even through I have put the field of production Order No.(from table 5406) in the layout, but it not able to capture the data.

Then I'm think is it possible to do like this:

If the Table Sales Line (Field: No.) is same as the table Pro.Order Line (Field: item No), then it can capture the data of the Production Order No. from the table 5406. (Refer the picture below)

8233.Capture1.PNG

8233.Capture2.PNG

If it is possible, how I going to do this matching? I have try using the SETRANGE to filter, but it also doesn't work.

Thanks.

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Suresh Kulla 44,630 on at

Like (0)

Report

RE: Matching with 2 different tables

A page can have only one source, for your scenario the page source would be table 37 (Sales Line) but on the OnAfterGetRecord of the page, you will retrieve the Prod. Order Line using the filters, but just using Item No. filter will get you many prod. order lines because you could have multiple prod. orders for the same item. So you need to to use other filters to retrieve the record, then you could record variable field as the source.

Create a global variable and retrieve the record as mentioned above.

For example, check page 10010 where it displays a field from the SalesHeader table.