Using one or multiple tables to hold comment data?

[jggtz]

You didn't say what is your database (SQL, Access, etc.) in order to know the field size limit
but you could use memo or maxchar fields to store the comments