Skip to Content
This question has been flagged
dynamictables
2 Replies
2886 Zobrazenia
Avatar
Praveen Lobo

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
Zrušiť
Avatar
Amr Abd-Alkrim (FireBits)
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
Zrušiť
Praveen Lobo
Autor

Hi Amr,

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

Praveen Lobo
Autor

Hi Amr,

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

Amr Abd-Alkrim (FireBits)

@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

Avatar
Praveen Lobo
Autor Best Answer

A

Avatar
Zrušiť
Related Posts Replies Zobrazenia Aktivita
Table Names
tables naming
Avatar
Avatar
2
jún 24
1706
use dynamic value in domain
domain dynamic
Avatar
Avatar
Avatar
2
máj 24
7807
List of Tables of Odoo in Postgres Database
database tables
Avatar
Avatar
Avatar
Avatar
3
feb 23
16332
Access values of dynamic rows not yet in database
dynamic v14
Avatar
0
máj 22
2100
how can i add a dynamic picture in jasper report??
jasper_reports dynamic
Avatar
Avatar
Avatar
Avatar
4
apr 18
17755