产品表有 “编号、客户、产品...“等数据
订单明细表有 ”客户、产品NO、订单号码....“等数据
在录订单资料的时候,想实现录入客户后,产品NO有动态的数据字典来选择
If MainTable.Name = "订单明细" Then
Dim dr As DataRow
Dim dmp As New TableDataMap
dmp.DataTable = "产品"
dmp.ValueCol = "NO"
dmp.DisplayCol = "NO"
dmp.ListCols = "NO,客户,物料编号,产品名称,颜色,单位,备注"
dmp.Sort = "物料编号"
dmp.Filter ="[状态] = True And [客户] = '" & e.Row("客户") & "'"
Tables("订单明细").Cols("产品NO").DataMap = dmp.CreateDataMap()
End If
提示条件公式错误,求帮助