Discount based on options or sets from dropdown

You would eventually populate the options list with the options id. Then create your own recordset that filters based on the selected option and returns whatever information you need to dynamically change with that option... including price, name, quantity, or whatever else you want that list to control.

There are a variety of ways to do it. One way might be to have an option group table and an options table. The product table would have the option group assocated with it, and the options in that group are then associated to the group. Each product could then have unique options, or share options with other products that have the same option groups.