Group validation before INSERT

In a USoft application interface, when all field values belonging to a group have been entered, and the user leaves the last (entered) field:

•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.