title: Qt how to present and edit data across tables
body: <p>Please bear with me as this is a slightly subjective matter but I'm after informed best practice for what is likely a common situation.</p>
  
  <p>I have data split out into multiple (sqlite) tables which I am using Qt to manipulate. A (sql) view is one way to show data from multiple tables, but I wish to be able to update values as well.
  Let's take a three table example, using say houses. 
  The three tables are linked via foreign keys, say an Area table, a House table, and a Furniture table. There's a 1:many relationship linked with foreign keys: Area:House, House:Furniture
  I would like to have a UI item with Areas populate a House UI item which in turn populates a Furniture UI item. By UI item, I mean something like an editable list, or series of lineEdits/Spinners (value type dependant), anything really.</p>
  
  <p>just to clarify a bit, i understand about how to use qsqlrelationaltablemodel and qsqlrelationdelegate. These work fine when I'm updating a single table, but won't update a (sql) view created from joins on multiple tables.
  I'm after a solution that lets me efficiently work on data from multiple tables, including updating the values.</p>
  
  <p>Should I do this with three models, updating the filter on each, and using a view linked to each model? 
  Or perhaps I could insert everything into a single tree model? 
  Or should I be looking at creating a custom model, or perhaps just not using model/view and manually populating UI?</p>
  
  <p>I have tried using multiple models on the same database as an experiment a while ago, and they didn't behave together as nicely as I'd hoped. This is the main reason I'm asking about best practice.</p>
  
  <p>Much appreciation for any advice you can offer.</p>