quote:Originally posted by bananas
Would i be better creating a new table for each CompID?
You need to study up on database normalization
. This is a set of rules concerning database table design which have been in existence since about 1972. A database is said to be normalized
if it complies with these rules.
The very first rule essentially states that the data in a column be atomic, that is, comprised of simple, indivisible values. This form precludes multivalued attributes (groups) and composite data, such as the column you suggest.
Tables which violate first normal form can be very
difficult to query against. For example, try to write a query against your proposed structure which lists all the links which worked last month...
Custom Apps, Inc.