Show Part Description Maps

Here is a query you can run using Reports > Run SQL Query to display all your part description maps together in a grid. It is not dependent on which document is open.

Change the last line to use your Document Title.

select pcm.PartCategoryNm, pd.PartDescriptionNm, p.PositionNm,  
nc.NapaCommentID, nc.NapaCommentText, b.BrandNm, npc.LineCode, npc.MPCC, npc.NapaPartDesc  
from PartCategoryMap pcm  
join PartDescription pd on pd.PartDescriptionID = pcm.PartDescriptionID  
left join Position p on p.PositionID = pcm.PositionID  
join PartCategoryMapPcc pcc on pcc.PartCategoryMapID = pcm.PartCategoryMapID  
join Brand b on b.BrandID = pcc.BrandID  
join NapaPartCategory npc on npc.PCCCode = pcc.PCCCode  
left join PartCategoryMapComment pcmc on pcmc.PartCategoryMapID = pcm.PartCategoryMapID  
left join NapaComment nc on nc.NapaCommentID = pcmc.NapaCommentID  
join Document d on d.DocumentID = pcm.DOCUMENTID  
where d.DocumentTitle = 'your document title here'
Revised: 2023-06-06