Group validation before UPDATE

In a USoft application interface, when fields values within a group have been changed, and the user leaves the group:

•For a group of foreign key fields, first all joined columns associated with the relationship are queried. Then, the foreign key is checked.

•For a group of unique key fields, the uniqueness of the key is checked.