SQLite Foreign Key problem

Databases
13
Xojo version SQLite version
2020r2 3.33.0
2020r1 3.31.1
2019r3 3.29.0
2019r2 3.28.0
2019r1 3.26.0
2018r4 3.25.3
2018r3 3.24.0
2018r2 3.23.1
2018r1 3.22.0
2017r3 3.20.1
2017r2 3.19.3