Does SP have limitations? Can I store 50 attributes about one particular document if I want? Or should this be done in a database. I know that it is build on a database, but that doesn't mean anything to me.
Main question. Do your best to follow me.
Lets say I have a document library that contains reports on crayons. I also have a list of particular crayon colors with two columns. The first column in the list is very specific as to the color. The second column is the general column. For instance, column 1 might be ocean blue and column two would be blue. Lets say I want to view crayon reports by both types of data maybe. Is there anyway to select the specific color in a column in the report library and the general column will populate automattically? If not, does SP 2010 address this? I am using 2007. Is this a common problem. It seems like would be sought after quite frequently.