Mr_Cat - 4:38 pm on Feb 14, 2012 (gmt 0)
Blimey! That's so obvious I never thought of it :D
Of course it makes total sense. Having just a member ID means if that record is deleted in the members table is scuppers everything that references their name.
Thanks for that! Definately worthy of note.
That's the trouble with being new to something and taking one person on their word about something so general.
Cheers again, I need to sort that right now. Funny how the simple things sometimes escape you. It'll simplify a lot of my queries too! :)
You've positively made my day, apart from the obvious rewrites I now have in hand.