=IF(ISERROR(ODATA("SubProject?$select=Sub_ID&$filter=Pro_ID eq "&IF(ISBLANK(F2),"null","'"&F2&"'"))),"0000",RIGHT(ODATA("SubProject?$select=Sub_ID&$filter=Pro_ID eq "&IF(ISBLANK(F2),"null","'"&F2&"'")&"&$top=1&$orderby=Sub_ID desc"),3))
麻烦帮忙看一下上面的子项编码规则,现在的问题是,子项编码新增到1000,就无法继续新增,新增的编码一直都是1000,要如何 让他继续1001的方式下去?
|