Thank you, superboyac and Armando, and all contributors here! It was a long thread, but it broke the ice of my understanding about how this program works. And thank you, PPL, for all your posts here. I hope you are still around and reading - I'd prefer to post here for now but let me know if you want me to cross-post onto your forum.
I'm more than curious to try SQLNotes but I'd like to understand just a little better how it can play as a relational database. The reason I ask is that although I'm no expert, I have used Access and HanDBase before, both of which are relational, and I know how to go about creating fields and items in that kind of structure. I just can't get my head around how that translates to SQLNotes. I'm going to play with a few items and fields and grids, but if anyone has already been through this thought process and can give me some pertinent metaphors or examples, I'd be really grateful.
An example of the "relational" sort of thing I would want to use it for is a historical work database for my singing gigs (to help me remember what I've done!). I would be listing jobs, singers, conductors, venues, dates of performances, works performed etc. Any given singer might have performed in any number of jobs with me, any work might have been performed in any number of jobs, any job might have many works performed and even more than one conductor, and a work would have a composer and might have other properties such as translation or edition.
I've been seriously considering using a wiki for this, but although I love wikis I find them a bit slow and/or clunky, and even in the clever Wikidpad, where it's possible to auto-extract lists of "items" with certain "fields", I would have to learn some python (a lot for a beginner like me!) to generate useful lists and views. I considered a serious database solution but HanDBase on the desktop has a horrible GUI and I try to avoid MSOffice as much as possible. I have a feeling SQLNotes would be ideal here.
I have various lists and spreadsheets dotted around (in Excel, in PhatNotes, in an old Wikidpad, and in Outlook) that I would love to consolidate. I've procrastinated the consolidation (and the historical work database) because I imagined I could find something sophisticated enough but also syncable with palm/windows mobile, but I find that more and more I use my handheld as a static device, to which I write information, but on which I edit very little. So now I'm after something that works best for me on the desktop but which can export to readable formats like HTML or to spreadsheets.