Hello,
This might be a bit of a strange thing to want to do, but hoping someone can help me find a solution.
I have a large dataset, with a field called 'Food'. There are hundreds of different values in this field, but one in particular called 'Fruit'.
What I would like to do, is rename the value 'Fruit', but with lots of different names:
- Apples
- Pears
- Bananas
- Mangos
- Raspberries
- Kiwis
So, if I created a list box for 'Food', among the other values I would have the 6 fruits above listed (but not the original value 'Fruit').
I would like each of these new values to behave in the same way, and have the same associations as the original value.
Anyone have any ideas?
Many thanks,
Jess
