I have 2 simple tables - an item Master and a table for the Bill of Material for the items in the master.
Master (tblItemMasterMain) has all the items - those which need a BOM (Serial no ends with .1) and those which are part of the BOM . All items in this table are unique - no duplicates.
The second table (tblItemMasterBOM) captures the relationship of the Main items and the BOM items.
The issue is the report to capture this relationship. There are 2 reports in the enclosed DB. rptItemMaster is the main report which includes items from tblItemMasterMain ending in 0.1 and the sub-report for the BOM- report rptItemBOM and link field is the SerialNo for the 2 reports.
For some reason, the report takes ages to populate! I am making some mistake which I am not able to identify. Will appreciate some help
I have reduced the 2 tables to reduce the DB size. Original table has about 4000 records in the main table.
Master (tblItemMasterMain) has all the items - those which need a BOM (Serial no ends with .1) and those which are part of the BOM . All items in this table are unique - no duplicates.
The second table (tblItemMasterBOM) captures the relationship of the Main items and the BOM items.
The issue is the report to capture this relationship. There are 2 reports in the enclosed DB. rptItemMaster is the main report which includes items from tblItemMasterMain ending in 0.1 and the sub-report for the BOM- report rptItemBOM and link field is the SerialNo for the 2 reports.
For some reason, the report takes ages to populate! I am making some mistake which I am not able to identify. Will appreciate some help
I have reduced the 2 tables to reduce the DB size. Original table has about 4000 records in the main table.