I post music videos on my site and I add the artist name as a custom field to each post. I want to associate certain meta with that artist name so I dont have to enter it everytime like the artists twitter account and link to Facebook. So my question is how could I enter in their meta data once somewhere and call it to every post automatically where their artist name is entered for a field. Hope I explained that right.
I think the way I would tackle this would be a non-hierarchical taxonomy. That would allow you to tag the artist and such as well as give you a few fields to work with for basic data input...you also have the ability to expand, should you need it. If you're going to have a lot of terms and you need additional fields, I think I would store those in a custom table for ease of access and to keep clutter down in wp_options. I can provide pseudo code for any of the above implementation.