livecycle odbc data connection

[alexh50422708]

I'm trying to find a way ,with a populated dropdown list which will populate several textfields with information that was retrieved from the database based on the information entered into the Dropdownlist.  I just want to choose a Product from the dropdown,  retrieve data from the database base  and display one column of retrieved info on the form.The current problem is that when i choose something from the dropdown list(connected to database) that the informations in the other textfields doesnt change .

I appreciate your help...