https://www.machform.com/forums/ MachForm Community Forums Topic: Dropdown Data in SQL en Wed, 06 May 2026 17:49:31 +0000 https://www.machform.com/forums/topic/dropdown-data-in-sql#post-2824 Tue, 02 Sep 2008 17:10:50 +0000 yuniar 2824@https://www.machform.com/forums/ <p>Hello Fred,</p> <p>I'm afraid it won't be possible to change the way MachForm stores the values for dropdown.<br /> MachForm uses relational tables to save database space and easy maintenance.</p> <p>To be able displaying the values for your dropdown, you need to lookup into <strong>ap_element_options</strong> table too.</p> <p>So you need to create a JOIN query between that table and your particular form table.<br /> Is that tool allows you to generate the code based on query?</p> <p>Some posts regarding this:<br /> <a href="http://www.appnitro.com/forums/topic/mysql-question?replies=5" rel="nofollow">http://www.appnitro.com/forums/topic/mysql-question?replies=5</a><br /> <a href="http://www.appnitro.com/forums/topic/drop-downs-and-mysql?replies=11" rel="nofollow">http://www.appnitro.com/forums/topic/drop-downs-and-mysql?replies=11</a> </p> https://www.machform.com/forums/topic/dropdown-data-in-sql#post-2822 Tue, 02 Sep 2008 12:58:19 +0000 fredwin 2822@https://www.machform.com/forums/ <p>Hi<br /> Is there a way to change the way the data is stored in the data base for dropdowns?</p> <p>That is I am using:<br /> <a href="http://www.sqlmaestro.com/products/mysql/phpgenerator/" rel="nofollow">http://www.sqlmaestro.com/products/mysql/phpgenerator/</a><br /> to create a viewable log of entries from a from, and at the moment the data comes back as a number (representing the option chosen), but I need the text name to come accross.</p> <p>Hope this makes sense.</p> <p>Fred </p>