create new table question
I have a table with a growing number of fields (>100) up to now. I plan on adding about 200 more fields on it.
This, however would make the editing of the table&fields somewhat cumbersome, and i 'm also concerned that it may slow the db down. I 'd like to add the new fields in a separate table, that behaves like an extension to the parent table (each record from the new table is related to only one record on the parent one and vice versa). How should i set the relationships and IDs?