需要形式布局的想法 [英] Need Ideas For Layout Of Form

问题描述

我正在寻找一些关于如何为

数据输入设计表单布局的想法，并显示以下情况的数据：

有很多销售人员。销售助理可以为多家公司工作，并为每家公司的多个部门工作。在每个

部门内，他可以在多个部门工作，在每个部门内，他可以与多个团队一起工作。在每个小组中，他负责多个项目。

每个销售人员的所有工作区域需要以

的形式输入并以表格形式显示 - 公司，部门，部门，团体和

项目。公司和部门之间存在一对多关系，

部门和部门，部门和团队以及团队和项目。


感谢您的帮助，


Tom

I am looking for some ideas for how to design the layout of the form for
data entry and to display the data for the following situation:
There are many sales associates. A sales associate can work for multiple
companies and work for multiple divisions within each company. Within each
division he can work in multiple departments and within each department he
can work with multiple groups. In each group he works on multiple projects.
All the work areas of each sales associates needs to be input in the form
and displayed in the form - Companies, Divisions, Departments, Groups and
Projects.There are one-to-many relationships between company and division,
division and dpartment, department and group and group and project.

Thanks for all help,

Tom

推荐答案

Tom，问题不在于表格，而是关于正确获得

数据结构。


以我的思维方式，公司，部门，而且部门实际上是同一类实体的层，而项目是另一种实体.b
实体。一个项目可能会在不同的部门之间共享或者b
部门，并且可能有一个开始和结束日期，而一个部门

将是一个（通常）永久部分只有一个划分等等

树。


如果是这样，你可以考虑制作一个客户。表格你可以在哪里
存储所有第一类实体。它将具有ClientID字段作为主要的

键，以及一个ParentID字段，用于指示此

客户端的直接父级。因此，如果客户指的是是一个除法类型，它的ParentID将是作为公司的记录的

ClientID。


然后，您将拥有另一个项目表，以及工作人员表。

另一个表可能有字段：

ClientID：Client.ClientID的外键（所以可以是co，dept，div，

....）

ProjectID：Project.ProjectID的外键

StaffID：Staff.StaffID的外键

WorkDate ：工作完成日期。

每条记录都是这样的：8月1日（工作日期），Joe Smith

（工作人员）为IT部门工作（客户） ）项目49（无论是什么

是。）


如果这样可以满足您的需求，那么您将拥有一个包含3个组合的表格
和日期的文本框。可能是，这不是你需要的，

但希望它会让你思考一个有用的方向。


-

Allen Browne - 微软MVP。西澳大利亚州珀斯。

访问用户提示 - http：// allenbrowne.com/tips.html

回复群组，而不是mvps dot org的allenbrowne。


" Tom" <无*** @ email.com>在消息中写道

新闻：rY **************** @ newsread1.news.atl.earthli nk.net ...

Tom, the question is not so much about the form, as it is about getting the
data structure right.

To my way of thinking, companies, divisions, and departments are actually
layers of the same kind of entity, whereas projects are a different kind of
entity. A project might be shared amongst different departments or
divisions, and could have a starting and ending date, whereas a department
would be a (normally) permanent section of just one division and so forth up
the tree.

If that is so, you might consider making a "Client" table where you can
store all the first kind of entity. It will have a ClientID field as primary
key, and a ParentID field that indicates the immediate parent of this
client. So, if the "client" is a division type, its ParentID would be the
ClientID of a record that is a company.

You would then have another table for Projects, and a table for Staff.
Another table might then have fields:
ClientID: foreign key to Client.ClientID (so can be a co, dept, div,
....)
ProjectID: foreign key to Project.ProjectID
StaffID: foreign key to Staff.StaffID
WorkDate: date the work was done.
Each record says something like this: on August 1 (work date), Joe Smith
(staff) worked for the IT Department (client) on project 49 (whatever that
is.)

If that copes with what you need, you would then have a form with 3 combos
and a text box for the date. Chances are, that''s not exactly what you need,
but hopefully it gets you thinking in a useful direction.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Tom" <no***@email.com> wrote in message
news:rY****************@newsread1.news.atl.earthli nk.net...

我正在寻找一些关于如何设计表格布局以进行数据输入以及显示以下情况的数据的想法：
有许多销售人员。销售助理可以为多家公司工作，并为每家公司内的多个部门工作。在每个部门内，他可以在多个部门工作，在每个部门内，他可以与多个团队合作。在每个小组中，他都参与多个项目。每个销售人员的所有工作区域都需要在表格中输入并以表格形式显示 - 公司，部门，部门，组和项目。公司之间存在一对多的关系<分区，部门和部门，部门，团体和团队以及
项目。

感谢您的帮助，汤姆

