PS. I see you do have an artists table. So, you have simply chosen to use the wrong table for your RowSource.
Try the cascading combos. That should solve your selection problem.
Also, fix your schema to always enforce RI. If you get an error message, then the many side table contains...