i want to lookup data based on the id field but i want the list to display the name field. the view for id and name is same. do i need to use @dblookup or @dbcolumn??
Subject: @dblookup or @dbcolumn problem
From the help:
@DbLookup (Domino data source)
Given a key value, looks in the specified view (or folder) and finds all documents containing the key value in the first sorted column within the view. For each selected document, @DbLookup returns either the contents of a specified column in the view, or the contents of a specified field.
@DbColumn (Domino data source)
Returns a column of values from a view or folder in a Domino database.
So now you know which one to use.