Can't get superlookup( to work


Using two identical databases, this statement in the primary database:

field «Results field» formulafill superlookup("Target", {«Words2» = ««Words1»»},{«Data to return»},"selected",true(),"wrap",true(),"default","")

… fills every record in Results field with the correct result for the first record in the primary database - every record contains the same result.

Using lookup( terminology, Words2 is the keyfield in the Target database and Words1 is the keydata in the primary database.

Am I doing something wrong or is the function broken?

Problem changing formulafill Lookups to Superlookups

A little clarification - if both databases are sorted up, it gets the incorrect result in 2 seconds. If they are randomly sorted, it takes 10 minutes to get the same result.


My guess would be that the problem is issue #703. And before you say “but I am not using grabdata(”, you actually are, that is how the double chevron feature works.


I’ll check that out tomorrow. Thanks Jim.


So does this mean that superlookup( is off the menu?


It means that grabdata(, and double chevron notation, is off the table in formulafill, select, and any other statement where a formula is repeatedly evaluated over and over again for each record in the database. That certainly does limit the scope of the superlookup( statement when used with these statements.