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
In the recordset where does Size.sizeID, Size.SizeName come from? 
these are the columns you already have in your size table
Then, where does 'FROM Sizes' come from. Do i need to create a table called Sizes?
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/
