有一张订单明细表,想要显示各个订单的生产车间,获取流转车间表的值,
Dim p As List(Of String)
Dim x As String = ""
p = DataTables("流转车间").GetValues("流转车间","工单号= '" & Tables("计划总表_订单明细").Current("工单号") & "'","_Sortkey")
For Each s As String In p
x = x + s + "→"
Next
Dim v As Boolean = (x <> "")
If v = False Then
x = "工序未设置!"
End If
Tables("计划总表_订单明细").Current("生产车间") = x.trim("→")
现在有个问题,有些订单的工序可能要某车间加工后去其他车间加工,再回转到该车间继续加工,就不能用GetValues了,请问改用什么方法?