I want to put a select list (drop down) field in a CCK type.
The select list field will be populated from the taxonomy term the user has used before for that content type.
How to I do that? What kind of CCK field I use?

The easy way is:
1. Collect all the nodes created by user x for content type y
2. Create a list from all the terms used in those nodes.

I think this may be a terrible idea for performance reason.
Please share your ideas and the type of CCK field I should use.
Thanks.