Have three tables: Project, materials w/qty and material cost. Project and materials have a relationship. I want to build a query where the info from these two tables can show the info and the material used will go to the material cost table find the cost of that material multiply it with the qty and give me a total cost for the materials used.
Please advise
Please advise