Multiple unique ID's per customer question

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

Self-hosted

What do you need help with?

I touched on this question awhile ago, forgive me for being redundant, but have not found workable solution.
Scenario:
Customer vehicle data is being imported to Baserow where VIN number is “Primary Field” (pic-1)
Problem:
Since some “Car Owners” might own several vehicles, having separate record row for each vehicle would create multiple mailings or address updates for the same “Car Owner”.
Desired solution:
Able to have a table that has “Car Owner” as a primary field and their vehicles listed under that owners record in the row (as per pic-2).
To reiterate: pic-1 is the way data is being imported, pic-2 is the table we would like to have created from that data automatically (preferred), making “Car Owner” as a single point of contact for direct mail, inbound calls or address updates etc.
Thankful for any advise.

Please attach screenshots or videos if they help illustrate your question.


Why isn’t this solution working for you? Database modeling - using unique identifier to auto populate second table - #2 by frederikdc.

Just so we can understand the situation better. :slightly_smiling_face:

Solution described would work if you have database of records that is not being updated (or at least not frequently). But when you import a few hundred new records daily it becomes maybe too time consuming to repeat the same steps for each new dataset.
I have tried to play with n8n integration, but could not have that automation working myself (lack of skill).
I repeated my question on this scenario hoping that Baserow might have introduced some new feature that I missed as it’s being advanced pretty rapidly I would say.
As always thank you for great product and your help.

@joffcom do you know if there are any n8n templates or guides to help build this scenario? Database modeling - using unique identifier to auto populate second table - #2 by frederikdc

Oh no I missed this one, sorry.

No templates at the moment but if sounds like a find one to try and build