向导不要求表关系 [英] wizard doesn't ask for table relationship
问题描述
我正在使用2002（10.6771.6839）SP3 Access程序。我最初（在我学习的同时获得）开发了一个250字段的表。
为了简化它，我将表保存在六个不同的名称下，然后从六个不同的部分中删除领域。这给了我六张桌子，其中包括原始大象的所有字段，并允许我在需要的地方添加一些额外的字段。
然后我使用六个新表创建了新的查询。但是，与以前的创建不同，向导没有询问表之间的关系。
我使用了两个现有表单，并且输入数据没有问题，但输入的数据可以通过打开表格找到，当我打开表格时，先前输入的数据不存在。
我是否正确怀疑向导的无问题与问题之间存在关系？当然，我该如何解决？
cg
I''m working with the 2002 (10.6771.6839) SP3 Access program. I originally (earn while I learn) developed a 250-field table.
To streamline it, I saved the table under six different names, then deleted from each of the six different sections of fields. This gave me six tables which included all the fields of the original elephant and allowed me to add in a few extra fields where needed.
I then created new queries, using the six new tables. However, unlike previous creation, the wizard did not ask what the relationship was between the tables.
I used two existing forms, and have no trouble entering data, but although the entered data can be found by opening up the tables, when I open the forms, previously entered data is not there.
Am I correct in suspecting that there''s a relationship between the lack of the wizard''s non-question and the problem? And of course, how can I fix it?
cg
推荐答案
很难完全按照你所描述的Chuck，但你应该检查一些事情：
Hard to follow exactly what you''re describing Chuck, but a few things you should check :
- 所有的表是否共享相同的主键（它们应该是）？
- 有你定义了关系窗口中所有表之间的逻辑连接吗？
- 实际上，虽然它不是绝对必要的，但我会考虑将其中一个子表作为主表来处理，这样它链接到所有其他的，而不是所有其他链接。
...我使用了两个现有的表格，并且输入数据没有问题，但是虽然可以通过打开表格找到输入的数据，但是当我打开表格时，之前输入的数据不存在。 ...
...I used two existing forms, and have no trouble entering data, but although the entered data can be found by opening up the tables, when I open the forms, previously entered data is not there. ...
这两个表单是否设置为允许添加但不允许编辑？检查表单的属性，如果从命令按钮打开表单，请检查它们是否未在添加模式下打开，即
DoCmd.OpenForm表单名称 ; ,,, acFormAdd
而不是
DoCmd.OpenForm" Form of Form"，,, acFormEdit
如果关系出现问题，我怀疑你是否可以添加新数据。
-Stewart
Are the two forms set to Allow Additions but not Allow Edits, by any chance? Check in the form''s properties, and if you open the forms from a command button check that they are not being opened in Add mode, i.e.
DoCmd.OpenForm "Name of Form", , , acFormAdd
instead of
DoCmd.OpenForm "Name of Form", , , acFormEdit
If there were problems with relationships I doubt you would be able to add new data at all.
-Stewart
Stewart，表格允许添加和编辑。
NeoPa，我将所有表格通过自动ID链接到一个表格。他们应该有其他关系吗？
cg
Stewart, the forms allow for both addition and edit.
NeoPa, I have all the tables linked by auto id to just one table. Is there some other relationship that they should have?
cg
这篇关于向导不要求表关系的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
