问题描述
我有MasterID和Master的主表。其他领域的状况。如果Status = FollowUp，那么我需要跟进该记录。我创建了一个FollowUp表，并将主表中Status = FollowUp的所有记录插入FollowUp表。我这样做是通过创建一个可以正常工作的追加查询来实现的。
一旦所有FollowUp记录都在FollowUp表中，我可以编写一个查询来识别FollowUp记录（如果只有一个）跟进。但是，如果MasterID（客户）在FollowUp表中有多个跟进，我不知道如何识别它们。
在一天结束时，我需要识别所有跟进记录，并且可能会有多个跟进。但是，一旦MasterID（客户端）的状态不等于FollowUp，那么我不想拉这些记录。我在FollowUp表单中想要的只是仍然具有Status = FollowUp的客户端。因此，FollowUp表可能具有状态= FollowUp的记录＃1，具有Status = FollowUp的记录＃2，但具有Status = Declined的记录＃3。一旦状态不是FollowUp，我不希望该客户出现在我的FollowUp表格中。我希望这是有道理的。我很感激任何见解。
谢谢，
Mike
I have a Master Table with MasterID & Status among other fields. If the Status=FollowUp, then I need to follow up on that record. I created a FollowUp Table and inserted all records with a Status=FollowUp from the Master Table into the FollowUp Table. I did this by creating an Append Query which did work.
Once all the FollowUp records are in the FollowUp Table, I can write a query to identify the FollowUp records if there is only one follow up. However, if a MasterID (Client) has multiple follow ups in the FollowUp Table, I don''t know how to identify them.
At the end of the day, I need to identify all Follow Up records, and there may be multiple follow ups. But once a MasterID (Client) has a status not equal to FollowUp, then I do not want to pull those records. All I want in my FollowUp Form are Clients that still has a Status=FollowUp. So the FollowUp Table may have record #1with a Status=FollowUp, record #2 with a Status=FollowUp, but record #3 with a Status=Declined. Once the Status is not FollowUp, I don''t want that Client to show up in my FollowUp Form. I hope this makes sense. I appreciate any insight.
Thanks,
Mike
推荐答案
这篇关于设计问题 - Access 2010的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！