AnsweredAssumed Answered

How to get data from and unrelate table

Question asked by Dracozhu on Jan 7, 2010
Latest reply on Jan 7, 2010 by Dracozhu

Title

How to get data from and unrelate table

Post

I had Inventory Table(include price), and a Product Table

In Product Table, there is some variable that may change the material will be used and the number been used

In Inventory Table, there lots differenet material

 

I want get a cost that, price*quanlity

However, I cannot think a connect between this two table, which make me confused

Becaused, there will be logical or if statment to get which one in connect....

 

How should I do that?

Outcomes