I am trying to build a database for my law firm to log documents we are storing for clients.  I have created the form that will form the record card for each client and I have a table that shows the basic client details (e.g. name, address, etc).

What I’d like to do, is to be able to hyperlink the Client ID number (primary key), so that when you click it on the table, the associated record card form pops up, so you can see/complete the details of the documents stored.  I’m quite new to Access and there are lots of templates in Access that do this, but even with the use of Copilot, I just cannot seem to figure out how to do this.

Any guidance would be very much appreciated 

​I am trying to build a database for my law firm to log documents we are storing for clients.  I have created the form that will form the record card for each client and I have a table that shows the basic client details (e.g. name, address, etc). What I’d like to do, is to be able to hyperlink the Client ID number (primary key), so that when you click it on the table, the associated record card form pops up, so you can see/complete the details of the documents stored.  I’m quite new to Access and there are lots of templates in Access that do this, but even with the use of Copilot, I just cannot seem to figure out how to do this. Any guidance would be very much appreciated   Read More

​