I have a database which is about shops in different cities and products they offer.
I have one column which is the “city” and then 6 different columns with products (product 1…product 6). If a shop offers the specific product the value of the field under the product is “yes”.
What I want is to have 2 dropdowns, one for city, and one for products, so users will select the product they want, then the city they want, and the list will show the shops in the specific city that offer the specific product.
Any ideas how to do it?
Take a look at the Cascading Form example. You can play around with the example in your editor and then adapt the code for your own use.