Hi!

so I am trying to design a relational database and I think I am on the right track, but I am a little confused as to how I will actually update the data...

Normally I build a flat file table and use a web form to add/update/delete data, however, I am trying to build a larger database and this is no longer practical...

This is still not too complex, I think I can accomplish what I want with three tables...

Here is what I have so far:

tbl_Poems:
- poem-ID - pk
- Poem-Title
- Poem
- Author-ID - fk
- Book-ID - fk

tbl_Author:
- Author-ID - pk
- Author-Name

tbl_Book:
- Book-ID - pk
- Book-Name

Obviously I want to create a database containing poems. On the website the user can read the poem. I want them to be able to search by Poem, Author, or Book.

So if this is the proper database design how do I actually input the data using only 1 form?

If this is not correct can someone help me design the tables better and instruct me on how to make this updateable using only 1 form?

Any input or help is really appreciated!

thanks!