关系......谁还需要他们？ [英] Relationships... who needs em anyways?
问题描述
我正在努力让这段关系轻松工作。
我最困难的时候关联信息的地方是多个分支机构有关系的地方一个表到多个表。
你看到tblModels表中的ModelNumber连接到tblMainA，tblOutDetail，tblInbDetail中的ModelNumber ......
好吧，如果我要进入该表并单击记录旁边的小加箭头，它会要求我选择一种关系。关闭桌子后，我不能再选择另一个了。如何修改？
此外，如果您发现关系中存在任何问题，请告知我们。我愿意接受建议。
请参阅此处的关系图
tblMainA存储模型编号，因此您无需将其存储在tblInbDetail和tblOutDetail中。这是重复，因为tblMainA与这些表间接关系。
Mary
我想出了如何修改子数据表。一张桌子。
另外..
你提出的建议。我相信它会限制我的用户只选择tblMainA中建议的模型吗？
我认为它现在正在这样做...我想我需要做的是能够在每个'tblInbDetail'和'tblOutDetail''中放入不同的ModelNumber ...是我只使用查找字段而不是关系吗？
多层关系不是我习惯使用的东西，所以这对我来说都是陌生的。
我的目标是这个。
tblMainA包含一个''请求的模型''
tblOutDetail和tblInbDetail包含发送/接收的实际''ModelNumber'。
我怎么会那么将表格联系起来以使其准确。请求的型号，发货模型，收到的型号。
我不知道我是否有意义，但如果您需要更多相关信息，请告诉我。
从简单的观察我会建议合并两对表：
tblInb 与 tblOut 和 tblInbDetail 使用 tblOutDetail 。
在这两种情况下，可以添加一个标记字段以将输入与输出分开。
查看（规范化和表格结构）以获得更全面的解释。
I am having the darndest time trying to get this relationship working easily.
The areas where I''m having the hardest time of relating information is where there are multiple branches relating one table to multiple tables.
You see where ModelNumber in the tblModels table connects to ModelNumber in tblMainA, tblOutDetail, tblInbDetail...
Well if I were to go into that table and click the little plus arrow next to the record, it asks me to choose a relationship. Then I can''t choose another after I close the table. How do I modify that?
Also, if you see any issues within the relationship, please let me know. I''m open for suggestions.
See relationship chart here
tblMainA Stores the Model Number so you don''t need to store it in tblInbDetail and tblOutDetail. This is duplication as tblMainA has an indirect relationhip to these tables.
Mary
I figured out how to modify the "Subdatasheet" of a table.
Also..
The suggestion you made. I believe it would limit my users to select only the model suggested in tblMainA?
I think it''s doing that now anyways... I guess what I need to do is be able to put different ModelNumber''s in each of the ''tblInbDetail'' and ''tblOutDetail'' ... is that just me using a lookup field instead of a relationship?
Multilevel relationships are not something I am used to working with, so this is all foreign to me.
My goal is this.
tblMainA contains a ''Requested Model''
tblOutDetail and tblInbDetail contain the actual ''ModelNumber'' that was shipped/received.
How would I then relate the tables so that it is accurate. Requested model, shipped model, received model.
I don''t know if I am making sense, but if you need more information regarding this, please let me know.
From simple observation I would advise merging the two pairs of tables :
tblInb with tblOut and tblInbDetail with tblOutDetail.
A flag field may be added to separate the ''In''s from the ''Out''s in both cases.
Have a look through (Normalisation and Table structures) for a fuller explanation.
这篇关于关系......谁还需要他们？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
