I'm trying to create a DB where i can manage my cigar stock.
I have 2 tables:
cigars : with the detail of the different cigar types and brands I have
humidor: with the different positions, where cigars can be stocked in my humidor. for each position I have a field with the cigar ID and a field for the icon, later on.
My Humidor has 14 shelfs, each shelf can stock up to 25 cigars. So i would have to create 350 fields for the cigar type and 350 fields for the icon field. And then I would have to add a script to all 350 icon fields manualy.
So my question would be, is there no way that this can be done easier?