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