Alternative for lookupall()


it is my first request for help after I tried everything but could not find a solution.

I have 2 databases: Persons and Venues. A person can be assigned to more than one venue, therfore I have in the Persons DB a column Venues. In another column I would like to add the Venue-IDs, to be found in the Venues DB.

The lookup formula I created is

This does not work, because the given fields are in the wrong database. Is there another similar formula I could use in this case?
Thanks a lot in advance,

Have a look in Panorama X’s Help menu: The Relational Workshop is your friend and will assist you in setting up your lookup formula correctly.