Lookup Error

[Guest_imported]

I get an error every time we try to do a lookup.

"The specified database loookup generated more than 65,000 bytes of results, which is too large for Notes to handle in this context."


Anyone know how to fix this?


Thanks,

Jack

 

[spa77]

I don't believe there is any way or rectifying this issue, but I have used a 'workaround' in the past. I have actually used up to 4 separate dblookups and then concatenated the results back in a formula. The only other way is to work out whether you really need ALL the data being collected - if not, modify your lookup so that only the required information is returned.