Normally I’m using the default type:
Can anyone explain the different behaviors?
Best answer by rvgfox
View originalRelationship types
Userlevel 3
+1
Userlevel 3
+1
I’ve tested the four options and now, I understand:
Userlevel 5
+5
Hi
It is explained in the table relations guide in this section.
The following are the relationship options.
- Error: This means that if a related row does not exist in the table, it will be moved to the error table and data may be missing from the valid table instance.
- Error with physical relation: The relation is stored in the database for other database tools to see. The behavior is otherwise the same as the Error setting. Note that the table needs to have a primary key and a unique index set. If index automation on the table has been disabled, then table indexes will need to be created manually.
- Warning: TimeXtender copies the invalid record to the warnings table and the valid table instance will still include this data. No data will be missing as a result of the warning, however, the instances that violate the rule may need to be further handled in some other way.
- Relation: TimeXtender ignores any violations of the check.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
