Skip to Content
Menú
This question has been flagged
2 Respostes
2872 Vistes

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
Descartar
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
Descartar
Autor

Hi Amr,

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

Autor

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

Autor Best Answer

A

Avatar
Descartar
Related Posts Respostes Vistes Activitat
2
de juny 24
1703
2
de maig 24
7805
3
de febr. 23
16321
0
de maig 22
2094
4
d’abr. 18
17746