Extend unique field validation to multiple fields

It would be good to have an advanced option for unique field to include other fields, so for instance on a child table you could select the link to the parent table rather than coding up queries to check in the event.
Or any mix of fields in fact.