Hello,
Currently working on a database for a "somewhat standard" product with lots of options customers can purchase. Options are almost all "yes/no" type, with a smattering of "if yes, how many" type scenarios. Database uses the product serial number as the primary key.
So, is the best way to handle this to create tables with the serial number as primary key, then a yes/no field for each option? I end up with lots of fields (either in one table or spread across several tables).
Thanks so much!
-Timothy
Currently working on a database for a "somewhat standard" product with lots of options customers can purchase. Options are almost all "yes/no" type, with a smattering of "if yes, how many" type scenarios. Database uses the product serial number as the primary key.
So, is the best way to handle this to create tables with the serial number as primary key, then a yes/no field for each option? I end up with lots of fields (either in one table or spread across several tables).
Thanks so much!
-Timothy