Get one record in a linked table

[ipr1]

I created a database that performs certain functions ("functional database") and I want to archive the changes I make to that database's structure in a central repository that is nothing more than another database ("repository") that I will create to track all of the revisions made to the 80 or so databases within my department.

I would like to create a link on the main form in the functional database that will, on click open the specific record in the repository database that refers to the revisions previously made to the functional database.

Any suggestions? Thanks in advance for your help.

 

[Banana]

I'm not sure I understand what you want to accomplish.

If you want link to external table, it's File -> Get External Data -> Link Table

If you want to open a record based on a criteria, there is no difference between linked table and local table; whatever you use will work for either. Here's a sample search function. There's more in sample database forum if this doesn't meet your need.

If that wasn't what you are trying to, I'm sorry I misunderstood your question.