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.