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/ rev...
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
Sorry for my late reply, I had already found another solution with the use of VBA.
Thank you though.