Nesting Trackers Question
I thought there was a way to reference information in one tracker in another tracker, but now I am confused.
| Tracker | Record | Field | Type | Content | Name |
| 1 | 1 | 1 | Rating | 3 | Rating |
| 1 | 1 | 2 | Text | Today's News | Headline |
| 1 | 1 | 3 | User Selector | Fred Flinstone | Author |
| 1 | 2 | 1 | Rating | 5 | Rating |
| 1 | 2 | 2 | Text | Flood in Argentina | Headline |
| 1 | 2 | 3 | User Selector | Bert Whistle | Author |
| 2 | 1 | 1 | User Selector | Fred Flinstone | Author |
| 2 | 1 | 2 | Text | 12 Dogfood Blvd | Street |
| 2 | 1 | 3 | Text | Bangor | City |
| 2 | 1 | 4 | Text | Maine | State |
| 2 | 2 | 1 | User Selector | Bert Whistle | Author |
| 2 | 2 | 2 | Text | 13 Dogwood Ave. | Street |
| 2 | 2 | 3 | Text | Portland | City |
| 2 | 2 | 4 | Text | Oregon | State |
I want to create a combined list / tracker where Author field relates or indexes from one Tracker to the other. The combined list will display the Author, Address, and News Details e.g. Tracker 1 and Tracker 2.
Please pardon my mental lapse - I am sure it should be possible but can it be done using trackers or does it need some coding??
Display would be using the wiki plugin or smart code etc
Does anyone have an example of this?
============================================
Added this bit to make the output required clearer
| Author | Rating | Headline | Street | City | State |
| Bert Whistle | 5 | Flood in Argentina | 13 Dogwood Ave. | Portland | Oregon |
| Bert Whistle | 2 | Tax Evasion for Dummies | 13 Dogwood Ave. | Portland | Oregon |
| Bert Whistle | 5 | Ten Top Tiki Tips | 13 Dogwood Ave. | Portland | Oregon |
| Fred Flinstone | 3 | Today's News | 12 Dogfood Blvd | Bangor | Maine |
| Fred Flinstone | 4 | I thought "The Onion" was a real news site! | 12 Dogfood Blvd | Bangor | Maine |
| Fred Flinstone | 3 | My plans for 2012 | 12 Dogfood Blvd | Bangor | Maine |