Hi Cetin,

this is what I have made in the past.

Now I want to make more.

Close All
set fields global
Use customer
Use orders In 0 order tag cust_id
Use orditems In 0 Order tag order_id
Set relation to cust_id into orders
Set relation to order_id into orditems in 'Orders'
Set Fields to cust_id, company, ;
  orders.order_id, orders.order_date, ;
  orditems.line_no,orditems.product_id, ;
  orditems.quantity,orditems.unit_price,;
  Price=orditems.quantity * orditems.unit_price
Set Skip to orders, orditems
**** i want change workarea, and use calculate FIELDS
SELECT 0
USE prices
LOCATE FOR price=customer.Price

Fabio