copy a column and it's properties

[seiky]

hello,
I wanted to know how to copy a column and it's properties by programming (VBA-SQL).
I have a column that has a list of values, and want to duplicate it (with another name).The new column should have the same list of values.

thanks for reading.
Seiky

 

[seiky]

I'll give more description.
I have a field, its dataType is text, and its display look is a combobox. It has some values in its row source. I want to create a new field with the same properties, I mean the same display control (combobox) and the same row source.

I attached a file with this message, what I want is to create by programming a new field called field3, with the same properties as field1 and field2.

Seiky