Problem with @dbcolumn & @dblookup

HCL Domino Domino Forum
1

Hi all , I have two different application that is working on the web .

First application when it raises it will form a unique request number .

on the basis of this unique number i need to display the data in another application . its also working but i want it more user friendly that when user selects the number only those details will displayed not the all details will pop and he has to select from them .

what happening right now whatever request is closed byme that all number is going to display and accordignly the details . its quite confusing to the user . so iwant that when the no. selected only particular details will come others will not.

for that i had also created a view for those details and using @dbcolumn .

second thing is rich text should display in view .

if i want to display details from rich text what i have to do .

and one more thing if the first application is not yet closed and i want to display data will it be possible .

2

Subject: RE: Problem with @dbcolumn & @dblookup

You can not show contents from a rich text field using a view.

Peter Närlund

ProductManager DomainPatrol

http://domainpatrol.org

3

Subject: Problem with @dbcolumn & @dblookup

Assuming both your applications are Lotus Notes databases, look at using an embedded view with a single category to display the values from the second db dependant on the key chosen on the first.

For rich text in a view you’ll need another field on the form computed text using @abstract(richtextfield), to get the basic text of the rich text field which you can display in a view. It’s not perfect, as the formatting is lost.

Dan