Coming from an ESRI background I'm used to ESRI geodatabases (.mdb or .gdb). In those databases, I could create feature classes, tables and relationships between them. Every time I loaded a feature class from one of my geodatabases into a new ArcMap project, relationships were automatically loaded as well: in example, if I loaded a point file which had two related tables, the INFO feature showed me the information coming from the point feature AND from the two related tables.
I'm trying to reproduce this in QGIS. I created a Spatialite database, with the same point feature, added the two tables and created the relationships between them. I then loaded my point file in QGIS, and with the INFO tool I can only retrieve the point info, NOT the related tables too. So I loaded the tables to my QGIS project and manually recreate the relationships.
So my question is: is this the only way to do this? Every time I start a new QGIS project do I have to load the point, the two tables and recreate the relationships?
EDIT: I'm talking about one-to-many relationships, every point has two or more related rows in the related tables