referential integrity do not work, is not oke. I can add and save records between two tabels with a relation. I can add records in the child table while the refer key is not exists in the parent table.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have just done tests under windows of your project
it is impossible to add "serielrel" in the table "tstripboek" that never exist in the table "tserie", therefore, there is the asset.
I will do tests under linux ....
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You get me wrong.
I can put data in the field "serie" in table tStripboek, while the parent record is not exists in the table tSerie, field "serie". That is wrong. Field "serierel" is only the link field.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Yes it is normal, the field "series" is not linked, only the field "seriel", it is necessary to be based on this field, it is there the referential integrity
It's basic my dear watson
you do not need a "serie" field in the "tstripboeek" table, it is "serierel" that carries the information
a view will allow you to visualize this field
Last edit: neuts-jl 2019-06-14
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
referential integrity do not work, is not oke. I can add and save records between two tabels with a relation. I can add records in the child table while the refer key is not exists in the parent table.
I have just done tests under windows of your project
it is impossible to add "serielrel" in the table "tstripboek" that never exist in the table "tserie", therefore, there is the asset.
I will do tests under linux ....
You get me wrong.
I can put data in the field "serie" in table tStripboek, while the parent record is not exists in the table tSerie, field "serie". That is wrong. Field "serierel" is only the link field.
Yes it is normal, the field "series" is not linked, only the field "seriel", it is necessary to be based on this field, it is there the referential integrity
It's basic my dear watson
you do not need a "serie" field in the "tstripboeek" table, it is "serierel" that carries the information
a view will allow you to visualize this field
Last edit: neuts-jl 2019-06-14