field size exceding 255

[sp00k]

I have a table with multiple serial numbers(serial numbers, part numbers, part desc, a second serial number) which exceeds the amount of fields. I know there is an easy way to fix this, but i can't think of it at the time. My table looks a little something like this.

SerialNumberA38
SerialNumberA39
SerialNumberA40
PartDesc1
PartDesc2
PartDesc3
etc.

I also have two forms, one for a 3 certain parts, and another for 6 other parts, each with their own serial numbers.

So I should have 9 tables(one for each part) and then another 9 tables for each one of the parts serial/desc/part number. and Join the relationship between them somehow(unsure what foreign key i will use)

Basically how would you set this up? or am I doing it all wrong?

 

[The_Doc_Man]

See my answer in the "Theory and Design" sub-topic. My suggestion there will also answer your problem here as a side-effect.

For other forum readers: This is caused by a SERIOUSLY denormalized database that isn't even 1st normal form.