Collector - Create Dropdown menu from table of addresses?

Question

I need to field verify 400+ addresses and collect data at each.  I would like to create a drop down menu of all my addresses as I have them listed in my database so I can maintain IDs and data continuity.  Is there a way to populate a collector drop down list for a large number of options from a table without entering each manually when setting up my geo-database domains?  (e.g. I want to make sure I use "645-647 Main Street" as I have in my database instead of "645 Main Street" as it might appear on the building address plate).

Anonymous User · Answer

We do periodic inspections at our facilities. I ended up creating a relationship between our facilities feature and our inspections feature. So when I look up my facility I can see all the inspections done for the facility. This would work well for you since you since you already have a table with all the addresses and IDs. Some more information on relationships. https://blogs.esri.com/esri/arcgis/2015/02/18/related-tables-exploring-new-ways-to-use-collector-for-arcgis/

But you could also manually do a domain setup. Here's a good writeup from ESRI for domains..

Prepare your data in ArcGIS for Desktop—Collector for ArcGIS | ArcGIS

Good luck!

RandyBurton · Answer

Once you get your addresses into a domain, you may want to use the Sort Domain tool to better organize the domain.  You can sort by codes or by descriptions.

NoahWasserman · Answer

We have a lot of multiple address buildings that are screwing up our survey/database so I want to make sure the address/building ID is exactly what we have in our database when we field verify.  We will test your recommendation and see if 400+ is too much.  Thank you!