基于其他值的自动增量编号 [英] Auto increment number based off of other values
问题描述
我已经阅读了很多文章和论坛，试图找到这个并且还没有找到我可以开始工作的解决方案。我需要创建一个唯一的ID。我可以使用Dmax找到最大值并添加1.问题是我需要基于其他两个字段的值的唯一ID。因此，在数百条记录的表格中，我只想查看某些值以获取下一个可用数字。例如，如果我有一个订单表，并希望订单号基于客户名称和产品类型是唯一的。
因此，如果Dmax如下所示：
DMax（表达式，域名，[条件]
我有多个标准，这是如何工作的？
我有一个表格，我首先让他们选择客户端然后选择产品，然后想要弹出下一个可用的订单号。
I''ve read a lot of articles and forums trying to figure this one and have yet to come up with a solution I can get to work. I need to create a unique id. I can do this using Dmax to find the largest value and add 1. The problem is that I need the unique ID to be based on the value of two other fields. So, in table of hundreds of records I want to look at only certain values to obtain the next available number. For example, if I have a table of orders and want the order number to be unique based off the client name and the product type.
So if Dmax is stated like this:
DMax ( expression, domain, [criteria]
and I have multiple criteria, how does that work??
I have a form where I would first have them select the client and then the product and then want the next available order number to pop up.
推荐答案
" Criteria1 AND Criteria2"
"Criteria1 AND Criteria2"
这篇关于基于其他值的自动增量编号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
