Validation: Relations with multiple values for foregin keys

MerginMaps / qgis-plugin

QGIS plugin for managing Mergin Maps projects

GNU General Public License v3.0

32 stars 13 forks source link

Validation: Relations with multiple values for foregin keys #317

Open jozef-budac opened 2 years ago

jozef-budac commented 2 years ago

For relations (between tables) feature, it is important to have unique values in column (referenced field), which is used as a foreign key to the second table. It would be nice for plugin to detect, if this values are not unique and inform the user, it will not works well in INPUT. INPUT in case of multiple values chooses one of them.

tomasMizera commented 2 years ago

Related #298

wonder-sk commented 2 months ago

This should be checked for both "value relation" widget and also for relations defined at the project level.