Alternative for lookupall()

Hi,

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
lookupall(“Venues”,
«Venue»,
«Venues»,
«Venue-ID»,
“,”
)

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,
Ralf

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.