I want a bed_name dropdown on the bed column of the plants table. It should show the current bed name and in the list it should show all the bed names of the selected plot so I can move a plant to a different bed by selecting the bedname in the dropdown list. I thought a view may be necessary to do this so I created one called view_beds_with_plot but I really don’t know. That’s why I’m asking.
from the selected plot.

here is the database you can download and mess with. https://www.dropbox.com/scl/fo/wmbtn6o89ixk7swpet0e3/AAPw9J4s8nf0k6qAbeGdAMQ?rlkey=y2klkwihjtbt8mx8234c4gtgr&st=cwtb801b&dl=0
I asked for help solving something like this a while ago but it was to complicated so I’ve started a new database to simplify. I don’t think I included a link to the other database but here is the past thread if you’re interested. Listbox to show only beds with the same plot_id