Value list of multiple fields from same record

Discussion created by gaijindude on Sep 2, 2016
Latest reply on Sep 2, 2016 by Fabrice Nordmann

I have a db that has hundreds of fields. About 10 of them are addresses for various things. Some of them can be reused in the same record in other address fields, but they should never be visible in other records. I'm trying to get a value list that isn't limited to two fields, but can display all addresses already entered so I can choose from any of the up to 10 unique ones entered so far. I have the self-referring relationship, but how do I get the data from the other address fields to populate the value list? It seems like I did this before, but I can't remember how.