Unanswered: Adding additional data to a list of items
I am trying to create a report of inventory items and link sales history to the items. In one table I have all the items. In two other tables I have 30 day sales history and 90 day sales history data for the items that exist in the original list. I would like to add the sales history to the list of all the items. My linking of the items results in just those items with sales history however. I suspect that I am overlooking a simple way to keep the original list in tact and add the sales history to the items for which there is data.