Noob needs help making Form from another table

[segyn]

Okay i'm using access and php and apache I have to use access because that is what the company has been using and they won't switch to an sql server.

 

Any way I have to use an odbc connection I have created my form to input into a table.

My database is being used for keeping track of all the production tools. I have made A department table in the database.  I guess what i am asking is I have to use Department table in multiple forms.

 

Can any one help me on how to get a drop down menu from the table departments into a form i'm creating for new tools. I hope this makes sense.  ???

 

this is my form but for departments i want it to be a drop down menu from the table Departments in my database. Pls help.

 

 

<form action="NewIron.php" method="post">

<td>SI No:<td> <input type="text" name="SiNo" >

</tr><br>

<tr>

<td>Watts:

<td> <input type="text" name="Watts">

</tr><br>

<tr>

<td>Department:

<td> <input type="text" name="Dept" >

</tr><br>

<tr>

<td>Status:

<td> <input type="text" name="Status" >

</tr><br>

<tr>

<td>Notes:

<td> <input type="text" name="Notes" >

</tr><br>

<tr align="center">

<td><input type=submit Name=submit Value="Submit">

<td><INPUT TYPE=RESET NAME=RESET VALUE="Reset" ></tr></table>

</form>

 

[segyn]

just wanted to add keep in mind i am using a dsn name with odbc not a mysql server. Thanks