Need Value List from Calc Field
I have a calc field (Carga), and I need to create a drop down value list to be used in a different field...and I need this value list to contain the values from my calc field. FM yells at me and tells me that I can't create a value list from a calc field. So, as an attempted workaround, I created a second field (CargaCopy) that is a text field with a calculated auto-enter result, and copied the calc from Carga into this CargaCopy.
CargaCopy is not indexed, but it does not update if Carga updates. So, my value list does not stay accurate. Help.