I need to relate 3 tables e.g. prod, series, sub-series and noticed that when I am using composite primary key it cannot be incremental. This is my plan and I will appreciate it if you give me some help:
table 1: prod has prod_id (PK) and desc
table 2: series has prod_id(FK and PK) and series_id (PK)
tables 3: sub-series series_id (FK and PK) and sub_series(PK)
if this is a right approach, how can I make prod_id and series_id incremental ? and same thing about sub_series table?
if not, then what you suggest?
Thanks in advance,