This is probably really basic, but I can’t figure the Topic (above) out. I want to use “lookup” to retrieve information from another data base (“Friends”) in a form in database “Assets”. Both databases are open, and in the Formula Workshop the expression
lookup(“Friends”,“ID”,“3”,“First”) works just fine, and retrieves the expected result…
But in a form in the Assets database, the same function in a Text Display just shows the expression, not the results.
Once I (actually, you) solve that, I would like to replace the value “3” in the example above with a value in the fields “GoesTo” in the Friends database.
Help, please!