Hi,

thanks to all who are reading and trying to help. I have a very complicated structure of tables and relation but it looks like:

res.partner -- o2m --> invoiceposition -- o2m --> invoiceversion -- m2m --> shortcodes <-- o2m -- res,partner

When I assign a shortcode to a invoiceversion, I only want to show those shortcodes, where :

res.partner.shortcode.partner_id = res.partner.invoicepositon.invoiceversion.partner_id

Below are my module and my xml file shortened to the essential parts. Would be awesome if someone could tell me how to alter them. Please keep in mind that this is my first openerp module, so a code example and where to put it exactly would be SUPER helpful.

class sh_partnerdetails(osv.osv):
    _name='res.partner'
    _inherit='res.partner'

    _columns = {
        [...]
        'invoiceposition': fields.one2many('sh.invoiceposition','company','Invoiceposition', help='Invoiceposition of this user.'),
        'shortcodes': fields.one2many('sh.shortcodes','shortcodecompany','Assigned Shortcodes', help='A list of assigned shortcodes.')
    }

class sh_invoiceposition(osv.osv):
    _name = 'sh.invoiceposition'

    _columns = {
        'company': fields.many2one('res.partner', 'Company', help="Belongs to which company / partner?", required=True),
        
        'comment': fields.char('Comment', size=120, help='Why did you update the billing details?', required=True),
        
        'invoicepositionversions': fields.one2many('sh.invoicepositionversions','isinvoicepositionversionof','Invoiceposition Version', help='A list of assigned invoiceposition versions.')
    }
    
sh_invoiceposition()

class sh_invoicepositionversions(osv.osv):
    _name = 'sh.invoicepositionversions'
    
    _columns = {
        'isinvoicepositionversionof': fields.many2one('sh.invoiceposition','Is invoicepositionversion of', help='This invoiceposition version Belongs to which invoiceposition?'),
        
        [...]
        
        'shortcodes': fields.many2many('sh.shortcodes', 'sh_invoicepositionversions_shortcodes_rel', 'operatorshowinvoicesetting_id', 'shortcode_id', 'Assign shortcode', help='A List of shortcodes assigned to this Version')
    }
sh_invoicepositionversions()

[...]

class sh_shortcodes(osv.osv):
    _name = 'sh.shortcodes'

    _columns = {
        'shortcodecompany': fields.many2one('res.partner','Is shortcode of which company', help='This shortcode number belongs to which company?', required=True),
        'isassignedinwhichoperatorinvoiceversion': fields.many2many('sh.invoicepositionversions', 'sh_invoicepositionversions_shortcodes_rel', 'shortcode_id', 'operatorshowinvoicesetting_id','Is used in which operatorinvoiceversion?', help='This shortcode is used in which operator invoice version?'),
        
        [...]
    }
    
    _sql_constraints = [
        ('uniq_number', 'unique(number)', "This shortcode number alraedy exists. A shortcode can only be assigned to one company")
    ]

sh_shortcodes()

my xml file looks like this:

<record id="sunhill_partnerdetails" model="ir.ui.view">
    <field name="name">res.partner.form</field>
    <field name="model">res.partner</field>
    <field name="type">form</field>
    <field name="inherit_id" ref="base.view_partner_form" />
    <field name="arch" type="xml">
        <notebook position="inside">
            <page string="Billing Details" attrs="{'invisible': [('is_company','=',False),('parent_id','!=',False)]}">
                [...]
                <separator string="Invoicepositions" colspan="4"/>
                <field name="invoiceposition" widget="one2many_list" nolabel="1" class="oe_inline oe_no_button" context="{'default_company': active_id}">
                    <tree string="invoiceposition">
                        <field name="comment"/>
                    </tree>
                </field>
                
                <separator string="Shortcodes" colspan="4"/>
                <field name="shortcodes" widget="one2many_list" nolabel="1" class="oe_inline oe_no_button" context="{'default_shortcodecompany': active_id}">
                    <tree string="shortcodes">
                        <field name="number"/>
                        <field name="description" />
                    </tree>
                </field>
            </page>
        </notebook>
    </field>
