This question has been flagged
2 Replies
1096 Views

Our product DB is a list of comics. We made a custom model for the publishers of these comics. A custom field in the product detail view has been made to add (or create) a publisher to a comic. When created in the product detail view, the new publisher correctly appears in the publishers' list (for which we created an extra menu). However, we are able to delete entries (or values) in this list, even when they are in use in a product. How can we avoid deleting values from this model when they are in use by a (or more) product?

Avatar
Discard
Best Answer

You have used the Many2one field to link the product with publisher so you can add the below attribute to that field

ondelete='restrict'

For example:

publisher_id = fields.Many2one('publisher', required=True, ondelete="restrict")    

Reference:

ORM API — Odoo 15.0 documentation

Avatar
Discard
Author Best Answer

Thnx.
I'm fairly new to Odoo. I created this model from the backend (Odoo 15 enterprise). Where would I have to write this line of code (or similar)?

Avatar
Discard