Delphi / Object Pascal · Database exception
What does BDE Error 9748 ($2614) - Referential Integrity Fields Must Be Indexed mean in Delphi / Object Pascal?
Raised when defining a referential-integrity link between tables where the linking field or fields on one side aren't covered by an index, which the BDE requires to enforce and efficiently check the relationship.
Raised when defining a referential-integrity link between tables where the linking field or fields on one side aren't covered by an index, which the BDE requires to enforce and efficiently check the relationship.
Create an index on the linking field or fields in both the master and detail tables before defining the referential integrity relationship.