Linking records from various tables in just one

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.

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.