Using Lotus Notes Problem and Clarification

Asked By jakob 10 points N/A Posted on - 11/01/2011

Good day.

Can you please help me with my problem.

I would like to take value from a sheet and create an index based a table of contents. I have an imported table of contents that listed with multiple departments and their page numbers in column A and B are.

Department – Page

Finance – 1

Finance – 2

Finance – 3

Finance – 25

Finance – 60

I want to return only one department from multiple pages just as an index work.

Department Page

Finance 1,3, 25, 60

Thanks

• Status: Open
• Question Views: 817
• Answer Count: 1
• Vote Up 1 Vote Down

• Answer Accepted: No
• Question Category: Misc Software

Answered By Michelle Bang 55 points N/A #98950

Using Lotus Notes Problem and Clarification

You can only do this if the field is allowed to save more than 2 values in it.

Therefore first you must have to see if it is really possible in your situation.

The values that you are trying to save our the comma separated values like for 1 finance department the pages are more than 1.

So you can perform the following steps to achieve a good idea on how to tackle it.

1. Make a table with the department information in it.
2. Now make a second table with the pages and department numbers on each page.
3. Make a joint in between these two tables.
4. Display them by using SELECT from departments,pages and select the required department and page to be displayed.

About Michelle Bang

Questions
2

Answers
515

Best Answers
73

• Vote Up 0 Vote Down

• Posted on - 02/12/2012
• Question Category: Misc Software