afterload代码
Tables("窗口客户_tblKehu").Fill("select top 100 customer_id as 客户序号,customer_name as 公司名称,customer_number as 编号,address as 地址,creator as 创建者,create_date as 创建日期,ditu_zuobiao as 坐标 ,x,y,zhengjian as 证件 from crm_customer order by customer_id desc","cc",False)
Tables("窗口客户_Tbl_lianxiren").Fill("select top linkman_id,customer_id,link_name,sex,phone_home,phone_office,phone_mobile,email,QQ,address,duty,creator from crm_customer_linkman","cc",False)
Tables("窗口客户_tblKehu")的CURRENT事件里
Tables("窗口客户_Tbl_lianxiren").Filter = "customer_id = " & Tables("窗口客户_tblKehu").Current("客户序号")
'
通过这个模拟关联表,在窗口动态加载
1\为什么一启动窗口就提示 未找到列 [customer_id]。
2\这个方式是不是把子表都的数据都加入到了系统里,可以有别的方式不加入吗
[此贴子已经被作者于2013-9-5 20:32:15编辑过]