Look-up / Find records from other table

Discussion created by Karel on Feb 17, 2018
Latest reply on Feb 17, 2018 by kilyaaan

I try to make a new database, where certain fields can be found in an other external database. So I make a related database with table one: my new items, and table two: available items in other (exgernal) database.

The referencefield is: prename. It works!
But: if there are two people with the same prename the result is zero. I need an option of selecting either of the two options. What to do?

A script? A global field? Help me with solutions please.