Which is better

[cdoyle]

Hi,
I have 2 tables right now, for diffent code types.

I've been asked, to add a field for a report called 'Static Text', some codes will have extra text to display on the report. As far as I know, the text will only be used on certain code types.

So I'm wondering should I add a 'static text' column to each table? Or create a new whole new table named tbl_static_text. Then refer in each of my other tables to this new table???

Your Thoughts?

 

[John_W]

Is each piece of text specific to a particular code, or are some shared between codes? If not shared, I'd consider the text to be an attribute of the code and have a column in each table.

Having said that, are you sure you need two separate tables for codes? Why not hold all codes in a single table?