I need to set the relationship between two sets of data. The sets can be big, with hundreds of records. After some research, I found that some applications use a dependency matrix, like in this example from Salesforce:

enter image description here

The idea is to set the relationship between a "Controlling set" and a "Dependent set".

But it is difficult to visualize large sets of data, as the amount of columns grow and you need to paginate horizontally.

So, I'm thinking about using this model instead:

enter image description here

The idea is having two lists, a selecting one for the controlling set and the other one for the dependent set (one to many relationship).

I also could have many to many relationships. Where a dependent record could be associated with one, two or more controlling records. In this case I would be able to also select from dependent set to controlling set, like in this image:

enter image description here

Do you think this is an easier, more usable way to solve the problem? Or do you have any other suggestions?

Thank you!


I think your idea is very good, and it is better than the first screenshots by miles.

It is atomic-design oriented and will translate well on mobile-devices.

The controls you've chosen are also sound.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.