我尝试打开一个表单，它给出了下面给出的错误 [英] I try and open a form and it gives the error given below

问题描述

指定的字段[Equipment]可以引用SQL语句的FROM子句中列出的多个表

The specified field [Equipment] could refer to more than one table listed in the FROM clause of your SQL statement

展开 | 选择 | 换行 | 行号

推荐答案

发布代码或格式化数据时请使用代码标签。


您有多个具有相同名称的字段。当您尝试引用其中一个时，它不会知道您要使用哪一个。在这种情况下，您将返回名为Equipment的2个字段。当你尝试在表单中引用该字段时，它不知道你在谈论的两个字段中的哪一个。此外，你将返回两次字段Part。


作为旁注，你应该尽可能避免使用域聚合函数，它们往往表现不佳。

Please use code tags when posting code or formatted data.

You have more than one field with the same name. When you try to reference one of them, it''s not going to know which one you mean to use. In this case, you are returning 2 fields with the name Equipment. And when you try to reference that field in the form, it doesn''t know which of the two fields you are talking about. Also, you''re returning the field Part twice.

As a side note, you should avoid domain aggregate functions when possible, they tend to be poor performers.

它不知道我引用了哪个字段，因为我已经使用[table_name] .equipment？

Shouldnt it know which field i am referencing since i have specified using [table_name].equipment?

进行了指定，而且我正在设置它们="彼此允许引用是一样的吗？

and also I am setting them "=" to eachother allowing the reference to be the same?

这篇关于我尝试打开一个表单，它给出了下面给出的错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！