Many-to-many relationship

HCL Domino Domino Forum
1

Hello,

I have two types of records - record X and record Y and each one of them have a field called “id”. These records have a many-to-many relationship between them.

Is there an easy way to create this type of relationship in a lotus notes database without having several fields in both records to show the ids of the records they are related to?

The objective is to be able to create two different views, one that shows all Y records related to the X records, and another one that shows all X records related to Y records.

Thanks in advance,

Aline

2

Subject: Multi-value field

Can’t you just have a multivalue field called RelatedIds in both records that have the IDs from the other record type?

3

Subject: Multi-value field

I don’t know if that would work, since I want to create a view and show the two record types in it. The view would be categorized.

For instance, I want this view to show in one twisty the record X. When users open the twisty, I want it to show all of the records Y connected to it.

Is there a way to create that view using this multi-value field?