>5 tables in my (simplyfied) model :
>
>PRODUCT
> prod_id
> descr
>
>PRODUCT_SUPPLIER
> prod_id (related to PRODUCT.prod_id)
> supp_id (related to SUPPLIER.supp_id)
> purch_price
>
>SUPPLIER
> supp_id
> name
>
>PURCH_ORDER
> order_no
> supp_id (related to SUPPLIER.supp_id)
>
>PURCH_ORDER_DETAIL
> pk
> order_no (related to PURCH_ORDER.order_no)
> prod_id (related to PRODUCT.prod_id)
> qty
>
>To calculate order totals I need to get from the order detail to product supplier, and when doing this in crystal reports, it says that having "differents paths pointing to the same table and this is generally not supported" and I don't get correct results. What is wrong with this approach ?
I don't know about Crystal Reports, but I do have some comments about the table structure in general. Since you posted a simplified structure, you may already have done this.
1) The purchase order detail should include the current price, at the moment of the sale. Otherwise, if your price changes, you won't know at what price you have sold, say, a year ago.
2) For quick access, relevant totals for each order should be stored in the order header.
This has nothing to do with requirements of Crystal Reports, but perhaps, on the way, accessing the information with C.R. may become simpler.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)