I am attempting to create a dialog list that performs a @dbcolumn lookup to our contact management system, but if I try to pull the entire names column I get an error that the amount of data exceeds the memory space for the field.
“The specified database lookup generated more than 65,000 bytes of results, which is too large for Notes to handle in this context.”
Is there a way to run the dbcolumn but only pull certain data based on a variable selection?
For example, grab all the last names in the column, but only show the ones that start with an “A” in the dialog list.
Note: I really do not want to have to create a last name lookup view for every letter of the alphabet to facilitate this lookup.