Pick list from a hierarchical table

[jesterize]

We have a client that is using the Location field in a hierarchical manner that looks like this:

• Region
• • Physical Address
  • • Floor

Works great until they go to use a Reference in another table. Then, all of the locations get lumped into one big list. I have been trying to figure out how to get just the Physical Address to show. I can do level 1 by looking for records with out a parent, but any thoughts as to how to return just a level 2 and no level 3's?

[Uncle Rob · Accepted solution]

Go to the reference field and add the following attribute:  tree_picker=true
WARNING:  Search won't be as nice anymore, but you'll get the tree picker interface instead of the list view one.