Skip to Content
Dette spørgsmål er blevet anmeldt
dynamictables
2 Besvarelser
2867 Visninger
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
Kassér
Avatar
Amr Abd-Alkrim (FireBits)
Bedste svar

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
Kassér
Praveen Lobo
Forfatter

Hi Amr,

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

Praveen Lobo
Forfatter

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
Forfatter Bedste svar

A

Avatar
Kassér
Related Posts Besvarelser Visninger Aktivitet
Table Names
tables naming
Avatar
Avatar
2
jun. 24
1702
use dynamic value in domain
domain dynamic
Avatar
Avatar
Avatar
2
maj 24
7803
List of Tables of Odoo in Postgres Database
database tables
Avatar
Avatar
Avatar
Avatar
3
feb. 23
16319
Access values of dynamic rows not yet in database
dynamic v14
Avatar
0
maj 22
2094
how can i add a dynamic picture in jasper report??
jasper_reports dynamic
Avatar
Avatar
Avatar
Avatar
4
apr. 18
17744