OK, so I have the db built like this now... and I am now building the forms for submitting the data, this is where I am stuck now...

I am using php and mysql...

I understand how to join the tables when doing the select statement, but I am confused on how to properly build the form to enter the data...

Like I said, I want to use one form where the user can enter the following:

The name of the Poem
The actual content of the Poem
The Author of the Poem
The Book that contains the Poem

Obviously I would need to query the db to see if any of these elements exist, and then determine if the poem is not a duplicate (based on a combo of the Poem title and Author) and in cases where it is a recurring author or book I would show the existing data in a drop-down list, and allow input for the remaining fields...

So, having said all that, I guess the big question is how do I build the SQL INSERT statement to properly submit the data across the three tables?

Thanks!!