Good advice, I have received a few more suggestions and will make some changes on next build.

The problem I see with using netbeans to create the database, it sure makes it difficult to change things after the fact without messing up the indexes!

Well, wha... Login to read more.