Updating Field based on another field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table that is tracking completion of certain tasks and upon
completion of particular tasks I want to update the same field in a different
table. The structure for my tracking table is as follows:

Review_1
Review_2
Review_3
Review_4
Review_5
Review_6
Project_ID

I don't know how to update the Project_Phase field in my Project_Main table,
which is linked by the Project_ID. Someone please help.
 
Hmmm. Generally, you would not store the same information in two tables.
It kind of defeats the purpose of a relational database. Instead, just
refer to the other table when you need information from it. You can include
more than one related tables in a query so that data can be pulled from both
tables.
 
I understand that. Where I am running into difficulty is when I want to
update the one table, how do I automatically update the other field,
regardless of where it is located. I know that I need to write some sort of
IF Then statement or something similar to get this to work, but I just don't
know where to start.
 
I don't understand. You have a table with fields. You have that table tied
to a form and controls on that form relate to tables in your field. When
you update data on one of the controls, the underlying table is changed.
 
Let me better explain what I am trying to accomplish. I have a table that
tracks the completion of documentation and a table that houses project
specific information. Each table is linked by the Project_ID. Each project
has a number of phases that it must complete and the Reviews that I
originally mentioned are what I want to use as my control to determine which
phase a project is in. I have a field, project_phase, that displays which
phase a project is in and I want to update that field when one of the Review
fields is updated and becomes true. I don't know how to get the phase field
to update automatically so that the correct phase is displayed.
 
Back
Top