需要帮助设置表格结构以便按单位排序。 [英] Need help setting up table structure for ordering by unit.

问题描述

我上周在这里发了一个关于订购数据库的问题，我正在尝试设置，并得到了一些很好的帮助。所以我希望你们中的一些人能够让我在正确的轨道上找到我在同一个项目上的另一个问题。


这里有一些一般性的关于我到目前为止所做的事情的信息（为了记录，我在这方面相当新手。）：


我正在设置的数据库是为了小型电力公用事业公司向库存仓库提交订单，以便建立每个项目所需的零件。用户输入工作请求编号（来自不相关的工单系统），然后可以输入该项目的任意数量的材料订单。现在，用户输入项目编号和数量。我有一个从库存仓库中的excel电子表格导入的表，其中包含所有项目编号和描述，当用户输入项目编号时，它会在表单上填充说明。有一个基于当前订单号的查询，以及一个基于此查询的报告，可以提交给仓库。所有这一切都工作得非常好，它正在做我们需要的......除了现在我被要求添加一个变体，这就是我需要帮助的地方。

当我们要建造一条新的电力线时，每根电杆都有一个poletop配置分类或单元号。他们希望能够选择按单位订购，而不必专门输入每个单独的项目。例如，C1单元将具有一个横臂，3个绝缘体和3个引脚; C2单元有两个横臂，6个绝缘子和6个引脚。最终，我需要一个订单表格，显示提交给仓库的所有单个组件和所需数量。因此，如果他们输入的数量为五个C1'，我需要报告列出5个横臂，15个绝缘体和15个引脚。


我希望我是很好地解释这个问题。我不想在电气术语中陷入困境。有关如何设置的一般建议吗？在这一点上，我只是在寻找关于表/查询结构的一些一般性建议。


非常感谢，


April

I posted a question here last week about an ordering database I''m trying to set up, and got some excellent help. So I''m hoping some of you might be able to get me on the right track with another question I''ve got on the same project.

Here''s some general info on what I''ve done so far (For the record, I''m quite a novice at this.):

The database I''m setting up is for a small electric utility company to submit orders to the inventory warehouse for the parts that will be needed to build each project. The user enters the work request number (that comes from an unrelated work order system), and then can enter any number of materials orders for that project. Right now, the item number and quantity is entered by the user. I have a table that is imported from an excel spreadsheet from the inventory warehouse that has all of the item numbers and descriptions, and when the user enters the item number, it populates the description on the form. There is a query based on the current order number, and a report based on this query which can be submitted to the warehouse. All of this is working beautifully and it''s doing exactly what we need... except now I''ve been requested to add a variation on this and that''s where I need assistance.

When we are going to build a new powerline, each pole has a poletop configuration classification, or "unit number". They would like to be able to have the option to order by unit rather than having to enter each individual item specifically. For example, a C1 unit would have one crossarm, 3 insulators, and 3 pins; where a C2 unit would have two crossarms, 6 insulators, and 6 pins. Ultimately I need to have an order form that would show all of the individual components and required quantities to submit to the warehouse. So if they entered a quantity of five C1''s, I''d need the report to list 5 crossarms, 15 insulators, and 15 pins.

I hope I''m explaining this question well enough. I didn''t want to get too bogged down in the electrical terminology. Any suggestions in general on how to set this up? At this point, I''m just looking for some general suggestions on table/query structure.

Thanks so much,

April

推荐答案

这里要问的问题是，您是希望能够按单位订购，还是通过混合在一起的单个商品编号订购。

您是否需要记录订购的单位，或者您只是使用它们来快速输入订单，并且只保存项目总数？


看起来你要么需要一张桌子with：


UnitNumber - text，PK

CrossArmCount - 整数

InsulatorCount - 整数

PinCount - 整数

OtherPartCount - 所有部分的整数

等

The question to ask here is whether you want to be able to order by unit only, or also by individual item number mixed together.
Do you need to record the units ordered, or can you just use them to quickly enter orders, and save only the item totals?

It seems like either way you will need a table with:

UnitNumber - text, PK
CrossArmCount - integer
InsulatorCount - integer
PinCount - integer
OtherPartCount - integer
etc. for all parts

您好，ChipR。


表格可以更加规范化。 ...恕我直言


亲切问候，

鱼

Hi, ChipR.

The table could be "more normalized". ... IMHO

Kind regards,
Fish

他们可以选择订购按部件号其中该订单中的所有项目均按部件号进行，然后单独选择按单位排序。其中该订单中的所有项目均按单位编号完成。只要两个不同的订单仍然可以链接回项目。例如，执行计量部分的人可能想按订单号订购他的东西，其中构建生产线的人想要按单位订购。

They are okay with having the option of "order by part number" where all items within that order are by part number and then a separate option of "order by unit" where all items within that order are done by unit number. As long as the two different orders can still be linked back to the project. For instance, the guy who does the metering portion may want to order his stuff by order number, where the guys who build the line would want to order by unit.

这篇关于需要帮助设置表格结构以便按单位排序。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！