On 2015-03-07 10:32 PM, Dave wrote: > Ryan, > Thanks for your reply. As I mention in my last post: > > I got it sorted out I ended up with this using my SQLite Expert > Professional (if it matters).
There are a lot of great tools available for SQLite (possibly moreso than any other DB system because of the open nature and myriad of ways it can be used) and SQLitexpert is a favourite of mine too - but the tool never matters, only the SQL. > But I will keep this info for testing to see if it does the same thing > or can help me in the future. I tried to learn DB with ACCESS years > ago and never really fully understood it. I would get stuck on the > relationship part with the keys and the visual flow charts always > seemed to point from one table to another but the lines pointed to an > item instead of an ID. Or so it looked like that to me. Never really > got to use it back then. You and us both, you first have to understand relational DB design before using the arrows and blocks become sensible in any meaningful way. > Now I am starting over again with SQLite. And I have made some > progress, but have a long way to go. Good thing for me is I plan to > use my database (for now) as basically a "flat file" where my app will > just use the related data in click events to further process. May I suggest checking out http://www.w3schools.com/sql/sql_intro.asp Other resources are available too, but working through the very simple lessons and great examples there will switch all the lights on for you - without a single arrow being drawn. Good luck!
