设计问题 - Access 2010 [英] Design Question - Access 2010

问题描述

我有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

推荐答案

没有需要一个后续表。你只是以这种方式复制和非规范化数据。


你可以使用只返回状态跟进记录的查询。不需要追加查询，也无需在一天结束时运行流程来同步数据。使用查询将使数据实时。

There''s no need for a follow up table. You''re just duplicating and denormalizing data that way.

You can just use a query that returns just the records where the status is follow up. There''s no need for an append query and there''s no need to run a process at the end of the day to sync the data. Using a query instead will make the data real time.

客户端可以拥有5种状态，只有一种是后续跟进。当记录输入主表时，我使用查询将后续记录插入后续表中，以便我可以处理它们。我需要在客户端跟踪多个跟进，这就是我创建后续表的原因。

There are 5 statuses a client can have, only one being follow up. When the record is entered into the Master table, I used the query to insert the follow up records into the follow up table so I can deal with just them. I need to track multiple follow ups on a client which is why I created the follow up table.

Rabbit是正确的。按照自己的方式行事将使您的生活变得更加轻松。你说你有一份跟进表格。只需将记录源更改为只选择状态为跟进的记录的查询，并且只要将状态更改为跟进或从跟进更改状态，它就会从表单中显示/消失（需要重新查询）如果在进行更改时表单已经打开了。）

Rabbit is correct. Doing it his way will make your life so much easier. You said you have a follow up form. Just change the record source to be the query that just picks out the records with a status of Follow Up, and as soon as you change a status to or from Follow Up, it will appear/disappear from the form (a requery would be needed if the form was already opened when the change was made).

这篇关于设计问题 - Access 2010的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！