Need Suggestion in table design ?

[siamandm]

Hi

if i have a tables like this screen shoot below :

S1640.png

for the table tent , Tent No will be 1 to 300 for each section, for example, section A , i will have A001 to A300 , section B : B001 to B300 and so on
for this i have to fill the table tblTent 1 to 300 many times for each section like below:

Capture.PNG

in my opinion, this will make tblTent so big and this is not the way to do it, if I'm wrong please suggest the best way and professional way to do it?

regards

[HansV]

If you don't, you won't have unique TentIDs.
You could create the list of SectionIDs and TentNos in Excel - you can easily create a series of numbers there. Then copy/paste into tblTent.

[siamandm]

thanks a lot ...

Regards