带有动态下拉菜单的组合框 [英] Comboboxes with dynamic dropdown menu

问题描述

我有一个带有几个组合框的表单我希望动态输入他们的菜单。


第一个框是部门，它包含组织中的所有部门。当我在这个框中选择一个部门时，我想要第二个组合框，即用户。仅填充此部门中的用户。就像现在一样，用户是从一个填充了组织中所有用户的表中抽取的。


选择用户后我想要硬件组合框和软件组合框中仅填充分配给它们的资产。这些值是从包含组织中所有资产的各自表中提取的。

I have a form with a few combo boxes that I would like to have their menu entered dynamically.

The first box is department and it holds all the departments in the organization. When I select a department in this box I would like the second combo box, which is "user" to be populated with only the users in this department. As it is right now users are being drawn from one table that is populated with all the users in the organization.

After selecting the user i would like the the hardware combobox and the software combo box to be populated with only the assets that are assigned to them. These values are pulled from their respective tables which contain all the assets in the organization.

推荐答案

这应该不那么难。组合框菜单应基于在其条件部分中具有相应组合框的查询。

像这样：

1.部门框基于查询，包括所有部门。

2.用户组合框必须基于包含所有用户的查询WHERE Department ID = DepartmentComboBox

3.其他人也一样。 。

让我们知道它是如何发生的。

This should not be that hard. The combo box menus should be based on queries that have the appropriate combo boxes in their criteria section.
Like this:
1. Department box is based on query which is including all the departments.
2. User combo box must be based on a query that includes all the users WHERE Department ID = DepartmentComboBox
3. the same goes for others...
Let us know how it''s going with this.

这个Bytes洞察力文章应该有所帮助：级联组合/列表框

This Bytes insight article should help: Cascading Combo/List Boxes

你应该找到整个问题在表单上过滤示例。


告诉我们你是怎么过的。

You should find the whole issue covered in Example Filtering on a Form.

Let us know how you get on.

这篇关于带有动态下拉菜单的组合框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！