Simple ColdFusion Form <p>This is for a simple submit into a database. I have two tables. One is called "Authors", while the other is called "corpPosts".</p> <p>The Form consist of a Title, and a Body value that will be inserted as a new entry into the corpPosts Table.</p> <p>The form also consists of a drop down box which collects values from the Authors table. The user clicks the designated author to decide who posted the blog.</p> <p>Once the form is submitted, it Creates a new record in the corpPosts Table, inserting the Title, Body, as well as the author into the corpposts table. The Author in the corppost table is represented by "UserID".</p> <p>I do not remember how to associate the AuthorName to the UserID however. I know this is a relatively simple query.</p> <pre><code>&lt;cfform action="AddCorp.cfm" method="post"&gt; &lt;cfinput type="text" reqired="yes" name="Title" id="Title"&gt; &lt;textarea style="width: 1000px; height: 600px;" name="CorpBody" id="Body"&gt;&lt;/textarea&gt; &lt;select Name="SelectAuthor"&gt; &lt;!--- Queries ---&gt; &lt;cfquery name="Authors" datasource="corpposts"&gt; SELECT Name FROM Authors &lt;/cfquery&gt; &lt;cfoutput QUERY="Authors"&gt;&lt;option&gt;#Name#&lt;/option&gt;&lt;/cfoutput&gt; &lt;/select&gt; &lt;cfinput type="Submit" name="Submit" id="Submit" value="Submit"&gt; &lt;/cfform&gt; </code></pre> <p>On the Next Page:</p> <pre><code>&lt;!--- Query to Insert ---&gt; &lt;CFQUERY name="AddPosts" datasource="corpposts"&gt; INSERT INTO CorpPosts (Title, CorpBody, UserID) VALUES ('#Form.Title#', '#Form.CorpBody#', '#Form.UserID#') &lt;/CFQUERY&gt; </code></pre>