Look up value using form textbox from external custom mysql database

Hi everyone

i have a mysql database 'parts' with table 'stock' which is not the joget JWDB server. i have pulled the data from the stock table, which contains stock_code, description, location and cost to a datalist. so everything is working

i need to create a from that the user can type the stock_code number which will query the 'parts' database for the description, location and cost in the same form in 3 other textboxes. how do i populate these text boxes.

for testing -i have tried using selectboxs to get each field individually. for this purpose how do i make them cascading select boxes?  this will possibly allow me to follow the same logic

is there any method of using a Datalist as selectbox options

any help towards the correct direction is highly appreciated.

regards 

DR