Lookup from one table to another table on different APP

Question

Looking for ideas if I can lookup information from one APP table to another.&nbsp; Have field service app and would like to be able to pull info from our other APP that has tables to the project.&nbsp; ie; be able to look up the Project name/number from a different APP used for daily reports.&nbsp; Thanks in advance

kevino_boyle · Answer

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.

quickbasecoachd · Answer

The other approach is across app relationship.

Start at the child side and when you make it will initially block you until you go to the Parent App and App properties and allow your child p to make a relationship. Do you may as well do that first.

But then you go to the child table and make the relationship and choose � from another app� as the parent and follow the prompts.

kevino_boyle · Answer

I've been told by quickbase that when you build cross-app relationships, it brings the two apps into the same server process - and with single-threading this will adversely impact performance of both apps.&nbsp; I've experienced this which is why I recommended the above - I don't know the size of the apps Glenn is referring to so it may not be an issue for him&nbsp;

quickbasecoachd · Answer

Kevin,Yes, that is a valid consideration.

glennsoden · Answer

Thanks for the input.&nbsp; Were evaluating this as replacement to our existing CRM.&nbsp; Though in the learning curve I like to find limitations and try to break things ;-)&nbsp; and we currently have many related objects because of field limitations.&nbsp; Another option (not sure if will work) is take this other application and just create a new table on existing APP, which brings up new question -&nbsp; can you copy all of an APPS fields etc into a table or is this a "recreation

Forum Discussion

Lookup from one table to another table on different APP

Related Content

Lookup Field not pulling Data

Pipelines: Lookup newest record?

Moving Fields from One Table to Another

Add button to create record in different app

Lookup Field Not Pulling Data