Does somebody know how can I do join in view (for example: natural join, full join)?
For example I have two forms:
Client: and here I have one field “C_Surname”
Worker: and here I have one field “W_Surname”
and now, I want to have a view, where are two columns: clients_surnames and workers_surnames.
And for each client I want to have number of rows equal the number of workers.
Example:
C_Surname: (“Smith”, “Jones”)
W_Surname: (“Anderson”, “Neo”, “Einstein”)
and my view:
C_Sur | W_Sur
Smith | Anderson
Smith | Neo
Smith | Einstein
Jones | Anderson
Jones | Neo
Jones | Einstein
I am waiting and hope that somebody can help me. Thanks
Krzysiek
Subject: There’s no easy way out …
There’s no such thing in Notes as ‘Joining tables’. (There’s no such thing as ‘tables’ to start with)
There are different solutions :
You have to copy all information in one kind of document. For example, you copy all the needed client names in the worker documents. If there are a lot of documents, this can grow the db significantly, but afterwards it’s fast. For most applications this works fine.
You create new documents ‘on the fly’ with the needed fields in it, and then put them in a folder. You can delete these documents when no longer needed. If there’s a big number of documents, this can be slow…
If there are really many many documents, and performance is important, you should consider to place this information in an external databse and connect to it through ODBC, LEI or wathever …
There’s really no way to show the information of two or more documents in one line in a view
Subject: RE: There’s no easy way out …
Thank you very much indeed, but I have another question… I am new in Lotus and I don’t know to much about that. Can you tell me how exactly should I do this? I think that the second of possibilities is the best.
Thanks a lot
Krzysiek
Subject: RE: There’s no easy way out …
If you’re new to Notes and the Domino Object Model, then it’s not possible to me to give you detailled information … I can give you this tip:
Download this redbook : http://publib-b.boulder.ibm.com/redbooks.nsf/RedbookAbstracts/sg246854.html?Open
It’s an excellent book (and free) to get you on the road