Create Conditional Value List With Self Realtionship?
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.