Hi all, I have a drop down box which calls the info from a table and lists it in the drop down box. Now I want a few text fields to display the other info relevant to the info that the user has selected from the drop down list to be shown in the text fields.<BR><BR>So for instance, if i go to my drop down list. I select a person from the drop down list. In the rest of the SQL's databases table there is other info about that person. Then this other info is then displayed in those text fields. <BR><BR>I am just stuck on creating a process for this, thanks guyz.