问题描述
我有两个表PROJECTS和ORDERS。
I have two tables PROJECTS and ORDERS.
当您输入新的ORDER时，您可以向其添加项目编号，因此它们是相关的。项目通常有0到10个不同的订单。当供应商确认ORDER时，您可以勾选复选框确认=是。
When you input a new ORDER you can add a project number to it, so they are related. A PROJECT usually has 0 to 10 different orders. When ORDER gets confirmed by supplier you can check checkbox on it CONFIRMED = Yes.
我想知道项目的所有输入订单是否都已确认。最好的是在PROJECT表中有一个值，默认情况下为NO，但是在有与之相关的ORDERS之后，所有这些都被确认，值变为YES。因此，我可以运行更新
宏并发送一封电子邮件，告知所有项目订单都已确认。
I want to know if ALL input orders for a project are confirmed. Best would be to have a value in PROJECT table which is NO by default but after there are ORDERS related to it and ALL of them are confirmed the value changes to YES. So I can run on update macro and send an email telling that ALL of the PROJECT ORDERS are confirmed.
我试图通过查询进行查询，但我不确定它是否是正确的路线。 datamacro是否更适合这种情况。或者是否有其他方法可以获得相同的结果？
I tried to make it with queries but Im not sure if its the correct route. Is datamacro better suitable for this. Or are there some other ways to achive same result?
推荐答案
这篇关于Access Web App：如果所有相关表值均为YES，则在表中创建YES值。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！