链接子表单 - 错误消息 [英] Linking subforms - error message

问题描述

我有一个跟踪新案例（律师事务所）的营销来源的数据库，并标记需要跟进的潜在新案例，直到他们被接受，拒绝，客户停止响应或他们被引用到另一个公司。我有很多馈线表填充下拉框，但有四个主表。我有一个表格（frmMaster），它收集营销来源（tblIntakeMaster），客户信息（tblClient），事故信息（tblAccident）的初始数据，以及是否需要跟进（tblFollowUp）。


还有一个表（tblReferIn）跟踪从另一位律师和一个表（tblReferOut）引用的案件的信息，该表跟踪提交给其他公司的案件的案件信息。我无法实现这些，因为我的主要表单（frmMaster）不起作用。所以这将是下一阶段。但是，在尝试输入新记录时，我在frmMaster上不断收到以下错误消息：


您无法添加或更改记录，因为表'tblClient'中需要相关记录。


我的主要表格（frmMaster）由3页组成：进入信息，客户信息&事故信息，事故信息有另一个跟进子表格。


frmMaster的记录源是tblIntakeMaster（PK = IntakeMasterID），是Page1 = Intake Info。


第二页是客户信息，记录源是sfrmClient，它与tblClient绑定（PK = ClientID，FK = IntakeMasterID）我将AccidentID添加为另一个FK，因为我一直收到上述错误，但它仍然没有不行。 Link Master& sfrmClient上的子字段是IntakeMasterID。


第3页是事故信息，记录源是sfrmAccident，它与tblAccident（PK = AccidentID，FK = ClientID& IntakeMasterID）相关联。 Link Master是IntakeMasterID，Link Child是ClientID。


在第3页的底部是另一个名为sfrmFollowUp的子表单，它与tblFollowUp绑定（PK = FollowUpID，FK = AccidentID） 。 Link Master& sfrmFollowUp上的子字段是AccidentID。


我在表格中添加了字段，更改了链接记录，似乎没有任何效果。我甚至创建了一个示例数据库，它工作正常！难道我必须再次重建这个数据库才能使它工作，因为我没有第一次进行结构设置吗？如果有人想看看我附加我的数据库。当您尝试添加记录并与tblClient和tblAccident有关时，问题出在frmMaster中。非常感谢任何帮助！


谢谢，

Mike

附加文件

（99.7 KB，160个视图）

我还需要查看表单建立。不是所有东西，只是与子表格相关的少数属性以及它们如何被链接。

I have a database that tracks the marketing source of new cases (law firm) and flags potential new cases that need to be followed up on until they are accepted, declined, the client stopped responding, or they are referred out to another firm. I have a lot of “feeder” tables that populate drop down boxes, but have four main tables. I have a Form (frmMaster) that collects the initial data on the marketing source (tblIntakeMaster), the client info (tblClient), the accident info (tblAccident), and if there is any follow up needed (tblFollowUp).

There is also a table (tblReferIn) that tracks info on cases referred in from another lawyer and a table (tblReferOut) that tracks case info on cases referred out to other firms. I have not been able to implement these because my main form (frmMaster) is not working. So this will be the next phase. However, I keep getting the following error message on the frmMaster when trying to enter new records:

“You cannot add or change a record because a related record is required in table ‘tblClient’.

My main Form (frmMaster) is made up of 3 Pages: Intake Info, Client Info & Accident Info, with Accident Info having another subform for follow ups.

The Record source for frmMaster is tblIntakeMaster (PK=IntakeMasterID) and is Page1 = Intake Info.

The 2nd Page is Client Info, Record source is sfrmClient, which is tied to tblClient (PK=ClientID, FK=IntakeMasterID) I added AccidentID as another FK because I kept getting the above error, but it still didn’t work. The Link Master & Child Fields on sfrmClient is IntakeMasterID.

The 3rd Page is Accident Info, Record source is sfrmAccident, which is tied to tblAccident (PK=AccidentID, FK=ClientID & IntakeMasterID). The Link Master is IntakeMasterID and the Link Child is ClientID.

At the bottom of Page 3 is another subform named sfrmFollowUp, which is tied to tblFollowUp (PK=FollowUpID, FK=AccidentID). The Link Master & Child Fields on sfrmFollowUp is AccidentID.


I have added fields to my tables, changed the Link records, and nothing seems to work. I even created a sample database and it worked! Could it be that I have to rebuild this database once again in order to make it work because I didn’t have the structure setup the first time? I am attaching my database if anyone wants to take a look at. The problem is in frmMaster when you try to add a record and has something to do with tblClient and tblAccident. I really appreciate any help!

Thanks,
Mike

Attached Files

IntakeMktgDB_ver2.zip (224.6 KB, 72 views)

解决方案

I can''t open that database. It must be in a newer version. Either save it in 2003 format or describe the relevant structures here.

see attached PDF copy of table structure

Attached Files

Table Structure ver2.pdf (99.7 KB, 160 views)

I would also need to see the form setup. Not everything, just the few properties related to the subforms and how they''re being linked.

这篇关于链接子表单 - 错误消息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！