Updating multiple fields within a single table

[Guest]

Please help!

I have a single table “Professionals†and some fields. I have a field name
“Title_Quarter1†and another field “Title_Quarter2â€. Sometimes the titles of
these professionals change from quarter 1 to quarter 2 and I need to record
their old title and their new title (i.e. the reason why I have two title
fields). Is there a way that I can default the value of “Title_Quarter1†to
“Title_Quarter2� I don’t want the values of “Title_Quarter1†to change when
I make changes to “Title_Quarter2â€.

Your help will be greatly appreciated

 

[Joseph Meehan]

Please help!

I have a single table "Professionals" and some fields. I have a field
name "Title_Quarter1" and another field "Title_Quarter2". Sometimes
the titles of these professionals change from quarter 1 to quarter 2
and I need to record their old title and their new title (i.e. the
reason why I have two title fields). Is there a way that I can
default the value of "Title_Quarter1" to "Title_Quarter2"? I don't
want the values of "Title_Quarter1" to change when I make changes to
"Title_Quarter2".

Your help will be greatly appreciated

Your best bet will be to redesign your table(s). Having those two title
fields in the same record is a good sign that you need to rethink your table
design.

Read up on normalizing tables and if you have questions let us know. A
little more information on the table and its use would be helpful if you
need additional help.