I've made a grocery shopping database for myself (trying to cut down on expenses - lol).
Place: Where the item was bought.
Category: Is it 'broccoli', 'steak', 'cat food' etc.
Item: Specifics of each item i.e. brand, price, servings, picture, etc.
The idea is to go around to different stores and get prices of items and then have a reference list, off which I can shop which will display only the cheapest item in each category.
How do I display the cheapest item in each category on a shopping list, sorted by 'Place'?