基于其他值的自动增量编号

本文介绍了基于其他值的自动增量编号的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我已经阅读了很多文章和论坛，试图找到这个并且还没有找到我可以开始工作的解决方案。我需要创建一个唯一的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"

展开 | 选择 | Wrap | 行号

展开 | 选择 | Wrap | 行号