表格的自定义自动编号ID? [英] Customized Auto-Number IDs for tables?

问题描述

有没有办法像自动编号一样在表格中使用自己的编号；即自动将下一个可用记录分配给新记录.我们有我要绑定到该数据库的每个员工的系统ID号.我只希望表格自动分配下一个数字.

Is there a way to use my own number in a table like an auto-number; that is to automatically assign the next available to a new record. We have system ID numbers for each employee that I want to tie into this database. I just want the table to auto assign the next number.

我可以这样做吗?
可以将数字和字母混合使用吗?
是否可以使用准则，例如代码A =某些数字集，代码B =另一个数字集?

Can I do this?
Could this be done with a mixture of numeric and alpha?
Could criteria be used, like Code A = certain set of numbers, Code B = another?

推荐答案

您当然可以，但是您必须自己设计.

Of course you can, but you will have to design this yourself.

执行此操作的方法有数百种，但是一种方法可能是，您可以使用"nextQuote"，"nextEmployeeNo"，"nextJob"作为参数表...当然，您的表设计可以包含任何内容，包括前缀示例;

There are hundreds of ways of doing this but one way might be that you may have a parameters table with "nextQuote", "nextEmployeeNo", "nextJob"... of course your table design could have anything, including prefix example;

PARAMETERS
Prefix    Number
Q          1145
E            54
J           999

所以现在您可以SELECT PreFix + MAX(Number) AS NextEmployee FROM Parameters WHERE Prefix = E

在您的代码中，您可以在处理完该数字后增加它.

And in your code you can increment the number after dealing with it.

UPDATE Parameters SET Number = number + 1 WHERE Prefix = E 

如果这不能胜任工作，那么希望它会让您思考如何做类似的事情.

If this isn't up to the job then hopefully it will get you thinking in how you can do something similar.

希望这会有所帮助.

这篇关于表格的自定义自动编号ID?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！