Thanks Jason,
Where you write"the image path should be set by the database" should this be
the image path should NOT be set by the database?
In the past when using access I could create a composite field in an access query. It seems this is not possible with MySQL?