I have two databases, one with sales records and one with stock records.
I can create a report that summaries sales records (grouped by a category) and
I can create a report that summarises stock holding (grouped by category)
But I cant seem to create a report that shows both.
The report will only extract inventory records that happend to be in the sales database. Where I would like the sales report to summarise all sales (per category), and summarise all inventory items (per category) regardless of whether there was any sales activity for an individual item.
I dont quite know where to start with this problem