I'm an experienced SQL guy and I've just started tinkering with Odoo, so this is a general question. In Studio, how can do I link records across two tables. Typically, in SQL you would create a linking table of sorts. So for instances lets say that Table A is "Fruit" and Table B is "Color", for each fruit in Table A I specify a color from Table B, for example if I create Apple, Strawberry, and Tomato in Table A and specify they are Red- that's easy, but now I want to go to my Colors and click on "Red" and see which fruits are "Red", does that make sense? Anyhow, if someone could point me in the right direction on this, I'd be grateful.
Thanks.
