OK, PPL, I finally got a chance to try out your program. By the way, thanks for the wiki, it's very helpful.
I'm giving up on the basketball one and trying something more simple and useful for myself, as a beginner. What I want to do is create my own database for my favorite music/albums. They will have my personal comments/reviews associated with each entry. So far, here is the layout of my database, as far as the fields:
--Notes (I just used the default SQL field for this one)
So, for each item, I will have a review of it associated with it. However, I have a question. Should I write my review in the Notes field, or in the HTML pane? I'm leaning on doing it in the HTML pane to take advantage of the formatting options. Besides, it's too hard to control paragraphs and multiple lines in a regular field, because if you press Enter, it doesn't start a new line, but assumes you're finishing the editing (like a spreadsheet). The only thing I'm worried about is what is the property of the HTML pane? Is it considered a specialized field? Or is it something else? If I wanted to export the database to excel or something, would the html content be associated with the item, like the other fields would be?
Anyway, I'm pretty sure writing the reviews in the HTML pane is the way to go, but I wanted to make sure.