hi all,

I have a model (child) which contains a field named 'mparent', it stores 'name' field values ​​from its parent

have another Many2one field which point to itself to select records from

I have to filter this Many2one field with values ​​are in 'mparent', so the only related data will be present to user to select one

i did something like below but it shows error at runtime (here Household is the value mparent field contains): ValueError: Invalid domain term ('mparent', 'in', 'Household') 

in my mdel:

    sparent = fields.Many2one ('mymodel.subcat', string = "Sel Parent", domain = "[('mparent', 'in', mparent)]")

please help, how to do this?

looks