Display data on tb body of report frm another table.

zulq

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.

Albertvh

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

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.