I am building a database to monitor trail usage inside a park. The main tables are:
1. Trekking (which are small trails)
2. Trail (consisted of many trekkings)
3. Trail Log (a log is created each time a group of people hikes a trail)
Since a trail is consisted of many trekkings and one trekking can be in more than one trail (n to n relationship), I used another table to link them named 'Trail_Composition'. Aditionaly, since a log can have many trails and a trail can be in many logs, I also created another table to link them named 'Log_Composition'. The file is linked like this:
Trekking ----< Trail_Composition > ---- Trail ------< Log Composition >----- Log
I created a portal inside the Log layout in order to insert the trail information and everything is working fine.
What I don't know how to do is how to create a report based on the Log table that shows all Trekkings that were used. I could easily create a report based on trail usage, or make the trakking information to be displayed inside a portal. But this is not the solution I'm looking for. Can you help me?