Database One to One relationship between collections

many of my clients and I have stumbeled upon a need that comes backl really often and it’s to have the ability to put a 1 to 1 relationship between two collections, cause sometimes we need to filter or see the data of one specific record on both sides, and what’s available right now is not showing exactly what we need, hope that the other users will agree with me