I realize I haven't done a good job explaining what we are trying to accomplish.
We wanted a very easy way for our designers to assign both a material and a finish to each part.
First: the material is obviously very simple; Inventor has a material list that can be populated with our most-used materials, and this can then be linked to a "Material" field within the .idw environment.
Next, we were looking for a way to quickly and easily assign a finish to the part. A finish, in our case, doesn't necessarily mean a finish in the conventional sense; it COULD mean anodizing an aluminum part, it could mean deburring a UHMW part, or it could mean routing the edges of a poly carbonate part. So what we did was create custom appearances that would cover 95% of what we wanted to accomplish. (At this point, both the material and the appearance are being used to populate fields within the .idw).
Here is the problem: For example, we use the same "Routed Edges" finish on both black UHMW and on clear poly carbonate. When the appearance was created for "Routed Edges", we used a clear appearance because at first, we were only thinking about using that finish on clear poly and we didn't take into account that we also use that same finish on black UHMW. This is fine if we select that when creating a clear poly carbonate part, but if we assign the "Routed Edges" to a black UHMW part, you can see where the issue would be because the black UHMW part is no longer black. It is clear, because the appearance that was created to make a finish will apply to the part.
All of that being said, I understand fully that what we are doing is trying to use the appearance feature in a way that it wasn't intended to be used; it was just a quick way to try to assign a finish to a part and move on. I see now that I will probably just have to learn some VBA, create a finish dropdown dialogue, and have a list of finishes in it which will then populate a custom iProperty, which will then populate the corresponding .idw field.
Sometimes, it's hard to convey what is trying to be done and I apologize about that.