Readonly table for data validation of linked records

[Frank_Norrmann]

There are tables that are used for quick data entry that are normally not updated very often (for example product brands). The linked table GUI allows to pick existing records from the brand table, or if you type new stuff and press enter a new record is created in the table. During massive and quick data entry this can be a problem as duplicate or incomplete records could be created. The idea is to have a “flag” at the table level that updates to that table can only be done from the actual table, and not from a linked record. It is a “data validation” feature really.

Cheers,

[QuantumStep]

I get what you’re saying—that can definitely lead to a mess when new records are created by mistake. If you want to prevent incomplete or duplicate records being added from linked fields, you could try the DataGuard extension. It has a Unique rule to avoid duplicates and Required Fields to make sure nothing critical is missing, all enforced in real-time as data is entered.

It doesn’t restrict changes only to the main table, but the validation rules could help stop bad data from slipping through during quick data entry.