How can I create points from a spreadsheet that do not contain xy? I just have a list of data, but some of that data includes location such as Section 1, Block 122. I have a separate polygon layer that has all of the sections/blocks labeled, but I would like to add this information "automagically" without manually creating each point and then linking the data. Thank you.
But, I don't want the data to live in my polygon layer. I want it to create points within that polygon. I could not find a way using join/relate that gave me what I was after. Am I doing it wrong?
That doesn't sound like it will save me any work. Some polygons will end up with 1 point and some will end up with 10. So, if I created centroids, I would need to create the max for each polygon and remove the extras, right? Is there something I'm not thinking of?
I like Darrens ideas. Maybe do this:
I believe that way it will keep all of your tabular data and then have it be the attributes of the new points (though, I would imagine the points would be on top of each other).
EDIT: I just saw Darren's post. Related tables might be the way to go.