Modifying primary key
Hello, I am in the process of building a database in Access 2016, which is my first time and I am struggling a little bit. A little context, I am building a database that will be used for QM/ reviewing reclamation purposes. In most reclamations there is more than 1 part. I want it to be that there is one superior number that represents the wohle reclamation and additionally 1-x number that represents the superior aswell as the single part number. Example: superior: 471123 single part numbers: 471123-001, 471123-002, 471123-003, etc. Currently I have both of these numbers as primary keys for their own tables. Does anyone know if and if yes how this would be possible? Best regards Moritz