Modifying primary key

[Moritz1003]

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

[#2]

@Moritz1003 

I think you can create a query, select both tables, select each PK, and in the third column enter this expression (of course modifying for your field names):
WholeReclamation: tblSuperior.SuperiorNo & "-" & tblParts.PartNo

[#3]

@Tom_van_Stiphout 

Sorry for my late reply, I had already found another solution with the use of VBA.

Thank you though.