I have a form that allows employees to enter the width and height for a product on a form.
The width and height are then combined with the type and sizing to make a unique id. That unique id is then looked up in the table to get the price for that specific product.
The product is blinds which can be customized.
So.... if an employee enters a width of say "34" that isn't an actual width of the blind. The blind is actually "36" in width, and it is cut down to the 34 in the shop.
-----------------------------------------------------------------
So....here is my question: (I am trying to figure out the best way to do this as I haven't done this before)
Do I write an "if" statement that says something like:
If the width entered is between 24-35 change the width on the id to 36?
The blinds have a width of 23, then the next width is 36 so anything inbetween 24 would need to convert to the 36 width.
Thanks! I've learned a ton from reading the forums.
The width and height are then combined with the type and sizing to make a unique id. That unique id is then looked up in the table to get the price for that specific product.
The product is blinds which can be customized.
So.... if an employee enters a width of say "34" that isn't an actual width of the blind. The blind is actually "36" in width, and it is cut down to the 34 in the shop.
-----------------------------------------------------------------
So....here is my question: (I am trying to figure out the best way to do this as I haven't done this before)
Do I write an "if" statement that says something like:
If the width entered is between 24-35 change the width on the id to 36?
The blinds have a width of 23, then the next width is 36 so anything inbetween 24 would need to convert to the 36 width.
Thanks! I've learned a ton from reading the forums.