AnsweredAssumed Answered

Related Tables

Question asked by Alex_Riva on Jul 21, 2009
Latest reply on Jul 22, 2009 by comment_1


Related Tables



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?


Thank you,