Non-unique primary keys, creating coincident points based on secondary key

Discussion created by iboates on Oct 11, 2013
Latest reply on Oct 11, 2013 by rfairhur24
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?