create form insert/action page

Hi,

I’ve set up a custom template page which allows me to pull data from a custom table I created in wordPress database. This information is used to populate a form select element.

The form has 4 other text fields. I would like to insert the data on submit into one of my custom tables but I’ve had no luck yet.

My custom template form and action pages are both located in my theme folder.

On the form page I have to give the path from the wp root to the action page rather than just referencing the file relatively, otherwise I get a file not found error.
IE:
WP able to find action page:
<form action=”/wordpress/wp-content/themes/myTheme/insertAction.php method=”post”>

WP unable to find action page (eventhough both are in the same directory):
<form action=”insertAction.php method=”post”>

That’s curious to me. I don’t understand why it searches from the WordPress root and doesn’t look in the same directory as the form file.

Anyway…my long winded question is, What is the best method for creating a custom form that inserts into a custom table using a custom template?

Thanks!

John