 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2007Updating Field based on another field
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.  SignatureHope that helps! RBear3 . >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 [quoted text clipped - 12 lines] > table, > which is linked by the Project_ID. Someone please help. 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. > Hmmm. Generally, you would not store the same information in two tables. > It kind of defeats the purpose of a relational database. Instead, just [quoted text clipped - 18 lines] > > table, > > which is linked by the Project_ID. Someone please help. 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. SignatureHope that helps! RBear3 . >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, [quoted text clipped - 28 lines] >> > table, >> > which is linked by the Project_ID. Someone please help. 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. > 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 [quoted text clipped - 32 lines] > >> > table, > >> > which is linked by the Project_ID. Someone please help. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.