带有数据输入选项的表字段 [英] Table field with data entry options

问题描述

我正在为我们的工程部门计划设计数据库。  每个项目在表格中都有自己的行。  我希望能够填充一个下拉字段，他们可以将这些字段放入有关计划的信息中。  有些项目
将有一个可能两个条目，而其他项目将有更多。  我为此创建了一个表单。  我不知道如何制作一个，附加到一个字段和两个，以使其具有每个作业的新记录。  这可能不是正确的方法。
 对此的任何帮助将不胜感激。

I am working on designing a database for our engineering department schedule.  Each project has its own line in the table.  I want to be able to populate a drop down field that they can put in information regarding plans.  Some projects would have one maybe two entries and others would have much more.  I created a form for this.  I do not know how to make it one, attach to a field and two, to make it have new records for each job.  This may not be the proper way to do this.  Any help on this would be greatly appreciated.

推荐答案

您需要为此创建相关表格方案，而不是一个单独的表。

You'd need to create related tables for such a scenario, not one single table.

所以你有一个项目表

项目

**** **************

ProjId

ProjName

ProjLeadId

。 ..

Projects
******************
ProjId
ProjName
ProjLeadId
...

然后创建一个Projects Jobs表

and then create a Projects Jobs table

Projects_Jobs

******************
$
ProjJobId

ProjId

JobName

JobStatusId

JobStartDate

JobEndDate

...

Projects_Jobs
******************
ProjJobId
ProjId
JobName
JobStatusId
JobStartDate
JobEndDate
...

然后你会有一个Projects表单，你可以在其中插入一个Job子表单（在连续模式下），以便你输入与Project相关的各种工作。

Then you'd have a Projects form in which you would insert a Job subform (in continuous mode) to allow you to enter the various jobs relating to the Project.

这篇关于带有数据输入选项的表字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！