Lookup from one table to another table on different APP

The simplest approach may be using Quickbase sync tables across apps, then building your relationship. Depending on what info you are trying to bring across, you can even total the information first in a parent table then sync the parent table. We total the # of open cases per sales rep in our case management app, then sync that table into our CRM to use as a lookup field.