AnsweredAssumed Answered

Show only cheapest item in each category on shopping list

Question asked by RyanAshton on Jul 28, 2018
Latest reply on Jul 28, 2018 by philmodjunk

Hi community,


I've made a grocery shopping database for myself (trying to cut down on expenses - lol).


Three tables:

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'?