Correct method to add extra fields to threads?

[Razasharp]

Harmor19 - thanks for the help (I think your hack works in a different way, whereby the 'fields' are actually forms, and the data entered simply gets appended to the post? If so any chance you doing one where the field data is stored in the db seperately? saves me the fuss and I could make a donation )

Paul - I was hoping for a general outline, but appreciate that's a bit too much to ask... prob easier if I post what I plan here and perhaps you guys can let me know if I'm on the right track or not?

So so far, I need a new table with fields. This seem ok? Have I missed anything? Do I need to index?

New table:
my_thread_fields

Fields:
ThreadID (key)
MYField 1
MYField 2
MYField 3
MYField 4
MYField 5
MYField 6
MYField 7

I will check out Harmor19's hack to see which bits are similar/I can learn from for the data to be input and updated through vB - I think this is where I'll get stuck the most!

Cheers,