Forum Discussion
DavidBrogdon
6 years agoQrew Assistant Captain
You mentioned you need to re-evaluate but I wanted to mention the possibility of a "slotting" system. If you can figure out a way to categorize the sample data into 4 or 5 unique parent tables, then each slot will contain data unique from the others. For example, Slot 1 contains samples 1 through 10, Slot 2 contains samples 11-20, etc..
You can take this further by creating form rules that display messages if slot1 =slot2 (parent 1 = parent 2) etc. Or you can create a formula field that generates a unique number that is required in order to save the record, but the number is only generated when no slots are matching.
You can take this further by creating form rules that display messages if slot1 =slot2 (parent 1 = parent 2) etc. Or you can create a formula field that generates a unique number that is required in order to save the record, but the number is only generated when no slots are matching.