使用查询级联列表 [英] Cascading Lists using a Query

问题描述

我环顾四周，找不到任何相关的东西。

这就是我所拥有的东西


表A（行动）

批准

待定

等...

表B（原因）

N / A

拒绝

等待文书工作

更正

不良信用

ect ...


然后我将表A和B放入查询中

Qur A

Field1 = Field2（使用Lookup向导从表A和B下拉）

拒绝=不良信用

批准= N / A

待定=等待文书工作

待定=更正

等...


我将另一张表列为所有数据

字段包括日期，操作，原因，备注等等。如您所见，基于Qur A再次显示Action和Reason。然后，我从Tabl All Data using wizard创建了一个表单。

我在Action Af下输入了代码ter update。

展开 | 选择 | Wrap | 行号

解决方案

ok我拿了All Data表并更改了它们从表A和表B中查找得到的话。

已删除并将更新日期字段读入仍然存在的表单字词。 :)


动作行源读取：SELECT [tblAction类型选择]。[ID]，[tblAction类型选择]。[动作类型] FROM [tblAction类型选择];


更新后的相同代码（只是测试）得到了更新后的错误信息。

然后我将代码更改为

展开 | 选择 | Wrap | 行号

好的还没有人对此有所回答。是吗？

因为这不是客户服务站点。这是一个共享知识的协作网站，人们可以在这里回答：

1.可以

2.愿意

3.有时间

I have looked around and can''t find any thing on this.
This is what I have

Table A (Actions)
Approved
Pending
ect...

Table B (Reasons)
N/A
Denied
Waiting paperwork
Corrections
Bad Credit
ect...


I then put Table A and B in to a Query
Qur A
Field1= Field2 (both dropdowns from Table A and B using Lookup wizard)
Denied=Bad Credit
Approved= N/A
Pending= Waiting Paperwork
Pending= Corrections
Ect...

I have another Table listed as All Data
Fields inclued Date,Action,Reason,remarks, ect.. As you can see Action and Reason show up again based on Qur A. I then created a form from the tabl All Data using wizard.
I put in the fallowing code under Action After update.

Expand|Select|Wrap|Line Numbers

解决方案

ok I took the All Data table and changed them to Look up from Table A and Table B. that got the words back.
removed and readded the up date field to the form words still there. :)

Action row source reads: SELECT [tblAction Types Choices].[ID], [tblAction Types Choices].[Action Type] FROM [tblAction Types Choices];

After update same code (just testing) Got an After update Error message.
then I changed the Code to

Expand|Select|Wrap|Line Numbers

Ok no one has answers me on this yet. Y?

Because this is not a customer service site. This is a collaborative site of shared knowledge where people answer if they:
1. can
2. are willing
3. have the time

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