Table with multiple 1 to many relations

I have a table named [Brand] and several tables named [Brand@@@Models], one for each field in the Brand table.

I want each field from the [Brand] table to be related to it's specific Model table. I thought like that so I don't have a Brand#1 related to Brand#2 models, etc.. I didn't want to have all the models for all the brands in a single table, was I right to think like this?



What's the correct way to do what I want to achieve? I can't seem to make it work like I want.



Thanks a lot to everybody taking the time to read this!

Table with multiple 1 to many relations