When I click the listbox, I want to only see the beds that are available for the selected plot relating to the selected plant
In the this example the selected plot “YOU” has only two beds. “” and “under cedar”
When I click the listbox I get all of the beds from every plot
This was my attempt:
SELECT DISTINCT "beds"."bed_name", "beds"."bed_id" FROM "plants", "beds" WHERE "plants"."bed_id" = "beds"."bed_id"