…. this may be more of a SQL design question
I have a series of tables that each need a child table for comments; the child table structure is the same for each parent table (except, of course, for the foreign key relationship).
Do I build multiple child tables?
Or is there a way to do it with one child table that includes a column to identify the parent table_name?
thank you -
mt in NY