表格有230个字段....什么是更好的选择？ [英] Table with 230 Fields....what's a better alternative?
问题描述
我正在建立一个数据库来记录员工收到的培训。
对于每个培训练习，他们都会收到1到3之间的分数。
最初，当没有那么多培训元素时，我已经把
员工的名字，姓氏，部分，急救，叉车
操作。 ..等等在一张桌子上。但是，我现在有一个227
的培训元素列表需要完成（每个都收到一个标记
在1到3之间）。当我试图将它们全部放在一张桌子上时，它说
有太多的字段。
然后我将它们分成两个表并尝试根据名字和姓氏加入
查询。这产生了我需要的所有字段，但没有显示我在表格设置中指定的所有组合框（大多数，但不是全部）组合框，值列表，1，2，3。
现在我想我需要将它们分解为多个较小的
表，并通过主表单上的多个子表单显示字段。
我想知道人们是否有更好的解决方案。实际上，我很确定
肯定有人这样做。甚至不确定我将它们进一步拆分的想法将会工作，但它是我现在能想到的最好的......
谢谢你的支持帮助，
Reg
I''m making a database to record training that employees have recieved.
For each training excercise, they recieve a mark between 1 and 3.
Initially, when there weren''t so many training elements, I had put the
employee first name, last name, section, First Aid, Forklift
operation... and so on in one table. However, I now have a list of 227
Training elements that need to be completed (each recieving a mark
between 1 and 3). When I tried to put them all in one table, it said
there were too many fields.
Then I split them up into two tables and tried to join them with a
query based on first and last name. That produced all the fields I
needed, but did not show all the combo boxs (most, but not all) that I
had specified in the table set-up (Combo Box, Value List, "1","2","3").
Now I''m thinking I''ll need to break them down into multiple smaller
tables, and display the fields via multiple subforms on a master form.
I''d like to know if people have a better solution. Actually, I''m pretty
sure someone does. Not even sure my idea of splitting them further will
work, but its the best I can come up with at the moment...
Thanks for your help,
Reg
推荐答案
" Regnab" < P ******* @ gmail.com>在消息中写道
news：11 ********************** @ z14g2000cwz.googlegr oups.com ...
"Regnab" <p.*******@gmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
我正在建立一个数据库来记录员工收到的培训。
对于每个培训练习，他们都会收到1到3之间的分数。
最初，当没有这么多的培训元素，我把
员工的名字，姓氏，部分，急救，叉车等操作......等等放在一张桌子上。但是，我现在有一份227
训练要素的清单需要完成（每个训练要素收到1到3之间的标记）。当我试图将它们全部放在一张桌子上时，它说有太多的字段。
然后我把它们分成两张桌子并尝试用它们加入它们
查询基于名字和姓氏。这产生了我需要的所有字段，但没有显示我在表格设置中指定的所有组合框（大多数，但不是全部）（组合框，值列表，等等）。 1，2，3。
现在我想我需要将它们分解成多个较小的表格，并显示字段通过主表单上的多个子表单。
我想知道人们是否有更好的解决方案。实际上，我很确定有人确实这样做了。甚至不确定我将它们进一步拆分的想法将会起作用，但它是我现在能想到的最好的......
感谢您的帮助，
Reg
I''m making a database to record training that employees have recieved.
For each training excercise, they recieve a mark between 1 and 3.
Initially, when there weren''t so many training elements, I had put the
employee first name, last name, section, First Aid, Forklift
operation... and so on in one table. However, I now have a list of 227
Training elements that need to be completed (each recieving a mark
between 1 and 3). When I tried to put them all in one table, it said
there were too many fields.
Then I split them up into two tables and tried to join them with a
query based on first and last name. That produced all the fields I
needed, but did not show all the combo boxs (most, but not all) that I
had specified in the table set-up (Combo Box, Value List, "1","2","3").
Now I''m thinking I''ll need to break them down into multiple smaller
tables, and display the fields via multiple subforms on a master form.
I''d like to know if people have a better solution. Actually, I''m pretty
sure someone does. Not even sure my idea of splitting them further will
work, but its the best I can come up with at the moment...
Thanks for your help,
Reg
您当前的设计有一个基本的问题，即添加新的培训元素b / b元素，您需要添加一个新字段。这意味着您需要更改不仅仅是表格结构，而是查询，表单，报告，模块等。要使事情变得更容易，您需要设置表结构因此它可以处理
添加/编辑/删除训练元素而无需更改
任何表格，报告等。
标准解决方案是有三个表：
tblEmployee - 每个员工1个记录
tblTraining - 每个培训元素1个记录
tblEmployeeTraining - 员工所做的每一项培训都有1条记录
这是唯一合理的方法，但是会涉及拉开
几乎所有你拥有的完成并将数据从旧的转换为新的
格式。然而，除非我们知道你会很乐意接受这种激进的重新设计，否则没有太多意义可以进一步描述这种技术
。让我们
知道。
Your current design has the fundemental problem that to add a new training
element, you need to add a new field. This means you need to change not
only table structure, but queries, forms, reports, modules, etc. To make
things much easier, you need to set up your table structure so it can cope
with adding/editing/deleting training elements without any need to change
any of the forms, reports, etc.
The standard solution is to have three tables:
tblEmployee - 1 record per employee
tblTraining - 1 record per training element
tblEmployeeTraining - 1 record for each bit of training an employee has done
This is the only sensible way to do this, but will involve pulling apart
almost all you have done and converting the data from the old to the new
format. However, there is not much point describing this technique further
unless we know you would be happy to take this radical re-design. Let us
know.
" Regnab" < P ******* @ gmail.com>在消息中写道
news：11 ********************** @ z14g2000cwz.googlegr oups.com ...
"Regnab" <p.*******@gmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
我正在建立一个数据库来记录员工收到的培训。
对于每个培训练习，他们都会收到1到3之间的分数。
最初，当没有这么多的培训元素，我把
员工的名字，姓氏，部分，急救，叉车等操作......等等放在一张桌子上。但是，我现在有一份227
训练要素的清单需要完成（每个训练要素收到1到3之间的标记）。当我试图将它们全部放在一张桌子上时，它说有太多的字段。
然后我把它们分成两张桌子并尝试用它们加入它们
查询基于名字和姓氏。这产生了我需要的所有字段，但没有显示我在表格设置中指定的所有组合框（大多数，但不是全部）（组合框，值列表，等等）。 1，2，3。
现在我想我需要将它们分解成多个较小的表格，并显示字段通过主表单上的多个子表单。
我想知道人们是否有更好的解决方案。实际上，我很确定有人确实这样做了。甚至不确定我将它们进一步拆分的想法将会起作用，但它是我现在能想到的最好的......
感谢您的帮助，
Reg
I''m making a database to record training that employees have recieved.
For each training excercise, they recieve a mark between 1 and 3.
Initially, when there weren''t so many training elements, I had put the
employee first name, last name, section, First Aid, Forklift
operation... and so on in one table. However, I now have a list of 227
Training elements that need to be completed (each recieving a mark
between 1 and 3). When I tried to put them all in one table, it said
there were too many fields.
Then I split them up into two tables and tried to join them with a
query based on first and last name. That produced all the fields I
needed, but did not show all the combo boxs (most, but not all) that I
had specified in the table set-up (Combo Box, Value List, "1","2","3").
Now I''m thinking I''ll need to break them down into multiple smaller
tables, and display the fields via multiple subforms on a master form.
I''d like to know if people have a better solution. Actually, I''m pretty
sure someone does. Not even sure my idea of splitting them further will
work, but its the best I can come up with at the moment...
Thanks for your help,
Reg
您当前的设计有一个基本问题，即添加新的培训元素b / b元素，您需要添加一个新字段。这意味着您需要更改不仅仅是表格结构，而是查询，表单，报告，模块等。要使事情变得更容易，您需要设置表结构因此它可以处理
添加/编辑/删除训练元素而无需更改
任何表格，报告等。
标准解决方案是有三个表：
tblEmployee - 每个员工1个记录
tblTraining - 每个培训元素1个记录
tblEmployeeTraining - 员工所做的每一项培训都有1条记录
这是唯一合理的方法，但是会涉及拉开
几乎所有你拥有的完成并将数据从旧的转换为新的
格式。然而，除非我们知道你会很乐意接受这种激进的重新设计，否则没有太多意义可以进一步描述这种技术
。让我们
知道。
Your current design has the fundemental problem that to add a new training
element, you need to add a new field. This means you need to change not
only table structure, but queries, forms, reports, modules, etc. To make
things much easier, you need to set up your table structure so it can cope
with adding/editing/deleting training elements without any need to change
any of the forms, reports, etc.
The standard solution is to have three tables:
tblEmployee - 1 record per employee
tblTraining - 1 record per training element
tblEmployeeTraining - 1 record for each bit of training an employee has done
This is the only sensible way to do this, but will involve pulling apart
almost all you have done and converting the data from the old to the new
format. However, there is not much point describing this technique further
unless we know you would be happy to take this radical re-design. Let us
know.
Brian，
我感谢您提供给我的任何帮助考虑到我已经重启了两次这个项目已经两次了，再一次不会受伤:)。我已经意识到
结构是非常有限的，因为更新训练
等，但是没想到怎么做。你的想法听起来好
好....请解释:)。
Brian,
I appreciate any help you can give me and considering I''ve restarted
this project twice already, once more won''t hurt :). I had realised
that the structure was very limiting in so far as updating training
etc, but couldn''t think of how else to do it. Your idea sounds
good....please explain :).
这篇关于表格有230个字段....什么是更好的选择？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
