First, let me explain what I`m trying to do. This will help me to clearly define my problem.
This database can be basically divided into two sections: Logs and Subjects.
For the first section, I have four logs. However, in the sample database, only the Event Log is present. Each of these logs have two form: a List one (Event_Log) and a Detailed one (Event_Details). As you can see, in the Detailed one, there is a subform showing the subjects it is related to.
The second section of the database contains the subjects that are used to indicate what the logs are related to. This section is broken down in four parts: personnalities, organizations, places and other. These subjects all have detailed pages that show all logs records they are related to (Related_to_Organization_Details; Related_To_Others_Details; Related_To_Personnalities_Details; and Related_To_Places_Details). When you open one of these four, The four tabs contain subform showing the records of the respective logs where these subjects are related to.
Please tell me if what I`m saying doesn`t make sense...
So, what I would like to do is, when I`m looking to a detailed page of a subject, to be able to double-click on the shown records and then be able to go to the detailed page of this log. (In the Sample, open the Related_To_Personnalities_Details form and go to the Event Log tab. In this example, I would like to be able to have the detailed page about Personnality A being spotted by just double-clicking on it)
Also, I would like to be able to do the opposite, but if the first one can be possible, I`m pretty sure I can find my way to get this one to work also (there is four Related table... so also need to tell them what is the good one to open)
I did search on the site and internet on how to do it, but I cant make it work... I am obviously doing something wrong... Any help will be greatly appreciated.
HERE IS THE SAMPLE DATABASE: LogBook.zip