Hi all, here is my problem, the context is an order with associated product.
I want to compute the total price of an order, to do so I made a chart with an unit price, quantity and total price column.
But I have two different types of products, each one stored in his own table in the database. So their primary keys can conflict.
What I would like is a chart with the 3 previously defined columns where the two different types of products are mixed. So I could compute the total price of an order using one chart.
The price depend on the date order and is dynamically computed based on the product key.