Skip to Content
This question has been flagged
linking-tables
2 Replies
5338 Views
Avatar
Sam Gray

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.

Avatar
Discard
Avatar
Chris TRINGHAM
Best Answer

It's done with one2many, many2one, many2many and related fields

For example, adding a many2one field creates a link.

If you drag the many2one icon on to the Form View, Odoo will display a list of all models (database tables). The model you select will be linked to the current model (as a parent).

You can enter a few characters to search for the Model

Then click on the correct Model.

 

More information: https://odootricks.tips/relational-fields-odoo-studio/

Avatar
Discard
Sam Gray
Author

Hi Chris,

Thank you for your reply. This isn't the part I'm trying to figure out- in your example, let's say I choose Canada as the "Country of Origin" for 25 Inventory Items, what I would then like to be able to do is go, to the "Country of Origin" table itself, select "Canada" and see a list of the Inventory Items where Canada was specified as the Country of Origin.

Another example- lets say I have a device inventory table and a vendor table, both of which have a number of fields themselves. For each inventory item, I specify the vendor of the item. I would then like to go to my Vendor table and select, let's say, "Dell" and see all the items in my inventory table with Dell specified as vendor.

Chris TRINGHAM

You can add a one2many on the Country table to see all the products. Same for Vendors. These are usually shown in tabs or as "smart buttons".

https://odootricks.tips/odoo-studio-adding-a-one2many-field/

Sam Gray
Author

Welp that worked. I thought I had tried the one2many field before, but apparently not.

Thanks for your help.

Sam Gray
Author

Ok. Another quick question- for the one2many field- is there a way to set the number of rows it displays for paginating within the one2many field. Right now, it's showing 40 records, I'd just like to show 10 or 25 at a time, or at the very least make the field vertically shorter.

Chris TRINGHAM

I believe it's possible to do this in the XML:

<tree limit="25">

Sam Gray
Author

I'm still pretty new. Where would I insert the XML snippet?