convert results to lookup table

[Guest]

I would like to convert the date in a field in a database to become a lookup
table for the same database linked to that field. I would like to do it in a
way that wouldn't loose my data associated with that record?

 

[Guest]

A whole lot of folks will tell you not to use a lookup table.

What I do is create a query the feeds a bound list box or combo box on my
form.

 

[Guest]

I apprecieate the sugestion and I will heed your advice, out of curiosity why
would that be a better way? I am assuming that you just use your query in the
lookup property of the field?

Thanks again for your help.