Relation problem

i have a relation problem related to 3 tables as follows:

tour_operator_agent


id

user_id

other details

user


id

person_id

username

password

person


id

name

surname

in the tour operator agent form, i need to display the drop down for user_id as the name and surname from person

anyone can help me out here !?

thanks to revert

I TRIED to use help from this link but in vain :(

http://www.yiiframework.com/doc/guide/1.1/en/database.arr