I have a base listing all services made for my clients, in which i put data like the material used, date of service, price, invoice number, etc. There are 12 tables in this base, one for each month. What i want to do is create a 13rd table linked to all the others, grouped by clients in kanban view. So, let’s say i’ve installed a CCTV câmera for Mr. X in january and switched this camera to a modern one in december, those 2 services will be in the specifc tables (Jan/20 and Dec/20) but i want see all services i’ve made for Mr. X in the 13rd table.


Might be an easy one but i’m really struggling with this now.


Thanks for the patience with the bad english, by the way.