Advanced Queries - Query Lookup
Use this form to choose the standard (link) tables and field names, the custom (lookup) table and field names and the field to be displayed.
- Use defined table relationship - you can use this option to choose an existing table relationship from the list
- Configure the relationship manually - or use this option to configure it manually