Hello,

I'm using the 2.9.7 version but I don't think this is a bug but perhaps something I'm missing.

When I insert data though the form to a column related to another in another column the form will not check the relation/FK between the two and it allows to insert data that isn't in the original column.

A couple of screenshots with the current setup:



and



If I had three Branches called London, Paris and Ottawa the form should only allow me to enter this three because of the relation between the two columns, however at the moment it allows to insert, for example, Rome.

Is there an option I'm missing?

Thank you,

Zubi

Hello,
Thanks for detailed explanation. Please try KEXI 3, for 90% it's an issue fixed in the meantime. What OS and system version do you use?