I am new to databases and have little or no coding knowledge but I am hoping someone can help. I have two collections. Collection one collects information input from members via a text input element and five other populated drop down boxes. I have then set up an output page to display the inout results.
Collection two contains an image and description for eleven individual items.
I have created a reference field in Collection 1 referring to the corresponding field in Collection 2. I have also created Reference field referring to the Drop Down member section field from Collection 1.
In the Output form I want to display the Image and Description from Collection 2 that corresponds to the Member selection of the corresponding field in Collection.
I cant get it to work, I have read numerous articles but have almost admitted defeat.
I would really welcome any help and I am sure that what I am trying to achieve is quite possible.
Thank you in advance for your replies. All the best Russell