Skip to Content
Menu
You need to be registered to interact with the community.
This question has been flagged
2 Odgovori
2924 Prikazi

Hi,


We have created 2 tables. The first table has name as the column. User will fill this table. 

In the second table, I have I want to create a dropdown which takes the data source as all the names from the first table.


Is this possible?

Avatar
Opusti
Best Answer

Yes for that you will use the Many2one relation to link between 2 models in Odoo. Write In your_module/models/models.py.

    class YourFirstModel(models.Model):

       _name = "first.model"

        name =fields.Char()


    class YourSecondModel(models.Model):

       _name = "second.model"

        name = fields.Char()

        options = fields.Many2one("first.model")



 Read more about how to build a relation in Odoo Docs here.


Happy to help :) an upvote will be awesome

Avatar
Opusti
Avtor

Hi Amr,

Thanks for the quick response. Can we do this without saving the first table?

Avtor

Hi Amr,

Thanks for the quick response. Can we do this without saving the first table to database?

@Praveen Lobo

For all the dynamic drop down menus you have to build a table in the database thier is no other option and it's the best practice in odoo. For static menus you can use the Selection field

Avtor Best Answer

A

Avatar
Opusti
Related Posts Odgovori Prikazi Aktivnost
2
jun. 24
1771
2
maj 24
7869
3
feb. 23
16556
0
maj 22
2167
4
apr. 18
17781