Adding Dropdown to Exisiting Insert Record page
I have a insert record already in place for a website i created with webAssist. My client would like to add a category dropdown box on the insert & update record page.
I already have the recordset populating the dropdown box (form the categories Table) and the field in the Database but when i sumbit the record to be added to the database nothing gets add to the field. My column name in the database is categoryName and it is set to varchar (255).
When i open the Insert Record Wizard I see the category Column - Type is set to text - value is set to <?php echo((isset($_POST["category"]))?$_POST["category"]:"") ?>
I would like the actual name to insert into the CategoryName Column - not the id
I need to set the same for the update page.