I am looking for some ideas for how to design the layout of the form for
data entry and to display the data for the following situation:
There are many sales associates. A sales associate can work for multiple
companies and work for multiple divisions within each company. Within each
division he can work in multiple departments and within each department he
can work with multiple groups. In each group he works on multiple
projects. All the work areas of each sales associates needs to be input in
the form and displayed in the form - Companies, Divisions, Departments,
Groups and Projects.There are one-to-many relationships between company
and division, division and dpartment, department and group and group and
project.

Thanks for all help,

Tom

Tom，问题不在于表单，而在于正确获取

数据结构。

以我的思维方式，公司，部门和部门实际上是同一类实体的层，而项目是另一种类型的

实体。一个项目可能会在不同的部门之间共享或者b
部门，并且可能有一个开始和结束日期，而一个部门

将是一个（通常）永久部分只有一个划分等等

树。


如果是这样，你可以考虑制作一个客户。表格你可以在哪里
存储所有第一类实体。它将具有ClientID字段作为主要的

键，以及一个ParentID字段，用于指示此

客户端的直接父级。因此，如果客户指的是是一个除法类型，它的ParentID将是作为公司的记录的

ClientID。


然后，您将拥有另一个项目表，以及工作人员表。

另一个表可能有字段：

ClientID：Client.ClientID的外键（所以可以是co，dept，div，

....）

ProjectID：Project.ProjectID的外键

StaffID：Staff.StaffID的外键

WorkDate ：工作完成日期。

每条记录都是这样的：8月1日（工作日期），Joe Smith

（工作人员）为IT部门工作（客户） ）项目49（无论是什么

是。）


如果这样可以满足您的需求，那么您将拥有一个包含3个组合的表格
和日期的文本框。可能是，这不是你需要的，

但希望它会让你思考一个有用的方向。


-

Allen Browne - 微软MVP。西澳大利亚州珀斯。

访问用户提示 - http：// allenbrowne.com/tips.html

回复群组，而不是mvps dot org的allenbrowne。


" Tom" <无*** @ email.com>在消息中写道

新闻：rY **************** @ newsread1.news.atl.earthli nk.net ...

Tom, the question is not so much about the form, as it is about getting the
data structure right.

To my way of thinking, companies, divisions, and departments are actually
layers of the same kind of entity, whereas projects are a different kind of
entity. A project might be shared amongst different departments or
divisions, and could have a starting and ending date, whereas a department
would be a (normally) permanent section of just one division and so forth up
the tree.

If that is so, you might consider making a "Client" table where you can
store all the first kind of entity. It will have a ClientID field as primary
key, and a ParentID field that indicates the immediate parent of this
client. So, if the "client" is a division type, its ParentID would be the
ClientID of a record that is a company.

You would then have another table for Projects, and a table for Staff.
Another table might then have fields:
ClientID: foreign key to Client.ClientID (so can be a co, dept, div,
....)
ProjectID: foreign key to Project.ProjectID
StaffID: foreign key to Staff.StaffID
WorkDate: date the work was done.
Each record says something like this: on August 1 (work date), Joe Smith
(staff) worked for the IT Department (client) on project 49 (whatever that
is.)

If that copes with what you need, you would then have a form with 3 combos
and a text box for the date. Chances are, that''s not exactly what you need,
but hopefully it gets you thinking in a useful direction.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Tom" <no***@email.com> wrote in message
news:rY****************@newsread1.news.atl.earthli nk.net...

我正在寻找一些关于如何设计表格布局以进行数据输入以及显示以下情况的数据的想法：
有许多销售人员。销售助理可以为多家公司工作，并为每家公司内的多个部门工作。在每个部门内，他可以在多个部门工作，在每个部门内，他可以与多个团队合作。在每个小组中，他都参与多个项目。每个销售人员的所有工作区域都需要在表格中输入并以表格形式显示 - 公司，部门，部门，组和项目。公司之间存在一对多的关系<分区，部门和部门，部门，团体和团队以及
项目。

感谢您的帮助，汤姆

I am looking for some ideas for how to design the layout of the form for
data entry and to display the data for the following situation:
There are many sales associates. A sales associate can work for multiple
companies and work for multiple divisions within each company. Within each
division he can work in multiple departments and within each department he
can work with multiple groups. In each group he works on multiple
projects. All the work areas of each sales associates needs to be input in
the form and displayed in the form - Companies, Divisions, Departments,
Groups and Projects.There are one-to-many relationships between company
and division, division and dpartment, department and group and group and
project.

Thanks for all help,

Tom

Allen，


感谢您的回复！


我需要记录说：

8月1日（工作日期），Joe Smith在IT部门（部门）的IT部门（部门）工作了（工作组）

公司

（公司）项目49（项目）。


8月1日（工作日期），Joe Smith在炼油集团（集团）工作

建筑部工程部（部门）
IT公司（公司）项目27（项目）的b $ b（部门）。


8月1日（工作日期），Joe Smith在IT公司XYZ部门（部门）的销售部门（部门）工作营销组（小组）

（公司）项目84（项目）。


我需要一份表格，为8月1日的Joe Smith输入这些记录。


