JROTC数据库怎么办? [英] How to do JROTC database?

问题描述

我在检查级联更新相关字段框时尝试在表之间建立关系，但在索引或关系的定义中收到错误消息无效字段定义"CadedIDNumber".我无法解决任何想法.

I am trying to establish realationships between my tables when I check the Cascade update related fields box I get the error message invalid field definition "CadedIDNumber" in definition of index or relationship. Any ideas I can''t figure it out.

推荐答案

在无法看到您的数据库结构的情况下，我会:

1.确保每个表中都有主键.
2.确保主键引用了子表中的外键，并且数据类型与主键相同.
3.确保外键已建立索引，但允许重复.

如果您提供更多信息，我们可以为您提供更好的帮助.谢谢，祝你好运.

With out being able to see your database structure I would:

1. Make sure you have a primary key in every table.
2. Make sure that primary key is referenced to a foreign key in your child table and that it is the same data type as the primary key.
3. Make sure that the foreign key is indexed but allows duplicates.

If you provide more info, we can help you better. Thanks and good luck.

这篇关于JROTC数据库怎么办?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！