Sorry for the delay in replying - some idiotic builders cut through my phone cable so no internet access for most of the day!
Thanks R937 for your invaluable help on this and past issues!
My complete database structure is below:-
literature.ID (primary key) -- Autonumber
literature.author -- Text
literature.title -- Text
sculptures.ID (primary key) -- Autonumber
sculptures.Name -- Memo
sculptures.LiteratureCombine1 -- Text
sculptures.LiteratureCombine2 -- Text
sculptures.ArtistID (foreign key to Artist.NameURL) -- Text
sculptures.sculpturetypeID (foreign key to sculpturetype.TypeURL) -- Text
artist.FirstName -- Text
artist.Surname -- Text
artist.NameURL (primary key) -- Text
images.ID (primary key) -- Autonumber
images.ImgURL -- Text
images.sculpturesID (foreign key to sculptures.ID) -- Number
sculpturetype.ID -- Autonumber
sculpturetype.type -- Memo
sculpturetype.TypeURL (primary key) -- Text
You'll notice that my 'literature' table isn't joined to another within Access as it is joined by concatenating the two fields, literature.title and literature.author by SQL within an Access drop down box (not an ideal way of doing it, but that's what the client asked for) - this drop down box populates the fields sculptures.LiteratureCombine1 and sculptures.LiteratureCombine2 within Access.
So basically by concatenating the two fields within my SQL string within my ASP statement, the result gives me the same value as the sculptures.LiteratureCombine1 field - these two fields I want to join together in one of the JOIN clauses.
I think I'm a bit out of my depth as to what I'm doing but I'd like to think of myself as a fast learner and would be more than happy for someone to tell me where I'm going wrong!
Again, thanks Sitepoint members for helping me out on this matter, especially r937