The Magazines table has to contain ONLY 4 fields:
so that, in you example, it will contain 9 records ( but may easily grow )
Now the user will get the correct price using a simple relationship between the Orders table ( your current table ) and the Magazines table.
Thanks raybaudi. I have set up a table with those fields and made my nine records. I created the ID field to be a unique number.
I am struggling to work out how my client gets the information into each subscribers record from the two dropdown menus I have set up in the Orders Table.
What relationship are you thinking I should set up?