To start with, please take a look at the following video where I show what I’m having difficulty with: https://www.useloom.com/share/e2bda185e5ba48b28517e877a888aec1
As shown in the video, I have three collections
- A Course Collection
- A Lesson Collection.
- An Authors Collection
The relationship between these three collections is as follows:
- Each course is made up of multiple lessons.
- Each course has at least one author (but can have multiple authors).
- Each author can be the author of multiple courses.
- A lesson does NOT have an author – the course has the author
Right now I’m trying to build the Lessons Page. I want to reference on that page both the course that the lesson is part of as well as the author of that course.
Referencing the course is not difficult – since I can directly link the lesson and course collections. But referencing the author of the course is not simple, since I have a separate authors collection which I reference from the Course Collection via a reference field.
Since the Authors field on the Course Collection is a reference to yet another Collection, I cannot reference it from within the Lessons Collection.
I could, theoretically, create a text field in the Course Collection and manually add in the authors name - and then I’d be able to reference the author’s name. But then I lose the capability of creating an authors page which details biographical info on the author as well as all his or her courses (which is something I want to do).
As such, I am stuck.
How can I reference the author of the course from the Lessons Page (while still being able to create an authors page)?
Here is my public share link