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


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.

How much data in SharePoint as well as how to store it.

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.