Forum Discussion
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
2 Replies
- Tom_van_StiphoutSteel Contributor
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- Moritz1003Copper Contributor
Sorry for my late reply, I had already found another solution with the use of VBA.
Thank you though.