Report Totals using a changing value list
I'll start by saying what I want to do:
I'm writing a database that will track drawings (aka DESIGNS), with various data about each design, including date assigned, date completed, the name of the artist, etc.
The ARTIST field uses a value list derived from a different table, so that when the staff changes, the value list will change with it.
I would like to generate a report that shows all of the Artists, and the number of designs they have on their plate.
What is the best way to go about this?