Hello, newb here ;) This is probably the wrong place to ask, but maybe someone could point me in the right direction if that is the case :)
I am pulling data from a mysql database to partially populate a form. This is all done in a 'dialog' which is really slick, so when I open that dialog, i get (please excuse the crude drawings) Dropdown menu [ Chest 1 ] [ Chest 2 ] [ etc... ] That part I have working fine, what I need to do now is make it so that when someone selects Chest_N it will populate the form with say the number of drawers in that chest as each chest may have any number of drawers (within reason of course). The information for each chest, such as mfr, etc. and including the number of drawers is stored in the 'chests' table in mysql like Table: Chests chest_id chest_name chest_color chest_serial chest_num_drawers so when I select a chest in the dropdown, I need to create fields like "Drawer 1 - Drawer N" as text boxes in the form. The mySQL queries I can do as that is super simple, I am just not sure how to make it do the query once a chest is selected. Any help appreciated, and if I am asking in the wrong place, a direction to the proper place to ask would also be appreciated. :) Thanks in advance