I created a form , I only have two tables Artist(ArtistID, Title, Artist, Product) and Products (Unique code, Product, Product Type, Product Category,Price)
these are linked by Product field..I created the form( with all the above except ArtistID and added a line of data it updated the Product...