创建将用作主键的参考号 [英] Creating a Reference number that will serve as primary key

问题描述

亲爱的，


回到我的项目数据库（如果你已经阅读了我之前的线程请求^^）。


我有一个项目数据库。


我将添加一个用于添加新项目的编辑表单。


我想在添加时添加一个新项目;为此创建了一个引用。此引用将用作主键。


我希望引用看起来像这样：


[帐号] / [当前年份] / Proj [本年度已为此帐号创建的项目数量+ 1]


这可能吗？如果是，怎么样？


非常感谢你的帮助。


祝你好运，


G.

解决方案

如果您希望我们引用另一个主题，您需要在此主题中发布指向该主题的链接。

否则这不是很容易上手和运行。

你好NeoPa，


谢谢你的回答。实际上我特别提到没有线程，但我想这可能有助于理解：

将连续子表单链接到表单的按钮（均围绕多个表格构建）


我的表格都列在那里。
< br $>
祝你好运，


G。

Gari，

这是一个不错的选择一个选择:)

作为阅读这篇文章的人的助手，我会发布其他帖子的布局信息：

我的表格如下：

展开 | 选择 | Wrap | 行号

Dear All,

Back to my project database (if you have read my previous thread requests ^^).

I have a project database.

I will add an edit form that will be used to add new projects.

I would like that when adding a new project; a reference is created for this one. This reference will be used as primary key.

I want the reference to look like this:

[Account Number]/[Current Year]/Proj[Numbers of projects already created for this Account Number during this Current Year + 1]

Is this possible? If yes, how?

Thank you very much for your help.

Best regards,

G.

解决方案

If you want us to refer to another thread you will need to post a link to that one in this one.
Otherwise this isn''t very easy to pick up and run with.

Hello NeoPa,

Thank you for your answer. Actually I was refering to no threads in particular but I guess this one might help to understand:

Button linking a continuous sub-form to a form (both built around several tables)

My tables are all listed in there.

Best regards,

G.

Gari,
That''s a good one to pick :)
Just as an aide to anyone reading this post, I''ll post the layout information from the other thread :

My tables are as follows:

Expand|Select|Wrap|Line Numbers

这篇关于创建将用作主键的参考号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！