I'm trying to use a field in my shapefile with summarized zip code data. I have a table of hospital admissions data and in this table there is a field of zip codes which are repeated multiple times. What I'm trying to do is join this field of zip codes to my existing US zip codes boundaries shapefile, which mentions the zip codes only once. So the relationship is one:many.
I realize I must summarize the field on my table and then join it to the shapefile that way, but I don't want to lose all of the other data. In lieu of doing just a relationship between the shapefile and my data table, I'd like to do a join so that I can display the data in various ways. Is there a way to do this? Here is a picture of my tables: