I have the following structure of a table.
currently the key is DivId, I also have PartID to set to autocrement by 1.
Id like to allow duplicate DIVID in this table. What is best way to handle it while maintaining the DivID as key.
should I remove the key in DivID and no key to this table?