>>Arnon
>I will do that. I want to know what's the best method to do it in terms of efficency and easyness (if you can have both). Is it effective in terms of speed, will it work well with 10,000 record or more?. Thank you for your help.

what do you mean by 10000 records?
do you want to view 10,000 records in the combo
(if so I would use a grid rather than a combo)
or do you want to create a view as a subset from 10,000 records (in which case it is ok as a view is very much like a regular SELECT SQL )

Arnon