Lookup Tables Constrained
Ok I'm a DBA I don't make any mistake i'm not a developer. But I've been faced with an issue that span's both and I'm trying to help a developer figure out the best way. So if anyone has any suggestions let me know!
What were looking for is the best way to constrain drop down boxes based on there previous entries. So on a form we have 4 drop down boxes. Something like different types of service and different products within those services. We only want the products for that service not all products. So after choosing the service what's the best way to constrain the product list? There is an entry in the products table but it will be quite a few joins and i don't really want to do that everytime someone is pushing the drop down button. I thought of a table that holds pretty much all of it but i can't think of one way to still get it all in a decent speed. How about a stored proc that passes one variable then 2 then 3 and so forth and so on? That might be an option also. I haven't found a ton on the web so if anyone has suggestions let me know. Thanks
pat