Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   Refreshing a Column Value in the Master Table (http://www.go4expert.com/forums/refreshing-column-value-master-table-t10666/)

Rabi 19May2008 12:47

Refreshing a Column Value in the Master Table
 
I have two tables - a MasterTable and a ChildTable - related by a field "PO_Number" (set as Primary key in the MasterTable)
There is a column "PO_Status" in the MasterTable and its corresponding column "Status" in the ChildTable.

I need to refresh a column in the MasterTable automatically, as below:

For a particular "PO_Number":
  • If the "Status" for All of the records (in the ChildTable) is blank; then the "PO_Status" of the MasterTable should display "Not done".
  • If the "Status" for any of the record (in the ChildTable) has a value "Done"; then the "PO_Status" of the MasterTable should display "Partially done".
  • If the "Status" for All the records (in the ChildTable) has a value "Done"; then the "PO_Status" of the MasterTable should display "Completed".
Help from the Access programmers will be highly appreciated.


All times are GMT +5.5. The time now is 09:26.