choice field in table - where is this data stored

[hildasteyn]

Hi Guys

One of the fields in my table is choice and I typed in the list of choices. I thought it would automatically create a second table containing the choices, but I don't see this among my tables. Where is the data of the choice stored? 

[Mira_Ghaly · Accepted solution]

@hildasteyn 

If you want to have a list of data stored in another table then you need a column of type lookup.

The choice is stored in a metadata tables that you won't be able to access but you can change the values through the UI.

[hildasteyn]

Thank you so much. That was a fast, straight answer and it cleared it all up. Much appreciated.