1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Refreshing a Column Value in the Master Table

Discussion in 'MS Access' started by Rabi, May 19, 2008.

  1. Rabi

    Rabi New Member

    Joined:
    Mar 15, 2007
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    0
    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.
     

Share This Page