A simple idea: what if linked records could be colored?
The conditions in the linked table would determine the color of the record.
This would help counteract one of the many conundrums of having to choose between linked records and multi / single select fields. What do you think?