Hi,
I am new to openerp , I have two table master and details , i want to use id of master as foreign key in detail table.
How can i achieve this?
my code is
from osv import osv,fields
class wlan_master(osv.osv):
    _name = 'wlan_master'
    _columns = {
        'AP_name'       :fields.char(),
        'description'   :fields.char(),
        'ip_address'    :fields.char(),
    }
class wlan_details(osv.osv):
    _name = 'wlan_details'
    _columns = {
        'wireless_workmode'     :fields.char(),
        'enable_wireless'       :fields.char(),
        'ssid'                  :fields.char(),
        'channel'               :fields.char(),
        'wireless_mode'         :fields.char(),
        'channel_bandwidth'     :fields.char(),
        'rate'                  :fields.char(),
        'broadcast_ssid'        :fields.char(),
        'client_isolation'      :fields.char(),
        'wmm_announcement'      :fields.char(),
        'fragement_threshold'   :fields.char(),
        'rts'                   :fields.char(),
        'dtim_gap'              :fields.char(),
        'beacon_gap'            :fields.char(),
        'preamble_type'         :fields.char(),
        'encryption_mode'       :fields.char(),
        'filter_mode'           :fields.char(),
    }
Odoo is the world's easiest all-in-one management software.
 It includes hundreds of business apps:
- 客户关系管理
- e-Commerce
- 会计
- 库存
- PoS
- Project
- MRP
此问题已终结
            
                2
                
                    回复
                
            
        
        
            
                9175
                
                    查看
                
            
        
    Basically you have to do two things:
from osv import osv,fields
class wlan_master(osv.osv):
    _name = 'wlan.master'
    _columns = {
        'AP_name'       :fields.char(),
        'description'   :fields.char(),
        'ip_address'    :fields.char(),
        'defail_ids': fields.one2many('wlan.details','master_id', 'Details')
    }
class wlan_details(osv.osv):
    _name = 'wlan.details'
    _columns = {
        'master_id': fields.many2one('wlan.master', 'Master'),
        'wireless_workmode'     :fields.char(),
        'enable_wireless'       :fields.char(),
        'ssid'                  :fields.char(),
        'channel'               :fields.char(),
        'wireless_mode'         :fields.char(),
        'channel_bandwidth'     :fields.char(),
        'rate'                  :fields.char(),
        'broadcast_ssid'        :fields.char(),
        'client_isolation'      :fields.char(),
        'wmm_announcement'      :fields.char(),
        'fragement_threshold'   :fields.char(),
        'rts'                   :fields.char(),
        'dtim_gap'              :fields.char(),
        'beacon_gap'            :fields.char(),
        'preamble_type'         :fields.char(),
        'encryption_mode'       :fields.char(),
        'filter_mode'           :fields.char(),
    }
This adds a foreign key to details and this make a proper link to master.
I think you haven't read documentation yet
class wlan_details(osv.osv):
    _name = 'wlan_details'
    _columns = {
       'master_id': fields.many2one('wlan_master',  'Master'),
       'wireless_workmode'     :fields.char(),
       etc...
| 相关帖文 | 回复 | 查看 | 活动 | |
|---|---|---|---|---|
|  | 0 2月 18  | 3815 | ||
|  | 1 12月 18  | 9762 | ||
|  | 2 8月 24  | 2394 | ||
|  | 3 9月 25  | 2123 | ||
|  | 1 4月 18  | 6665 | 
