I am new to Servoy and would like to know the differences between the three types of relationships: local relationships, global relationships and database defined relationships.
What are the advantages/disadvantages of each and when should I use them?
Thanks,
I’m not sure what you mean by “local” and “global” relationships… all relations in servoy are “global” (meaning they can be used from any form whose base table is one used on the left side of the relation).
Database relations only exist within the backend database - and can be optionally viewed and used within your Servoy application.
As far as the useage goes - that’s up to you. There are no “hard and fast” rules. A guideline you may want to consider is: if you are going to have multiple Servoy applications accessing the same set of tables - it might be better to create the relations in the backend so then you can just “use them” in each solution without having to re-create them in each solution separately.
Hope this helps.