I need to be able to compare two bills of material against each other and only view the differences between the two. I'd like to have a report setup with drawing_info_a on the left and drawing_info_b on the right.
pertinent applicable information:
Tables:
BOM Query - this holds Part_Number and Component (description) fields (only information pertinent to this query) for (respectively) drawing_info_a
BOM Compare - this holds Part_Number and Component (description) fields for drawing_info_b
I have an unmatched query working now that just shows the difference of drawing_info_a from drawing_info_b.
this works well if two lists have the same number of parts. however, if list a has 5 parts and list b has 10 parts, my difference query will yield semi-correct results.
pertinent applicable information:
Tables:
BOM Query - this holds Part_Number and Component (description) fields (only information pertinent to this query) for (respectively) drawing_info_a
BOM Compare - this holds Part_Number and Component (description) fields for drawing_info_b
I have an unmatched query working now that just shows the difference of drawing_info_a from drawing_info_b.
this works well if two lists have the same number of parts. however, if list a has 5 parts and list b has 10 parts, my difference query will yield semi-correct results.