专家坐堂-[求助]SQLCrossTableBuilder的关联方式Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

g.AddTable("D_Stock","SKUCode","B_SKU","SKUCode")

g.AddTable("D_Stock","PartyCode","B_Party","PartyCode")

g.AddTable("B_SKU","ProductColorCode","View_ProductKS","款色")

Dim Cols1() As String = {"PartyCode","SKUCode"}

Dim Cols2() As String = {"PartyCode","SKUCode"}

g.AddTable("D_Stock",Cols1,"D_SaleBillItem",Cols2)

g.HGroups.AddDef("{D_Stock}.PartyCode","仓库对象","仓库对象")

g.HGroups.AddDef("ProductColorCode","款色")

g.HGroups.AddDef("InsideLengthCode","内长")

g.HGroups.AddDef("销售分类")

g.HGroups.AddDef("YearCode","年份")

g.HGroups.AddDef("SeasonCode","季节")

g.HGroups.AddDef("SeasonStageCode","波段")

g.VGroups.AddDef("SizeCode","尺码")

g.Totals.AddDef("TargetQty", "目标库存")

g.Totals.AddDef("SaleBillQty", "累计销量")

g.HorizontalTotal= True

g.OrderByTotal = True