@al3xicon thx, but I need to look at the transaction level to see what Assembly's member items on Sales Orders for forecasting what items are needed and then see what's on hand. Perhaps there is a way to combine saved searches or clever SQL functions to get the desired results?