Hi guys,

I have 3 tables : Products,  Purchase_order, and finally Product_purchase as a relation between the two table where I store the quantity and the sub_price and other fields.

I want to create the invoice table which is related with the purchase_order, each invoice have one purchase order.

I'm wondering what is the best way to relate the Invoice with the products and display theirs details from product_purchase table and from the product table.

I tried to display it as a sample XML and also as a related fields but without success.

Any help will be appreciated :) thanks.