The website I am working on is www.artinthepen.org.uk
I'm trying to create a catalog of artists for both of our 2018 events. I would like the page to have a dropdown box where the user can select either our Thirsk or Skipton event. The repeater should then populate with artists who are going to be at whichever event has been selected.
The problem I have is that I can't get my drop down box to connect. I have set my database up as per the image below and quickly added a few entries so I can test it. You can see that I have ticks next to which event the artist is exhibiting at. However, when I go to "Connect Dropdown" all the options are greyed out. I'm guessing that I can't use the tick boxes that I currently have and instead need to use text?
I would be very grateful is someone could tell me:
A) the correct way to set up my database to allow this
B) how to then get my dropdown working.
I'm guessing that once you select the option from the dropdown, the repeater automatically brings up the desired information. If this is wrong, please could someone correct me?
Last thing - the finished database will bring up either 120 or 190 entries depending on which event is picked. Can the repeaters be set up with an Infinity Scroll option, or a "Load More"? I'm hoping this can be done easily without code.
Any pointers would be massively appreciated!