Hello everyone, me again.
well, now we have an important discussion about how we can use relations in 4D for reports and forms, we had some very bad experiences using relations on 4D v11 that pushed us to change how we should use it, the immediate solution was putting extra fields in our tables storing all IDs of tables that we need related for reports, but personally i think that this is a very bad practice, because you lose your database normalization.
I know that ORDA improves greatly the use of relations, but we don’t have enough experience using relations with 4D 17 and it’s possible mistakes
I appreciate if any of you could tell us your experiences using cascade relations for your reports and use in forms and stuff like this
I hope I have been clear and you can understand my concern
Thanks a lot for your help