Table Fields Help

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?

--
Duane Hookom
MS Access MVP


"Alan" wrote in message
...
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

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" wrote:

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

--
Duane Hookom
MS Access MVP


"Alan" wrote in message
...
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

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/JCR...abaseDesign101.

--
Duane Hookom
MS Access MVP


"Alan" wrote in message
...
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" wrote:

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

--
Duane Hookom
MS Access MVP


"Alan" wrote in message
...
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