---
title: "using lookup tables in Collect (-Mobile)"
url: "https://openforis.support/questions/1625/using-lookup-tables-in-collect-mobile"
tags: ["collectmobile"]
status: "answered"
score: 0
answer_count: 1
asked: "2018-02-05T14:58:34"
last_activity: "2018-02-06T09:53:53"
source: "Open Foris Support - Q&A Forum"
license: "Copyright Open Foris, 2026. Some rights reserved under creative commons license."
---

# using lookup tables in Collect (-Mobile)

Asked by Fehrmann on 2018-02-05

Dear all, 
Just a general question: in the idm documentation there is a reference to the use of lookup tables (idm:lookup), which ca be used to retrive values from my_custom_table (a table that is referenced). This seems to work similar to the sampling point list, from which we can query information for each sampling point. Question: where do I put my_custom_table to acesss it? AND: is it possible to use lookup tables with Collect Mobile?

Thanks,
Lutz


## Answer (score 0, by Stefano (OF) on 2018-02-06)

Link: https://openforis.support/questions/1625/using-lookup-tables-in-collect-mobile/1627

Dear Lutz,  
Using the lookup tables in Collect Mobile is possible but it's a bit tricky, you should modify the file .collect-mobile exported from the Survey Designer and include the lookup table in the SQLite database file included in that file.  
Usually it's not necessary to use external tables in the 99% of cases; you should be able to put all the reference data into code lists. What do you need them for?  
If you want we can provide you our support in this, we will contact you to your private email.  
Many thanks,  
Open Foris Team
