我有一个包含4个表的数据库：tblMembers，tblRides，Session table和Reservation table。 Members表中的一个字段设置为number，但是现在我已经设置了所有关系并插入了数据，但现在有一个问题是当我添加一个新用户时它没有增加..有什么办法吗？使用VBA，我可以从表中获取最后一个CustomerID并添加一个，并将其作为新ID插入？
我想抓住最后一个使用的CustomerID
I have a database with 4 tables: tblMembers, tblRides, Session table and Reservation table. One of the fields in the Members table is set to number, but now I have all relationships set up and the data inserted, but one problem is now that when I add a new user it doesn''t increment.. Is there any way with VBA, that I can grab the last CustomerID from the table and add one to it, and insert that as the new ID?
I was thinking to grab the last CustomerID of using
这篇关于自动递增数字字段（不是自动编号字段）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！