This page follows on from importing data page.
We now need to add 2 additional tables, purchase and company:
- purchase - this allows recording of individual purchases. I've shown it as being one-many with products but it would be better if it were many-many. A purchase could contain many products and a product could be bought on many occasions
- company - the company could represent a manufacturer or a retailer, therefore it is linked to both product and purchase.
We also need to have more powerful ways to search these tables.
I experimented with creating a query by I cannot find anything useful yet: