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
Copied!