DBLookup - use in a column on a view

[suzey]

Hi All,

I have a column in a view that I would like to do a DBLookup to another view in the same database, based on another field in the view

In the help files, it says :

'This function does not work in column or selection formulas, or in mail agents.'

I am a bit of a novice at development and wondered if there was a way I can use this formula and return the value to the view, or alternatively is there a different function I can use to lookup this value.

Thanks in advance



Sue

 

[DerStephan]

Hi sue,

try using a hidden Field (computed) in the Document that does the lookup and in the view you just show this field.

Regards

Stephan

 

[suzey]

Thanks Stephen,

Unfortunately, this database is inherited/externally owned and created and I don't really want to change the design of any of the forms/documents, as this may be affected if the external company make changes in the future.

I am therefore creating new views.

Any other suggestions.



Sue