What I really need is a way for users to create, using numeric text boxes, ranges for quantities of items with their corresponding prices. For example:
*Qty |____1_____| - |____50____| : $ |____4.00____|
*Qty |____51____| - |____99____| : $ |____3.50____|
*Qty |____100___| - |____??____| : $ |____3.00____|
What do I display in place of the ?? and how do I allow users to enter in that value? I can't have users leave the field blank if it should be infinity because the business thinks that will allow users not to validate that the field "should" be blank.
Bonus points: how does that value get stored in the database? (I know... more a of db issue than UX).
I'm just diving into UX at my company and I feel like I don't even know what terms to use when searching for this. My apologies if this has already been covered.