使用一个访问表单列来过滤另一个。 [英] Using one access form column to filter another.

问题描述

我正在编写一个访问数据库，并希望进行项目构建并更新主列表中的数量。项目构建表具有部件ID和所需数量，主列表具有所有部件ID，我想将其过滤到项目构建表中指定的项目中使用的特定部件。我希望在我从项目构建生成的报告上触发事件后发生这种情况。

I am programming an access database and want to take a project build and update the quantities on the master list. the project build table has the part id and the quantity needed and the master list has all the part id''s and i want to filter it down to the specific parts used in the project as specified in the project build table. i want this to happen after i trigger an event on the report generated from the project build.

推荐答案

你是在谈论这些方面的事情： +级联组合/列表框


另外，请记住，报告通常就是报告。从理论上讲，它们确实应该是数据处理的终点。恕我直言，报告中不应该有任何交互式控件（尽管事实上MS似乎允许这样做，后来经常被允许发现这不是一件好事:)）

Are you talking about something along these lines:+ Cascading Combo/List Boxes

Also, keep in mind, reports are normally just that, a report. In theory, they really should be the terminus point of the data handling. IMHO, there should not be any interactive controls on a report (despite the fact that MS seems to allowed this, often what is allowed is later found to not be a good thing :) )

我是否收集了2个问题，第一个是在从主项目表中选择零件时更新主表上的库存数量。你想要做的第二件事是打印这些库存数量。

我担心你没有提到你项目的表格，所以你没有办法检查你的库存在哪里。

如果你能清除它，我相信你会得到进一步的帮助。


Phil

Do I gather you have 2 questions, the first being to update the stock quantity on your master table as you select the parts from the project build table. The second thing you appear to want to do is print those stock quantities.
I am concerned that you do not mention a table for your project, so you have no method of checking where your stock has gone.
If you can clear this up I''m sure you will get further help.

Phil

@ Phil，

OP有一个主要问题和条件 - 否则我会删除次要问题或关闭线程：

@Phil,
OP has one main question and the condition - otherwise I would have either deleted the secondary question or closed the thread:

[kkDubs]

+我想将其过滤到项目构建表中指定的项目中使用的特定部分。


+我希望在我从项目构建生成的报告上触发事件后发生这种情况。

[kkDubs]
+ i want to filter it down to the specific parts used in the project as specified in the project build table.

+i want this to happen after i trigger an event on the report generated from the project build.

现在让我们坚持这个主题。


@kkDubs

如果菲尔是正确的，有一个与股票有关的次要问题，请开始一个新的主题。


++我们一次尝试将线程限制为一个主题，否则事情会变得非常混乱。



Thnx

-Z

For now let us stick to that within this thread.

@kkDubs
If Phil is correct and there is a secondary question related to the stock please start a new thread.

++ We do try to limit threads to one topic at a time otherwise things can become very muddied.


Thnx
-Z

这篇关于使用一个访问表单列来过滤另一个。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！