I am working on a Macintosh and cannot open Microsoft Access files. I cannot give you specifics matching the column names exactly, but the Idea here is that you are creating a linking table to relate the sizes in the Size table to the models in the model table.
the linking table will use the primary key columns from the model and size tables to create the relationships.
in your model table you have:
modelID | ModelName
1 | KES35
lets say the size table has the following sizes:
SizeID | SizeName
1 | 12" (30CM)
2 | 14" (35 CM)
3 | 16" (40CM)
the records in the modelSizes table to create the link would look like:
modelSizeID | modelSizeSizeID | modelSizeModelID
1 | 1 | 1
2 | 2 | 1
3 | 3 | 1
these are the columns you already have in your size table
no this is your existing size table. Like I say, I cannot open the Access database, so cannot give exact examples for your database structure.
if you wish to get one on one help creating this, you could purchase a premiere ticket, see the support landing page for details:
support/