Loops problem...

[boryspower]

Hello,

I want to create simple report of orders/stock of items, but I have problem with "loops"... Anyone could help me?

I attach screen of the loops and sample file that recreates the problem...

BR

Borys

[#2]

You need to join the tables Order and Order_spec. For instance ...

Order:
LOAD * FROM Order;
Order_spec:
LOAD * FROM Order_spec;
JOIN (Orders) LOAD * RESIDENT Order_spec;

The tables will be joined on field order_id.

[#3]

As mentioned in the earlier reply, please find the attached file which contain joined Order and Order_spec table.