Display data on tb body of report frm another table.

zulq
zulq Member Posts: 204
edited 2008-06-13 in NAV/Navision Classic Client
Hi,
Designing a report based on two tables. The first table A has category and second table B has category and category value. Now I am listing all the categories on table A but also want to display the corresponding category value of each record from table B. Any ideas how to implement this.
Please help as soon as possible.


Thanks.
Few years ago we were not existing and few years to come we would be in the grave! So what will benefit us in the grave?

Answers

  • Albertvh
    Albertvh Member Posts: 516
    Hi

    Why don't you just use table B as it contains both fields that you require?

    Otherwise you could do the following
    Declare Table B as a global variable
    in the AfterGetRecord function of Table A
    TableB.Get(Code);

    Add a text box on the line of the report and put as SourceExpr TableB.Value


    Hope this helps


    Albert
  • zulq
    zulq Member Posts: 204
    Thanks a lot Albervh. I've done similar things before but it was sometimes ago was working on linux and email stuff and java. Just got tasks again.
    Thanks.
    Few years ago we were not existing and few years to come we would be in the grave! So what will benefit us in the grave?

Categories