Listbox to show only beds with the same plot_id

[goedible]

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"

[fpy]

@goedible

attempt

upload an .odb sample here, it will be easier to spot the problem with your query, rather than wild-guessing over screenshots

→ This is the guide - more-details

[Gbp]

This thread might help

How to use user selected value from combobox1 in combobox2 'SELECT' statement

Edited 1/17/2017 - Additional sample at end of answer. Hello, First let me state the answer by @jimk is valid (+1). Filtering can be done with & without macros. I have posted 10 to 20 on this forum using many variations. There is also Filter/Search with Forms you may want to look at. With that said, here is what I see in your question. You do not really need combo boxes for new treatments. If it isn’t in the ‘treatment’ table it needs to be added there for a centralization of items. Nex…

[goedible]

I’ve made a couple changes to the layout… Here is a link to the .odb file
https://www.dropbox.com/scl/fo/h9kn7rdru9s7e20h1s1f8/AFQNeUMCKouLx093XxMdxfI?rlkey=31zcxffpml87tjqr3cils6vl3&st=zingyfq1&dl=0