I am designing a web based system for consumer vehicle configuration. The options list for the various vehicle models includes combinations which exclude certain options and require others. Currently we just have the elementary system working with the full option table, full model table, and the options by model tables.

I have some thoughts regarding the design and stored procedures for interactively returning a cursor of both the excluded and required options based on the currently selected options. However, I suspect that many of you have already dealt with this design challenge and have some good ideas for both design and stored procedure code. I openly welcome any suggestions and code examples.

Thanks

Glenn