Tables with Text List fields

HCL Domino Domino Forum
1

Hello,

A have a couple of tables each containing several Text List fields.

Is there any way using Views to “combine” the data from these tables for display purposes?

Example:

  1. Table A contains Fiscal Year, Location, Facility ID, and Project Description.

  2. Table B contains Fiscal Year, Location, Facility ID, Tank Details, and Budgeted Cost.

Can I create a view where Table A & B’s Fiscal Year, Location, and Facility ID are the same, then also show columns for Tank Details and Budgeted Cost on that same line?

Hope that example was clear enough.

Thanks

2

Subject: Tables with Text List fields

I had to think about this for a minute as it confused me.

  1. Are you saying one form has two tables? or are you really speaking in relational language and calling a form a table?

  2. Are you saying that you only want the view to display those documents where the values for are the same?

It is really hard to give you an answer without knowing more about your application design.

3

Subject: RE: Tables with Text List fields

So FYA contains “2005” : “2005” : “2006” : “2006”, FIDA contains “f1”:“f2”:“f1”:“f2”, PD contains “descA1”:“descA2”:“descB1”:“descB2”.

FYB contains “2005”:“2006”:“2006”, FIDB contains “f1”:“f1”:“f2”, TD=“details 1”:“details 2”:“details 3”, and BC contains 300:400:500. You want the view to display:

2005 f1 descA1 details1 300

2006 f1 descB1 details2 400

2006 f3 descB2 details3 500

Anyway, the way to do it is to write formulas that will give you a set of list values that correspond to the columns of the above list. So, you could do something like this in a computed field:

@Replace(FYB+“!”+FIDB; FYA+“!”+FIDA; PD)

This gives you a set of fields that contains the data you want to display in the view, in matching order. Now, use the column sorting option display multiple values on separate rows on the column that displays FYB, and sort that column. In the other columns, also use the display on separate rows, but don’t sort them or you will get all the combinations instead of the matching row entries.