Hello

Here is an example to illustrate my question:

Model A:
date: fields.Date(...)
info1: fields.Char(...)

Model B:
date: fields.Date(...)
value1: fields.Float(...)
flag1: fields.Boolean(...)

I would like to build a list view that provide the following information:

Given that Model A and Model B are two different models.

How could I show the user a "merge" list view of the record of the two models ? I would also like to be able to click a line of the list to reach the record ?

My idea would be to 'build' a 'merge model' that would be filled each time the end user requests to see the list. But how to do so ? SQL request ? Other ? When to build the list ? Should it be stored ?

Could you please advise ?