Model: Use referential integrity (Oracle)
Author: firstname.lastname@example.org (jfro)
We have the idea to make Uniface create a script for referential integrity to use in Oracle.
We have some troubles in doing this for "one to many" relationships. Does somebody use this?
I found in the help under "Use Referential integrity:"
"The number of fields in the key of the one entity must be equal to the number of foreign key fields specified in the relationship."
Maybe I don't understand this correct - but this would in my opinion mean that never a "one to many" relationship will be valid. In the "many-entity" I will surely always have an attribute more in the key as in the "One entity".
Thanks in advance!