Menu with multiple sub menu's

[Simtech76]

Morning,



I have created cascading combo box menu's however things are getting complicated as many sub menu's have duplicate outcomes. For instance the first menu box would be all the companies, 2nd menu would be the service that they are enquiring about, 3rd would be fault with the service and 4th would be the resolution. Not every company would have access to the same service however many would be duplicated, many of the 3rd menu faults would be duplicated as would the outcome. At the moment I am having to populate every possible outcome and end up with many over 300 entries in the final table.

Sorry if I have overcomplited things but for each menu some options are unique and others are duplicated. Anyone have a suggestion ?


Regards
Simon

[Beetle]

Can you provide any insight as to your table structure and an example of the data and what's being duplicated?