Skip to main content
Solved

Relationship types


rvgfox
Problem Solver
Forum|alt.badge.img+4
  • Problem Solver
  • 205 replies

Normally I’m using the default type:

Can anyone explain the different behaviors?

Best answer by rvgfox

I’ve tested the four options and now, I understand:

 

 

View original
Did this topic help you find an answer to your question?

2 replies

rvgfox
Problem Solver
Forum|alt.badge.img+4
  • Author
  • Problem Solver
  • 205 replies
  • Answer
  • August 4, 2023

I’ve tested the four options and now, I understand:

 

 


Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 970 replies
  • August 4, 2023

Hi @rvgfox 

It is explained in the table relations guide in this section.

Thomas Lind

 

The following are the relationship options.

  1. 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.
  2. 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.
  3. 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.
  4. Relation: TimeXtender ignores any violations of the check.

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings