Hi, Im quite new to this and really just putting together a site for donations as a learning exercise.
I have 1 collection called “pleas” and 1 collection called “donators”.
I have my data set up and populating the pleas and donators tables.
Now I want to link the donator data to the pleas table without the user having to select anything.
My set up is as follows:
Page 1 - normal data entry page
Page 2 - dynamic page with repeater showing all the requests
Page 3 - dynamic page showing single requests, contains a donate button
Page 4 - dynamic page showing read only data for requests and data entry for donations
It is at this point I need to link the donation to the specific request in my collection.
I tried setting up a dropdown which I intended to have hidden on form
Using the above method only displays the pleas as a list.
If I try and force the dropdown to update the reference field I created I get this:
Which shows me all possible options in the preview.
Can anyone point me in the direction of how best to connect these two, as I’d ideally like the user to just submit their name and donation amount and it link directly to the other table.
Thanks in advance 
I’m doing this all in sandbox at the moment so any help would be greatly appreciated, even some videos or links would be help, Ive spent a few days trying to work it out.