Get Data from Nested relationship
I have a form called Attendance that has a lookup field called "Participant" from another form called Contacts. Contacts has a lookup field called "Sun Sign" from a form called Signs. The Signs form has a field called "Elements". This is a nested relationship.
My goal is to have a list of Participants and Elements for each record in attendance.
Right now using the "Related Fields" in the Column Properties, I can get to the "Sun Sign" field. This field is also a lookup field, but it doesn't have a "Related Fields" option.
Is there syntax to achieve this directly in Deluge? Or some other way of achieving this? If not, the only way I know to do this will be to duplicate a significant amount of data in the Contact form.