Need more feedback today
As I build out the NC database content, it is becoming clear that I need to add a "Sub-brand" or "Line" field for many of the NC brands. For example, if I add Gurkha to the current database, I would have a separate "brand" for Gurkha Grand Reserve, Gurkha Legend, Gurkha Master Select, etc.
I'm thinking of adding a Sub-Brand field so that the brand is Gurkha, and then have a drilldown from Gurkha to a page showing the sub-brands of Grand Reserve, Legend, Master Select, etc. The same is true of Rocky Patel, Oliva, JPG and others.
The trick will become handling the situation where there is NOT a sub-brand for a given brand, or where sub-brand is not filled in for SOME of a particular brand, but is filled in for others.
How should the drilldown work?
Thoughts anybody??