Muliple value for a group of field

HCL Domino Domino Forum
1

In one of our application we have to keep following fields:

Empno, Emp Dept, Emp Name

In one document there can be one employee detail or may be 5 ,10,15 employee detail.

What could be the various ways of doing it. We do not want to define 15 into 3 fields that will unnecessarily make the design complex.

Later on we want to give views like

Employee dept wise Employee name for all documents in database

Or how many times a emp no/emp name is appearing in the database.

An early reply will be appreciated.

Thanks

2

Subject: RE: Muliple value for a group of field

This download contains tools for editing information in tables.

You should be able to match data from the different fields into separate view rows using the view option “show multiple values in separate rows” (something like that), or by using category formulas such as:

EmpDept + “\” + EmpNo

which would let you use totals. I want to caution you, though, it tends to not be a really good idea to store the same employee information in multiple documents, because then you have to come up with ways to kep the different documents in sync.