主键字段上的错误消息为空 [英] Error message on primary key field being null

问题描述

使用子表单输入数据时收到错误消息。以下是与此表单关联的表的详细信息。基本上我正在尝试输入费用数据。

tblECHO 有这些字段

I am getting error message while entering data using a sub form. Here are the details of the tables associated with this form. Basically I am trying to enter expense data.

tblECHO has these fields

展开 | 选择 | 换行 | 行号

推荐答案

这两个表都与tblECHO相关（连接类型1，一个？到多个）。

Both the tables are related to tblECHO (join type 1, one ? to ? many).

O.K.和tblECHO中的哪些字段用于连接这些表？我没有看到它。

检查链接子字段和链接主字段中是否正确列出了这些字段我认为这可能是问题所在。


为什么你使用GrantID？文本不应该是grants表中autoID的数字（只是好奇）？

O.K. and what fields in tblECHO are used to join these tables? I don''t see it.
Check that these fields are listed properly in the Link Child Fields and Link Master Fields I think that is probably the problem.

Also why are you using GrantID ? Text shouldn''t that be the number from the autoID in the grants table (just curious)?

Denburt


这两个表都有ECHOID作为FK，我忘了提及。这是连接表的字段。


另外，我使用的是GrantNo而不是GrantID - 这也是我的错误。


谢谢。

Denburt

Both the tables have ECHOID as a FK which I forgot to mention. This the field that connects the tables.

Also, I am using GrantNo and NOT GrantID - that was an error on my part too.

Thanks.

您是否检查了表单属性中的链接子字段和链接主字段，以确保EchoID在两个位置？我想如果你这样做就应该没问题。

Did you check the Link Child Fields and Link Master Fields in the forms properties to make sure that EchoID is in both places? I think if you do that you should be ok.

这篇关于主键字段上的错误消息为空的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！