Hello, I may be asking too much but shooting for it anyhow. I have obtained each of these goals separately but I cannot find a way to do them all. When I change the configuration to accommodate another requirement it looses a function elsewhere.
I need to be able to:
- Have a single drop down with combined lists: (I have this setup)
a. Suggested Values: Custom.Locations[Location Name]+Locations[Location Name] (produces list and allows "Add to custom location" but not "Use", allow other values is selected.
b. Problem: Can't Dereference items from the added locations table . (could use lookup instead of dereference for all?) - Dereference the selected location to obtain Lat/Long, etc :
a: Works w/ the references list, Doesn't with the added list, shows broken links (yellow triangle) - Add a new location to the custom locations table: (this works, listing only as a need)
- Use entered Text instead of adding or selecting from the list.
b. (works when the column type is text, not when it is enum even w/ the option selected)
Table 1 (Custom Locations) + Table 2 (Locations)
Dropdown: Shows search only, no "add" or "use", breaks referenced links w/ the added list

Please let me know what additional info you may need. Thank you in advance for all of your help