I am working in Access 2003 and have a very simple table that contains a PIN (personal id number indexed dupes ok), Show, Media, and status. The purpose of this table is to show what people are in an art show, what their media is, and whether their application has been accepted or wait listed. Any artist can have multiple applications in any media, and they also can have two submissions in one media:

Pin Show Media Status...