How to connect two multiple values fields

HCL Domino Domino Forum
1

there are two fields allowing multiple values. Say field A and B. Field A stores event names, field B stores owners of each event. The relation between event and owners are 1 to M.

How to technically build connection between two fields so I know what owners are corresponding to each event.

Thanks

2

Subject: how to connect two multiple values fields

How are you using these fields? is it on a per document basis or a one off document used in lookups?

3

Subject: RE: how to connect two multiple values fields

Basically my goal is to display two fields in GUI like below:

event owners

e1 jack

              John

e2 Smith

However, right now I can only get this result:

event owners

e1 jack

e2 John

              Smith

THe result above broke the relation between event to owners.

4

Subject: RE: how to connect two multiple values fields

but you did not answer my question. Is this information only used in one document for lookup purposes or is it used in all documents?

5

Subject: RE: how to connect two multiple values fields

sorry, it is used for one document only.

6

Subject: RE: how to connect two multiple values fields

is this a document accessed via a lookup in a workflow process or some other way?

7

Subject: RE: how to connect two multiple values fields

no. these two fields are not used in any view. I am just curious how to group multiple values of a field based on certain criteria.

8

Subject: Could you tolerate this…

event		owners	e1		Jack;John

e2		Smith

if so, turn off the “;” as a MultiValue Seperator and store the data appropriately.