I have a point shapefile of survey locations. I also have a table of data corresponding to said survey locations. The problem is that many of these survey points have been surveyed multiple times or with different equipment. Each point has a unique primary key, and in the table, there are multiple entries with that same primary key, but it has another column that serves as a secondary key.
Is there a way to join the point shapefile to the data table by primary key, but make it create duplicate coincident points for each unique secondary key?