Newbie SQLite and LC learing problems

[Blair Lewis]

I'm new to LC and am I am looking for help with using DB's with LC. I am coming from Filemaker and I am unable to find a decent tutorial on how to use SQLite that is either complete or useful.

Does anyone have a sample stack and DB that I can pull apart to learn. I'm particularly having difficulty with creating relationships for creating and retrieving data combining multiple tables. Something about lastrow ID keeps coming up but I'm a little lost

Blair