hi everyone-
i inheritrd a database that wasn't designed very well. i'm trying to
decide whether or not it is a good idea to add at least 8 more fields
to a table that already has existing records in it- about 800.
right now, a combo box records the reason why a particular person
called. i want to add 3 more combo boxes to record the other reasons
why someone called.
the table with the records in it has 6 six firlds. i want to add like
eight more fields. the records already in the database will not be
updated. we aren't going to go back to the old calls records and add
more reasons for the call. we're only going to start recording more
reasons why a person calls from now on or whenever i find the best
solution to this.
so is it safe/ ok to add more fields to a table that already has a lot
of existing records? in the different books i've read, the authors say
to never do this.
i'm thinking about creating a new table with all of the fields i need
and then somehow copying the old records and pasting them into the new
table. does this sound like a better idea?
thanks for your time,
miguelito