谢谢，


Tom

" Allen Browne" <铝********* @ SeeSig.Invalid>在消息中写道

news：42 *********************** @ per-qv1-newsreader-01.iinet.net。 au ...

Allen,

Thanks for the response!

I need records to say:
On August 1 (work date), Joe Smith worked for the Industrial Group (group)
of the IT Department (department) of the ABC Division (division) of IT Inc.
(company) on project 49 (project).

On August 1 (work date), Joe Smith worked for the Refining Group (group) of
the Engineering Department (department) of the Construction Division
(division) of IT Inc. (company) on project 27 (project).

On August 1 (work date), Joe Smith worked for the Marketing Group (group) of
the Sales Department (department) of the XYZ Division (division) of IT Inc.
(company) on project 84 (project).

I need a form to enter these records for Joe Smith for August 1.

Thanks,

Tom
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:42***********************@per-qv1-newsreader-01.iinet.net.au...

Tom，问题不在于表单，而在于确保数据结构正确。

以我的方式思考，公司，部门和部门实际上是同一类实体的层次，而项目是不同类型的实体。一个项目可能在不同的部门或部门之间共享，并且可能有一个开始和结束日期，而一个部门
将是一个（通常）永久性部分，只有一个部门等等
在树上。

如果是这样，你可以考虑制作一个客户。表格，您可以存储所有第一类实体。它将具有ClientID字段作为主键，以及一个ParentID字段，用于指示此客户端的直接父级。因此，如果客户指的是是一个除法类型，它的ParentID将是一个公司记录的ClientID。

然后你会有另一个项目表和一个员工表。
另一个表可能有字段：
ClientID：Client.ClientID的外键（因此可以是co，dept，
div，...）
ProjectID：Project.ProjectID的外键
StaffID：Staff.StaffID的外键
WorkDate：工作完成日期。
每条记录都说明如下：8月1日（工作日期），Joe Smith
（工作人员）为项目49的IT部门（客户）工作（无论是什么。）

如果能够满足您的需求，那么您将获得一个包含3个组合的表格。 />和日期的文本框。很可能，这并不是你所需要的，但希望它会让你思考一个有用的方向。

-
Allen Browne - 微软MVP。西澳大利亚州珀斯。
访问用户提示 - http://allenbrowne.com/ tips.html
回复群组，而不是mvps dot org的allenbrowne。

汤姆 <无*** @ email.com>在消息中写道
新闻：rY **************** @ newsread1.news.atl.earthli nk.net ...

Tom, the question is not so much about the form, as it is about getting
the data structure right.

To my way of thinking, companies, divisions, and departments are actually
layers of the same kind of entity, whereas projects are a different kind
of entity. A project might be shared amongst different departments or
divisions, and could have a starting and ending date, whereas a department
would be a (normally) permanent section of just one division and so forth
up the tree.

If that is so, you might consider making a "Client" table where you can
store all the first kind of entity. It will have a ClientID field as
primary key, and a ParentID field that indicates the immediate parent of
this client. So, if the "client" is a division type, its ParentID would be
the ClientID of a record that is a company.

You would then have another table for Projects, and a table for Staff.
Another table might then have fields:
ClientID: foreign key to Client.ClientID (so can be a co, dept,
div, ...)
ProjectID: foreign key to Project.ProjectID
StaffID: foreign key to Staff.StaffID
WorkDate: date the work was done.
Each record says something like this: on August 1 (work date), Joe Smith
(staff) worked for the IT Department (client) on project 49 (whatever that
is.)

If that copes with what you need, you would then have a form with 3 combos
and a text box for the date. Chances are, that''s not exactly what you
need, but hopefully it gets you thinking in a useful direction.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Tom" <no***@email.com> wrote in message
news:rY****************@newsread1.news.atl.earthli nk.net...

我是寻找一些关于如何设计表格布局以进行数据输入以及显示以下情况的数据的想法：
有许多销售人员。销售助理可以为多家公司工作，并为每家公司内的多个部门工作。在每个部门内，他可以在多个部门工作，在每个部门内，他可以与多个团队合作。在每个小组中，他都参与多个项目。每个销售人员的所有工作区域都需要以表格形式输入并以表格形式显示 - 公司，部门，部门，团体和项目。有一对多的关系公司与部门，部门和部门，部门和团队以及团队和项目之间。

感谢您的帮助，

Tom

I am looking for some ideas for how to design the layout of the form for
data entry and to display the data for the following situation:
There are many sales associates. A sales associate can work for multiple
companies and work for multiple divisions within each company. Within
each division he can work in multiple departments and within each
department he can work with multiple groups. In each group he works on
multiple projects. All the work areas of each sales associates needs to
be input in the form and displayed in the form - Companies, Divisions,
Departments, Groups and Projects.There are one-to-many relationships
between company and division, division and dpartment, department and
group and group and project.

Thanks for all help,

Tom

这篇关于需要形式布局的想法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！