</record>

 

<!-- Start invoiceposition-->
<record model="ir.ui.view" id="invoiceposition_form">
    <field name="name">invoiceposition</field>
    <field name="model">sh.invoiceposition</field>
    <field name="type">form</field>
    <field name="arch" type="xml">
        <form string="invoiceposition">
            <field name="company" domain="[('is_company', '=', True)]"/>
            <field name="comment"/>
            <separator string="Invoiceposition Versions:" colspan="4"/>
            <field name="invoicepositionversions" colspan="4" widget="one2many_list" nolabel="1" context="{'default_isinvoicepositionversionof': active_id}">
                <tree string="invoiceposition Version">
                    [...]
                </tree>
            </field>
        </form>
    </field>
</record>

<record model="ir.ui.view" id="invoiceposition_tree">
    <field name="name">invoiceposition</field>
    <field name="model">sh.invoiceposition</field>
    <field name="type">tree</field>
    <field name="arch" type="xml">
        <tree string="invoiceposition">
            <field name="company" domain="[('is_company', '=', True)]"/>
            [...]
        </tree>
    </field>
</record>

<record model="ir.actions.act_window" id="action_invoiceposition">
    <field name="name">invoiceposition</field>
    <field name="res_model">sh.invoiceposition</field>
    <field name="view_type">form</field>
    <field name="view_mode">tree,form</field>
</record>
<!-- End-->

<!-- Start invoicepositionversions-->
<record model="ir.ui.view" id="invoicepositionversions_form">
    <field name="name">invoiceposition Versions</field>
    <field name="model">sh.invoicepositionversions</field>
    <field name="type">form</field>
    <field name="arch" type="xml">
        <form string="invoiceposition Versions">
            [...]
            <separator string="Assigned Shortcodes:" colspan="4"/>
            <field name="shortcodes" colspan="4" widget="many2many_list" nolabel="1" context="{'isassignedinwhichoperatorinvoiceversion': active_id}">
                <tree string="Assigned Shortcodes">
                    [...]
                </tree>
            </field>
        </form>
    </field>
</record>

<record model="ir.ui.view" id="invoicepositionversions_tree">
    <field name="name">invoiceposition Versions</field>
    <field name="model">sh.invoicepositionversions</field>
    <field name="type">tree</field>
    <field name="arch" type="xml">
        <tree string="invoiceposition Versions">
            [...]
        </tree>
    </field>
</record>

<record model="ir.actions.act_window" id="action_invoicepositionversions">
    <field name="name">invoiceposition Versions</field>
    <field name="res_model">sh.invoicepositionversions</field>
    <field name="view_type">form</field>
    <field name="view_mode">tree,form</field>
</record>
<!-- End-->

<!-- Start Shortcodes -->
<record model="ir.ui.view" id="shortcodes_form">
    <field name="name">Shortcodes</field>
    <field name="model">sh.shortcodes</field>
    <field name="type">form</field>
    <field name="arch" type="xml">
        <form string="Shortcodes">
            [...]
            <field name="shortcodecompany" domain="[('is_company', '=', True)]"/>
        </form>
    </field>
</record>

<record model="ir.ui.view" id="shortcodes_tree">
    <field name="name">Shortcodes</field>
    <field name="model">sh.shortcodes</field>
    <field name="type">tree</field>
    <field name="arch" type="xml">
        <tree string="Shortcodes">
            <field name="shortcodecompany" domain="[('is_company', '=', True)]"/>
            [...]
        </tree>
    </field>
</record>

<record model="ir.actions.act_window" id="action_shortcodes">
    <field name="name">Shortcodes</field>
    <field name="res_model">sh.shortcodes</field>
    <field name="view_type">form</field>
    <field name="view_mode">tree,form</field>
</record>
<!-- End-->

Thanks alot!