Same value showing up for both Items

[alnilla]

I made a query and there are two tables the report it being pulled from. tblMaterials and tblJobpartrun. The issue is on the tblJobpartrunsheets there are MaterialID1,MaterialID2,MaterialID3,MaterialID4. Which have a relationship with MaterialID. The only thing I want from the tblmaterials is the ID # to be linked with the price of that material. When i create my report the same price value for MaterialID1,MaterialID2 etc is the same its not different. What can I do so they are different?


Thank you for your suggestions.

 

[boblarson]

First off, the table structure is not normalized and should be different. But if you are stuck with that, the only way around it is to add the tblMaterials into your query 4 times and link each one of them only to one of the MaterialID fields in the tblJobpartun table.

 

[alnilla]

Thank you for your quick reply! I didnt make the database just getting thrown into this. I will try that later today and reply back

 

[alnilla]

I believe i did what you asked and it still coming up the same. The first value in the report M1C is the correct value. The second one isnt.

Did i miss anything??

Only thing i need from the materials table is the cost for that particular ID.
Thank You Again!

 

[alnilla]

I figured out the problem I didnt put the table_1 into the qry. Thanks for you help guys!