Hello.
I have two tables
toys:
toyid
toyname
colorid
and
colors:
colorid
colorname
I have a form that displays toys:
toyid, toyname, colorid(colorname)
How can I create form that allows me to open form toys, that would display only toys of specific color?
Or add listbox on the toys form, that allows me to display only toys of specific colors in the toys form?
Note: If I add listbox to toys form, and link it on the colorid,
when i click on the listbox, (with row selected in the toy form), it changes value of the colorid of the selected row
in the toys form. I do not wish to do that.
Macros, or anything are ok.
Thanks
How does one add attachment?
I’ve upload simple odb file here: https://easyupload.io/ezken6