Query issue when trying to do a Inventory Report

[Imjafo]

I’m trying to do an Inventory report. But in columns “Part #1, Part #2, Part #3 etc. are showing the PartsID instead of the PartName.

I’d like to fix this, but I have no idea on how.



I know it’s got to be a simple fix in queries. This is how it’s set up now. Every adjustment I’ve tried, just breaks the database.

I figured out a work around by exporting my Inventory Report into excel. I wrote a code that changes the PartID to the Part name but it’s a pain to go through all of that. It would be some much easier to have Access do it from the beginning.
I’d appreciate any feedback.

[Welshgasman]

What good is a Docx?

You are probably using table lookups, which is NOT a good idea unless you know how they work.
Join the tables and use a query to get the part descriptions.

[Micron]

columns “Part #1, Part #2, Part #3 etc.

I smell a table that is designed like a spreadsheet. Records in database tables should be in rows and related to other records in other tables via related fields. That reads like the table(s) record data is in columns.

[madpiet]

It's hard to help if you give us only pictures. hard to tell if your table design is right. Got a mini version of your database?