Thanks for your responses
I did omit to say that I am using Access 2003 and am a bit of a novice when it comes to this software.
The tables I have are as follows:
Product Table - ProductCode, ProductName, ProductCost, ProductPrice, ProductDesign
Artist Table - ArtistCode, ArtistName...