I have a repeater and a dropdown connected to the same database. The repeater shows one item from the database. I would like to have the dropdown be able to select a specific item from the database and have it shown in the repeater. Right now the dropdown is connected to the database and is populated with what I want.
Next, I need to figure out a way to have the repeater change items being displayed when the user selects different items from the dropdown. I’ve looked at so many articles/videos and have not found what I need. Anyone know what to do?
How are the repeater and dropdown “connected” to the database? Are you using a Dataset ? If you have one dataset for your dropdown, and another for your repeater, you can set the Repeater’s dataset filter based on the dropdown’s dataset.
Another way would be to set the Repeater’s data property in the Dropdown’s onChange() function .
They are connected through one dataset right now. Are there any examples of this?
@brettfranklin2 You can try one of the techniques that I mentioned. Refer to the documentation on Repeaters , Dropdowns , and Datasets for more details.
Does this have anything to do with filtering or completely different?
@brettfranklin2 Yep - filtering.
@yisrael-wix When I tried filtering earlier it would cause the repeater and dropdown to go blank after I selected an item.
@brettfranklin2 Probably because you are only using one dataset and the filtering creates a conflict.
Using two datasets (one for the dropdown and one for the Repeater) you should be able to work this out.
@yisrael-wix I‘m going to try that and I’ll let you know how it goes. Not that experienced with this, but I‘ll try it out.