Select case Limitations

[AMD3000]

Hi everyone,

I am wondering if there is a limitations on how many cases you can have in a Select Case. I want to write a function where i can calculate some fields but i have around 250 types of windows, Which I will have to have around 250 cases.. Am I nuts?????

Any ideas, suggestions would be appreciated

Thanks
AMD3000

 

[RV]

i have around 250 types of windows, Which I will have to have around 250 cases

Sounds to me you could do with a bit of normalization
A SELECT CASE per type doesn't make sense.

RV

 

[AMD3000]

I am trying to write an order entry application. We are a Windows company. We have something like 1200 types of windows, terrace doors, screens, etc. But around 200 to 250 windows Series to calculate how the extrusions are going to be cut and the glass. All those calculations have a formula by Windows series.. That is why I was trying to figure out if I can have that many case stamens.

 

[RuralGuy]

AFAIK there is *no* limitation to a Select Case structure but it still sounds like a normalization problem to me too.

 

[AMD3000]

Thanks you guys. I am pretty new at this so I am not sure if I am doing this right. See I have a form where information about an order would be enter, then I have a Tab that would have the detail information about the order( so I have two table one for order and one for details) When they enter the details of expecific window, they need to enter Heigth and width and Vent and many other things. But with the H, W and Vent I need to calculate 13 fields that are need to build this window. So I thought I would create a function so when:
Select Case SERIES
Case 100, 140, 200, 240
UpperW = DWIDTH - 3.9375
Case 125, 225
UpperW = DWIDTH / 2 - 2.3125
Case 130, 230
UpperW = (DWIDTH - (2 * DVENT)) - 0.125
.
.
end Select

this is just for one of the field.

Please if there is a better way. I Not sure how to do it with a table.

thanks,
AMD3000

 

[DB7]

Great Advice, Pat!