how to add reference fields using 3 collections

Ask the community
,
1

Hi everyone
I have 3 collections one is Showcast collection and another People & CastRoles collections.i am creating reference fields in showcast collection from those reference fields are one peoples collection in person id and CastRoles collection in Role id.
please give me any suggestions (or) send me if you have any examples.i hope i am getting a positive response form your’s.Thanks for your valuable time spending on above issue.
i)This is showcast collection creating reference fields.

1366×768 83.9 KB

ii) This is people collection

1366×768 83.9 KB

iii) This is Castroles collection

1366×768 72.8 KB

2

Hi,
You can learn how to reference multiple collections and display content from the here .

3

Hi
Thanks for your response.
Your sending the article only using two collections . but i have three collections.please check above screenshots on three collections.if you have any examples please send me.thank you.

4

Hi
How to create sub queries ?