Table Fields Help

[Alan]

I will try and explain this the best I can.
In my table I need fields L_1_1, L_1_2, L_1_3, L_2_1, L_2_2,
L-2_3.....notice how the second number increments. I need this all the way up
to L_50_1... I need to do this for quite a lot of fields...Does anyone know
of a faster way to do this?

I hope that all makes sense, if not ask questions

Thanks

 

[Duane Hookom]

This doesn't make sense since it seems quite un-normalized. Could you
provide some justification for setting up your table like this?

 

[Alan]

Yes, I have 9 records say L1-L9 which could be repeated up to 50 times each
so baiscally I could end up with 450 records. I guess one of my first
questions should be is there a limitation to how many fields can be in one
table?

 

[Duane Hookom]

You can have 255 fields in a table. Most veteran developers would suggest
that anything more than about 25 fields constitutes some form of
un-normalized tables. There are some basic information on normalization at
http://www.ltcomputerdesigns.com/JCReferences.html#DatabaseDesign101.