Building Single Row Database Forms with HTML

The INPUT elements and buttons each have an ID. The ID of the Transmitted Table is “TransmittedTable.” The ID of the INPUT element that receives the row position of the recordset is "RowPosition." The ID of the INPUT element that receives the total number of rows is “TNumberRows.” The basic code for the form (as seen by the user) is as follows:

<table id="CT1">

<tr>

<td colspan="2">

<b>Employee Information</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Row <input type="text" id="RowPosition"> of <input type="text" id="TNumberRows">

</td>

</tr>

<tr>

<td width="100">

<br />

ID

</td>

<td>

<br />

<input type="text" id="EI0">

</td>

</tr>

<tr>

<td width="100">

<br />

Name

</td>

<td>

<br />

<input type="text" id="EI1">

</td>

</tr>

<tr>

<td width="100">

<br />

Department

</td>

<td>

<br />

<input type="text" id="EI2">

</td>

</tr>

<tr>

<td width="100">

<br />

Job

</td>

<td>

<br />

<input type="text" id="EI3">

</td>

</tr>

<tr>

<td width="100">

<br />

Years

</td>

<td>

<br />

<input type="text" id="EI4">

</td>

</tr>

<tr>

<td width="100">

<br />

Salary ($)

</td>

<td>

<br />

<input type="text" id="EI5">

</td>

</tr>

<tr>

<td colspan="2">

<br />

<button type="button" id="A1"> Add </button>&nbsp;&nbsp;&nbsp;

<button type="button" id="E1"> Edit </button>&nbsp;&nbsp;&nbsp;

<button type="button" id="D1"> Delete </button>&nbsp;&nbsp;&nbsp;

<button type="button" id="C1"> Clear </button>&nbsp;&nbsp;&nbsp;

<button type="button" id="F1"> Find </button>&nbsp;&nbsp;&nbsp;<br /><br />

<form action="http://databaseSite.com/programFile.exe" method="post">

<button type="button" id="So1"> Sort </button>&nbsp;&nbsp;&nbsp;

<button type="button" id="S1" type="submit"> Save </button>&nbsp;&nbsp;&nbsp;<br /><br />

<button type="button" id="SFA1"> &nbsp;|&lt;&lt;&nbsp; </button>

<button type="button" id="SP1"> &nbsp;&lt;&lt;&nbsp; </button>

<button type="button" id="SN1"> &nbsp;&gt;&gt;&nbsp; </button>

<button type="button" id="SL1"> &nbsp;&gt;&gt;|&nbsp;</button>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

<button type="button" id="Do1" type="submit"> Done </button>

<!-- Transmitted Table -->

<table id="TransmittedTable">

</table>

</form>

</td>

</tr>

</table>