I need the same. From what I’ve seen in other posts, this is not possible without resorting to workarounds such as a separate table for relationships, using automation, or external add-on. It is really baffling that it is not supported out of the box...