AnsweredAssumed Answered

Create Conditional Value List With Self Realtionship?

Question asked by Krilith on Jan 10, 2014
Latest reply on Jan 11, 2014 by philmodjunk

Title

Create Conditional Value List With Self Realtionship?

Post

     So here is my trouble,

     I have a list of records (locations) with a location type field consisting of Type1, Type2, and Type3.  Each record will also have a location based on its type. Currently my value list shows every record. I need to filter it to only show applicable locations for each location type.

     If Type1 list Type1 

     If Type2 list Type1

     If Type3 list Type1 and Type2.

     I'm trying to avoid separate tables for each location type, since all fields are identical, and many other tables reference this table for their location.

     Any thoughts would be greatly appreciated.

Outcomes