在一个表中创建一个影响所有其他表的过滤器 [英] Creating a filter in one table that effects all other tables

问题描述

我是Access的新手，并且已经找到了如何在表之间创建适当的关系，但是我无法根据应用于第三级的过滤器从第一级表中过滤掉数据。

为了清楚起见，我将解释我在做什么。我在表1中有一个美国发电厂的数据库，它列出了它们的位置和ID。在表2中，我列出了从2014年到2014年每年发电厂的数据。最后，在表3中，我给出了给定年份的每个发电厂的单位特定数据。


我想过滤表3中的联合循环单位并且仅返回相应的表1和表2中的植物。


我感谢任何帮助。

I am very new to Access and have figured out how to create appropriate relationships between tables, but I am having trouble filtering out data from the first level table based on filters applied to the third level.

Just for clarity I will explain what I am doing. I have a database with power plants in the US in table 1, it lists their location and ID. In table 2 I have data for those power plants for each year from 09-2014. Finally, in table 3 I have unit specific data for each power plant for the given year.

I want to filter just the combined cycle units in table 3 and have that return only the appropriate plants in table 1 and 2.

I appreciate any help.

推荐答案

如果你的表格相关，那么通过过滤表1中的一个（或多个）发电厂，您将只获得表2和表3中与该发电厂相关的那些记录。您尝试了什么以及您获得了什么结果？

If you have your tables related properly, then by filtering one (or more) power plant in table 1, you will only get those records that are related to that power plant in tables 2 and 3. What have you tried and what result did you get?

我试过这个，他们不会以任何方式跨表过滤。我想我的关系不正确。


目前我通过一对多类型1关系获得与表2中的字段相关的表1 ID。表2以相同的方式与表3相关（表2的ID为表3中的字段）

I have tried this, and they do not filter across tables either way. I guess my relationships are incorrect.

Currently I have table 1 ID related to a field in table two through a one-to-many type 1 relationship. Table 2 relates to table 3 in the same way (with table 2''s ID to a field in table 3)

关系看起来正确。你是如何实现过滤器的？例如，您是在查询中使用WHERE子句，使用表单过滤器等。

The relationships look right. How are you implementing the filter? For example, are you using a WHERE clause in a query, using a form filter, etc.

这篇关于在一个表中创建一个影响所有其他表的过滤器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！