带查询的Lookuplist [英] Lookuplist with queries

问题描述

我有3张桌子

员工

§  
ID

§  
名称（字符串）

§  
状态（选择列表，有效或已关闭） 

前缀

§  
标题

§  
说明 

BU（业务部门）

< p style =""> §  
ID

§  首字母缩略词

首先，我添加一个（员工）到一个（前缀）关系，创建一个查找列表，以便每个员工有一个职称：董事，项目经理，高级工程师等等&hebspip;接下来，我在Employee表中添加一个查询并称之为"Directors”"。
条件是：其中Status = Active且Title = Director。

现在我想在BU表上添加第三个字段查找列表，将其命名为"Director”只从Director查询中选择Director。

我已经能够在屏幕上执行此操作，但我也希望在表级别上执行此操作。如果可能的话，在VB中。

Tx， 

Greg

 

 

解决方案

我有3张桌子

员工

§  
ID

§  
名称（字符串）

§  
状态（选择列表，有效或已关闭） 

前缀

§ &NBSP;
标题

§  
说明 

BU（业务部门）

§  
ID

§  首字母缩略词

首先，我添加一个（员工）到一个（前缀）关系，创建一个查找列表，以便每个员工有一个职称：董事，项目经理，高级工程师等等&hebspip;接下来，我在Employee表中添加一个查询并称之为"Directors”"。
条件是：其中Status = Active且Title = Director。

现在我想在BU表上添加第三个字段查找列表，将其命名为"Director”只从Director查询中选择Director。

我已经能够在屏幕上执行此操作，但我也希望在表级别上执行此操作。如果可能的话，在VB中。

Tx， 

Greg

 

员工如何与模型中的BU相关？ 您实际上想要做什么查询？ 在BU找到董事？

 

I have 3 tables

Employee

§  ID

§  Name (String)

§  Status (Choice List, Active or Closed) 

Prefix

§  Title

§  Description 

BU (Business Unit)

§  ID

§  Acronym

First, I add a Many (Employee) to One (Prefix) relationship creating a lookuplist so that each employee has a Title: Director, Project Manager, Senior Engineer, etc… Next, I add a query to the Employee table and call it “Directors”. Conditions are: where Status = Active and Title = Director.

Now I would like to add a third field lookuplist on the BU table, name it “Director” that only selects Directors from the Directors query.

I have been able to do this on a Screen, but I would like to do this also on Table level. If possible, in VB.

Tx, 

Greg

 

 

解决方案

I have 3 tables

Employee

§  ID

§  Name (String)

§  Status (Choice List, Active or Closed) 

Prefix

§  Title

§  Description 

BU (Business Unit)

§  ID

§  Acronym

First, I add a Many (Employee) to One (Prefix) relationship creating a lookuplist so that each employee has a Title: Director, Project Manager, Senior Engineer, etc… Next, I add a query to the Employee table and call it “Directors”. Conditions are: where Status = Active and Title = Director.

Now I would like to add a third field lookuplist on the BU table, name it “Director” that only selects Directors from the Directors query.

I have been able to do this on a Screen, but I would like to do this also on Table level. If possible, in VB.

Tx, 

Greg

 

How are employees related to BUs in your model?  What query are you actually trying to do?  Find the directors in a BU?

 

这篇关于带查询的Lookuplist的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！