Thanks for replying Jason!
You lost me a little (actually a lot).
I create a new table called 'modelSizes' with the columns
modelSizeID - Primary key Column
modelSizeSizeID - Foreign key column, relates to size.sizeID
modelSizeModelID - Foreign key column, relates to model.modelID
What data do I put in these columns?
In the recordset where does Size.sizeID, Size.SizeName come from?
THen, where does 'FROM Sizes' come from. Do i need to create a table called Sizes?
Is itpossible you could provide an example form my database attachment I could build upon? Willing to pay if required. But, if I need to pay, I would like to have four columns where the 4th would be the price based on chain length.
Many Thanks for your assistance