Dim dic As New Dictionary(Of String,String)For Each dr As DataRow In DataTables("表B").Select("第一列 is not null") dic.Add(dr("第一列"), dr("第二列"))Next
Tables("表A").Cols("第一列").CodeDictionary = dic
http://www.foxtable.com/help/topics/2125.htm