SQL Table Error (table doesn't exist?)

[RodG]

Thanks for your reply. :)

Oh, I thought xkwies_handcrafteduk. was the name of the DB it was trying to access and products_3_for_2_flags was the table?

Am I wrong? If so, I'll have to find a way around it. :)

Not entirely wrong, but the quotes make a huge difference in this case. In other words, 'xkwies_handcrafteduk.products_3_for_2_flags' (with quotes) is looking for a table of this name in the currently opened database.

If you remove the quotes it will indeed be looking for a table named 'products_3_for_2_flags' in the 'xkwies_handcrafteduk' database.

Does this make it clearer?

Cheers
Rod