Linking one primary key to another?

[Kat-ness]

This is my second post. I'm new to Access database design and creating a database to manage applications.

I want to use the application number as the primary key. There may be renewals or amendments made to the original application and they are assigned a new number (the old number with an additional letter/number).

Is there a way to link the renewal or amendment to the original application? It would be preferable to just add an amendment/renewal table and sub form to the original application and somehow have another primary key (I suppose that table's primary key?) for this with the amendmended/renewed application information as most of it will be repeated from the original application.



But I would also like to be able to run queries and reports that will link back and pull original applications (without renewals) AND the renewed/amended applications, still containing the original application information.

[Kat-ness]

I just found the answer for this in a different way...no need for me to do this anymore. Thanks!