Table Fields Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
This doesn't make sense since it seems quite un-normalized. Could you
provide some justification for setting up your table like this?
 
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?
 
Back
Top