[Vince]

Quote:

Originally Posted by PowerPC603 The alternative is to use 14 separate columns, just for the components, where many fields would just hold "0". I'm also storing all vehicle-components in one column, where each component is separated by a "-".

The alternative, and the right way to do it, is to create a separate table for the components with two columns: vehicleid {PK, FK}, componentid {PK}. Simple.